[R] transposition problem

Geoff Russell geoffrey.russell at gmail.com
Wed Apr 16 13:28:33 CEST 2008


Many thanks -- the "unname" makes all the difference.

Geoff.

On 4/16/08, Henrique Dallazuanna <wwwhsd at gmail.com> wrote:
> Try this:
>
> x <- read.table(textConnection("\"1989-90\",\"1990-91\"
> Barley,23,34
> Oats,15,16"), sep = ",", header = T, check.names = FALSE)
>
> t(x)
>
> or if you want year as column and not rownames:
>
> data.frame(Year = names(x), t(unname(x)))
>
>
>
> On Wed, Apr 16, 2008 at 7:27 AM, Geoff Russell <geoffrey.russell at gmail.com>
> wrote:
>
> >
> > Hi use Rs,
> >
> > I have a csv file:
> >
> > "1989-90","1990-91"
> > Barley,23,34
> > Oats,15,16
> >
> > Which I want to turn into:
> >    year,  Barley, Oats
> > 1 "1989-90", 23, 15
> > 2 "1990-91",34,16
> >
> > Transpose doesn't quite do it, is there a standard way?
> >
> > Cheers,
> >
> > Geoff Russell
> >
> > ______________________________________________
> > 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.
> >
>
>
>
> --
> Henrique Dallazuanna
> Curitiba-Paraná-Brasil
> 25° 25' 40" S 49° 16' 22" O


-- 
6 Fifth Ave,
St Morris, S.A. 5068
Australia
Ph: 041 8805 184 / 08 8332 5069



More information about the R-help mailing list