[R] Data frame organization

Sam Charya @@mch@ry@ @end|ng |rom y@hoo@com@@u
Mon Aug 26 21:19:54 CEST 2019


 Dear Arnaud,
I just played around with your data a bit and found this to be useful. But kindly note that I am NO expert like the other people in the group. My answer to you is purely for help purposes. My knowledge in R too is limited. I used the reshape function and arrived at something. I am sure others will arrive at a better and more crisp answer that I have. Again please note: I am only a novice.
x <- c('A', 'B', 'C', 'A', 'B', 'C')y <- c(10, 5, 9, 5, 15, 20)df <- data.frame(x,y)dff <- reshape(df, v.names = "y", idvar = "x", timevar = "y", direction = "wide")
RESULT:
> f  x y.10 y.5 y.9 y.15 y.201 A   10   5  NA   NA   NA2 B   NA   5  NA   15   NA3 C   NA  NA   9   NA   20

Hope this is of any use. 
Kind Regards,
s. 

    On Monday, 26 August 2019, 11:37:13 pm GMT+5:30, Arnaud Mosnier <a.mosnier using gmail.com> wrote:  
 
 Hi,

I have a really simple question.
I need to convert a data.frame with the following format

A  10
B  5
C  9
A  5
B  15
C  20

in this format

A  10  5
B  5    15
C  9    20

Thanks !!!

    [[alternative HTML version deleted]]

______________________________________________
R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
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.
  
	[[alternative HTML version deleted]]



More information about the R-help mailing list