I want to transpose a dataframe like
level 2006 2007 2008
A ....
B .....
C ........
into
level year
A 2006
A 2007
A 2008
B 2006
B 2007
......
There is a procedure in SAS can do this, is there any function in R can do
this?
--
View this message in context:
http://www.nabble.com/how-to-transpose-a-dataframe-tp24420450p24420450.html
Sent from the R help mailing list archive at Nabble.com.
On 10/07/2009, at 1:31 PM, roachyang wrote:> > I want to transpose a dataframe like > level 2006 2007 2008 > A .... > B ..... > C ........ > into > level year > A 2006 > A 2007 > A 2008 > B 2006 > B 2007 > ...... > There is a procedure in SAS can do this, is there any function in R > can do > this?(a) ***Anything*** can be done in R; if there isn't a function to do it, you can write one. (b) ``Transpose'' is ***NOT*** the right word. You probably mean ``transform''. (c) See ?reshape. cheers, Rolf Turner ###################################################################### Attention:\ This e-mail message is privileged and confid...{{dropped:9}}
Hi there, ?reshape do the job. bests milton On Thu, Jul 9, 2009 at 9:31 PM, roachyang <roachyang@gmail.com> wrote:> > I want to transpose a dataframe like > level 2006 2007 2008 > A .... > B ..... > C ........ > into > level year > A 2006 > A 2007 > A 2008 > B 2006 > B 2007 > ...... > There is a procedure in SAS can do this, is there any function in R can do > this? > > -- > View this message in context: > http://www.nabble.com/how-to-transpose-a-dataframe-tp24420450p24420450.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@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<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]
try this: transform(stack(DF, select = -level), values = DF$level) On Thu, Jul 9, 2009 at 10:30 PM, roachyang <roachyang@gmail.com> wrote:> > I want to transpose a dataframe like > level 2006 2007 2008 > A .... > B ..... > C ........ > into > level year > A 2006 > A 2007 > A 2008 > B 2006 > ...... > There is a procedure in SAS can do this, is there any function in R can do > this? > > -- > View this message in context: > http://www.nabble.com/how-to-transpose-a-dataframe-tp24420450p24420450.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@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. >-- Henrique Dallazuanna Curitiba-Paraná-Brasil 25° 25' 40" S 49° 16' 22" O [[alternative HTML version deleted]]
Look at the 'reshape' package, with functions melt() and cast()
(I'm not sure how the remark about the virtues of SAS is relevant, but if
you really want SAS, I presume you know where to find it.)
________________________________________
From: r-help-bounces at r-project.org [r-help-bounces at r-project.org] On
Behalf Of roachyang [roachyang at gmail.com]
Sent: 10 July 2009 11:31
To: r-help at r-project.org
Subject: [R] how to transpose a dataframe
I want to transpose a dataframe like
level 2006 2007 2008
A ....
B .....
C ........
into
level year
A 2006
A 2007
A 2008
B 2006
B 2007
......
There is a procedure in SAS can do this, is there any function in R can do
this?
--
View this message in context:
http://www.nabble.com/how-to-transpose-a-dataframe-tp24420450p24420450.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
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.