[R] question: data.frame data conversion

arun smartpink111 at yahoo.com
Sun Aug 4 19:29:33 CEST 2013


#actually, this would be more compact

data.frame(split(z[,-1],z$x))

A.K.

----- Original Message -----
From: arun <smartpink111 at yahoo.com>
To: Brijesh Gulati <brijgul at gmail.com>
Cc: R help <r-help at r-project.org>
Sent: Sunday, August 4, 2013 1:27 PM
Subject: Re: [R] question: data.frame data conversion

Hi,
May be:
z<-data.frame(x,y,stringsAsFactors=FALSE)


 simplify2array(split(z[,-1],z$x))
#       a    b
#[1,] 1.0 1.01
#[2,] 1.2 1.03
#[3,] 1.1 1.00
 as.data.frame(simplify2array(split(z[,-1],z$x)))



A.K.

----- Original Message -----
From: Brijesh Gulati <brijgul at gmail.com>
To: r-help at r-project.org
Cc: 
Sent: Sunday, August 4, 2013 8:49 AM
Subject: [R] question: data.frame data conversion

Hello, I have a data.frame with repeating rows and corresponding value. For
instance, "z" will be an example of that. 

  

x = c("a","a", "a", "b","b","b")

  y = c(1.0, 1.2, 1.1, 1.01, 1.03, 1.0)

  z = as.data.frame(cbind(x,y))



> z

  x    y

1 a    1

2 a  1.2

3 a  1.1

4 b 1.01

5 b 1.03

6 b    1



So, you see that "a" and "b" are repeated 3 times and have three different
value. I would like to convert this data into something like the following. 



   a    b
  1.0 1.01
  1.2 1.03
  1.1 1.00



In the above, repeating rows (a,b) become columns and their values show up
in their respective column. 

Finally, to clarify few things. The number of rows of each repeating item
(a or b) would be the same and hence, the number of row expected in the
output shall be the same. 




    [[alternative HTML version deleted]]

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.




More information about the R-help mailing list