R help - Apr 2008 - transposition problem

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

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@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@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]]