« Return to Thread: how to transpose a dataframe

Re: how to transpose a dataframe

by milton ruser :: Rate this Message:

Hi roachyang,

you need to be more precise on your email.
But believe that you tryed one of the funtions like reshape or transform and
the output has been printed on your R session. If your dataset are large, is
better you assign your output on a object - like myobj<-reshape(...) - and
then save your table using write.table()... our explore your dataset using
head() or tail().
Bests

milton

On Thu, Jul 9, 2009 at 11:21 PM, roachyang <roachyang@...> wrote:

>
> Seems like this is the one. But I got this message
> "reached getOption("max.print") -- omitted 12259 rows",
> and there are some data missing. What happened?
>
>
> Bill.Venables wrote:
> >
> > 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@... [r-help-bounces@...] On
> > Behalf Of roachyang [roachyang@...]
> > Sent: 10 July 2009 11:31
> > To: r-help@...
> > 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@... 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.
> >
> > ______________________________________________
> > R-help@... 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.
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/how-to-transpose-a-dataframe-tp24420450p24421173.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> R-help@... 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]]

______________________________________________
R-help@... 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.

« Return to Thread: how to transpose a dataframe