Ufdjrw

How can I prevent/balance waiting and turtling as a response to cooldown mechanics

Can an iPhone 7 be made to function as a NFC Tag?

How to change the tick of the color bar legend to black

Is openssl rand command cryptographically secure?

The Nth Gryphon Number

What does Turing mean by this statement?

What does it mean that physics no longer uses mechanical models to describe phenomena?

Is multiple magic items in one inherently imbalanced?

How to write capital alpha?

Rationale for describing kurtosis as "peakedness"?

What is the role of と after a noun when it doesn't appear to count or list anything?

How can god fight other gods?

Asymptotics question

What order were files/directories output in dir?

Delete free apps from library

Most effective melee weapons for arboreal combat? (pre-gunpowder technology)

Mounting TV on a weird wall that has some material between the drywall and stud

Why not use the yoke to control yaw, as well as pitch and roll?

AppleTVs create a chatty alternate WiFi network

Nose gear failure in single prop aircraft: belly landing or nose-gear up landing?

Did Mueller's report provide an evidentiary basis for the claim of Russian govt election interference via social media?

In musical terms, what properties are varied by the human voice to produce different words / syllables?

How many time has Arya actually used Needle?

Tips to organize LaTeX presentations for a semester

R Datafram Manipulation for ANOVA [duplicate]

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

This question already has an answer here:

• 
  Reshaping data.frame from wide to long format
  
  6 answers
  
  


• 
  How to reshape data from long to wide format
  
  9 answers
  
  

I have a dataframe comprising of 300 variables with four observations each. For instance, one of the variables looks like this.

Afghanistan
34
34
56
45

I'm doing an ANOVA so I need the data to look like:

Afghanistan 34
Afghanistan 34
Afghanistan 56
Afghanistan 45

How do I do this for all 300 variables? My reasoning is so that I can use the aov function to run the anova. In this case the country is considered to be a treatment, and with 4 observations from each treatment. Any guidance will be appreciated!

r dataframe

share|improve this question

asked Mar 8 at 23:24

Abby LiuAbby Liu

154

marked as duplicate by divibisan, camille, Parfait, Community♦ Mar 9 at 18:47

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @divibisan they're trying to go long to wide, not wide to long. Either way, there are plenty of dupes
  
  – camille
  Mar 9 at 0:27
  

  
  
  
  

add a comment | 

0

This question already has an answer here:

• 
  Reshaping data.frame from wide to long format
  
  6 answers
  
  


• 
  How to reshape data from long to wide format
  
  9 answers
  
  

I have a dataframe comprising of 300 variables with four observations each. For instance, one of the variables looks like this.

Afghanistan
34
34
56
45

I'm doing an ANOVA so I need the data to look like:

Afghanistan 34
Afghanistan 34
Afghanistan 56
Afghanistan 45

How do I do this for all 300 variables? My reasoning is so that I can use the aov function to run the anova. In this case the country is considered to be a treatment, and with 4 observations from each treatment. Any guidance will be appreciated!

r dataframe

share|improve this question

asked Mar 8 at 23:24

Abby LiuAbby Liu

154

marked as duplicate by divibisan, camille, Parfait, Community♦ Mar 9 at 18:47

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @divibisan they're trying to go long to wide, not wide to long. Either way, there are plenty of dupes
  
  – camille
  Mar 9 at 0:27
  

  
  
  
  

add a comment | 

This question already has an answer here:

• 
  Reshaping data.frame from wide to long format
  
  6 answers
  
  


• 
  How to reshape data from long to wide format
  
  9 answers
  
  

I have a dataframe comprising of 300 variables with four observations each. For instance, one of the variables looks like this.

Afghanistan
34
34
56
45

I'm doing an ANOVA so I need the data to look like:

Afghanistan 34
Afghanistan 34
Afghanistan 56
Afghanistan 45

How do I do this for all 300 variables? My reasoning is so that I can use the aov function to run the anova. In this case the country is considered to be a treatment, and with 4 observations from each treatment. Any guidance will be appreciated!

r dataframe

share|improve this question

asked Mar 8 at 23:24

Abby LiuAbby Liu

154

Afghanistan
34
34
56
45

Afghanistan 34
Afghanistan 34
Afghanistan 56
Afghanistan 45

share|improve this question

asked Mar 8 at 23:24

Abby LiuAbby Liu

154

share|improve this question

asked Mar 8 at 23:24

Abby LiuAbby Liu

154

asked Mar 8 at 23:24

Abby LiuAbby Liu

154

asked Mar 8 at 23:24

Abby LiuAbby Liu

154

1 Answer
1

active

oldest

votes

0

As divibisan's comment suggests, this question is quite similar to other questions on Stack Overflow. You problem is fairly common in data processing projects, what you are trying to accomplish is referred to as "Transforming the data from a wide to long format."

There are many R packages which come with built in functions to accomplish this task, such as reshape() or melt/cast from the reshape2 package. However, if you are uncomfortable using these functions as a "black box" solution here is a way you could manually construct the desired data set.

 ex<-data.frame(USA=1:4, FRANCE=5:8)
 ex

 USA FRANCE
 1 5
 2 6
 3 7
 4 8


 country<-names(ex)
 country_names<-c()
 vals<-c()

 for (i in 1:ncol(ex))

 country_names<-c(country_names,(rep(country[i],4)))

 vals<-c(vals,ex[,i])

 

 transformed<-data.frame(country=country_names, value = vals)

 transformed

 country value
 USA 1
 USA 2
 USA 3
 USA 4
 FRANCE 5
 FRANCE 6
 FRANCE 7
 FRANCE 8

share|improve this answer

answered Mar 9 at 0:18

M.BergenM.Bergen

1007

add a comment | 

0

As divibisan's comment suggests, this question is quite similar to other questions on Stack Overflow. You problem is fairly common in data processing projects, what you are trying to accomplish is referred to as "Transforming the data from a wide to long format."

There are many R packages which come with built in functions to accomplish this task, such as reshape() or melt/cast from the reshape2 package. However, if you are uncomfortable using these functions as a "black box" solution here is a way you could manually construct the desired data set.

 ex<-data.frame(USA=1:4, FRANCE=5:8)
 ex

 USA FRANCE
 1 5
 2 6
 3 7
 4 8


 country<-names(ex)
 country_names<-c()
 vals<-c()

 for (i in 1:ncol(ex))

 country_names<-c(country_names,(rep(country[i],4)))

 vals<-c(vals,ex[,i])

 

 transformed<-data.frame(country=country_names, value = vals)

 transformed

 country value
 USA 1
 USA 2
 USA 3
 USA 4
 FRANCE 5
 FRANCE 6
 FRANCE 7
 FRANCE 8

share|improve this answer

answered Mar 9 at 0:18

M.BergenM.Bergen

1007

add a comment | 

0

As divibisan's comment suggests, this question is quite similar to other questions on Stack Overflow. You problem is fairly common in data processing projects, what you are trying to accomplish is referred to as "Transforming the data from a wide to long format."

There are many R packages which come with built in functions to accomplish this task, such as reshape() or melt/cast from the reshape2 package. However, if you are uncomfortable using these functions as a "black box" solution here is a way you could manually construct the desired data set.

 ex<-data.frame(USA=1:4, FRANCE=5:8)
 ex

 USA FRANCE
 1 5
 2 6
 3 7
 4 8


 country<-names(ex)
 country_names<-c()
 vals<-c()

 for (i in 1:ncol(ex))

 country_names<-c(country_names,(rep(country[i],4)))

 vals<-c(vals,ex[,i])

 

 transformed<-data.frame(country=country_names, value = vals)

 transformed

 country value
 USA 1
 USA 2
 USA 3
 USA 4
 FRANCE 5
 FRANCE 6
 FRANCE 7
 FRANCE 8

share|improve this answer

answered Mar 9 at 0:18

M.BergenM.Bergen

1007

add a comment | 

As divibisan's comment suggests, this question is quite similar to other questions on Stack Overflow. You problem is fairly common in data processing projects, what you are trying to accomplish is referred to as "Transforming the data from a wide to long format."

There are many R packages which come with built in functions to accomplish this task, such as reshape() or melt/cast from the reshape2 package. However, if you are uncomfortable using these functions as a "black box" solution here is a way you could manually construct the desired data set.

 ex<-data.frame(USA=1:4, FRANCE=5:8)
 ex

 USA FRANCE
 1 5
 2 6
 3 7
 4 8


 country<-names(ex)
 country_names<-c()
 vals<-c()

 for (i in 1:ncol(ex))

 country_names<-c(country_names,(rep(country[i],4)))

 vals<-c(vals,ex[,i])

 

 transformed<-data.frame(country=country_names, value = vals)

 transformed

 country value
 USA 1
 USA 2
 USA 3
 USA 4
 FRANCE 5
 FRANCE 6
 FRANCE 7
 FRANCE 8

share|improve this answer

answered Mar 9 at 0:18

M.BergenM.Bergen

1007

 ex<-data.frame(USA=1:4, FRANCE=5:8)
 ex

 USA FRANCE
 1 5
 2 6
 3 7
 4 8


 country<-names(ex)
 country_names<-c()
 vals<-c()

 for (i in 1:ncol(ex))

 country_names<-c(country_names,(rep(country[i],4)))

 vals<-c(vals,ex[,i])

 

 transformed<-data.frame(country=country_names, value = vals)

 transformed

 country value
 USA 1
 USA 2
 USA 3
 USA 4
 FRANCE 5
 FRANCE 6
 FRANCE 7
 FRANCE 8

share|improve this answer

answered Mar 9 at 0:18

M.BergenM.Bergen

1007

answered Mar 9 at 0:18

M.BergenM.Bergen

1007

answered Mar 9 at 0:18

M.BergenM.Bergen

1007