R › R help

how to transpose a dataframe

7 messages

how to transpose a dataframe

Reply Threaded

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?

Rolf Turner

Re: how to transpose a dataframe

Reply Threaded

On 10/07/2009, at 1:31 PM, roachyang wrote:

(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}}

______________________________________________
[hidden email] 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.

milton ruser

Re: how to transpose a dataframe

Reply Threaded

In reply to this post by roachyang

Hi there,

?reshape do the job.

bests
milton

On Thu, Jul 9, 2009 at 9:31 PM, roachyang <[hidden email]> 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.
>
> ______________________________________________
> [hidden email] 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]]

______________________________________________
[hidden email] 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

Re: how to transpose a dataframe

Reply Threaded

In reply to this post by roachyang

try this:

transform(stack(DF, select = -level), values = DF$level)

On Thu, Jul 9, 2009 at 10:30 PM, roachyang <[hidden email]> 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.
>
> ______________________________________________
> [hidden email] 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]]

______________________________________________
[hidden email] 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.

Bill.Venables

Re: how to transpose a dataframe

Reply Threaded

In reply to this post by roachyang

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: [hidden email] [[hidden email]] On Behalf Of roachyang [[hidden email]]
Sent: 10 July 2009 11:31
To: [hidden email]
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.

______________________________________________
[hidden email] 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.

______________________________________________
[hidden email] 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.

roachyang

Re: how to transpose a dataframe

Reply Threaded

In reply to this post by roachyang

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: [hidden email] [[hidden email]] On
> Behalf Of roachyang [[hidden email]]
> Sent: 10 July 2009 11:31
> To: [hidden email]
> 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.
>
> ______________________________________________
> [hidden email] 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.
>
> ______________________________________________
> [hidden email] 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.
>
>

--
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.

______________________________________________
[hidden email] 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.

milton ruser

Re: how to transpose a dataframe

Reply Threaded

In reply to this post by roachyang

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 <[hidden email]> 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: [hidden email] [[hidden email]] On
> > Behalf Of roachyang [[hidden email]]
> > Sent: 10 July 2009 11:31
> > To: [hidden email]
> > 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.
> >
> > ______________________________________________
> > [hidden email] 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.
> >
> > ______________________________________________
> > [hidden email] 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.
>
> ______________________________________________
> [hidden email] 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.
>