df2<-melt(df1)
df3<-cast(df2,Index~Name)
df3
HTH,
Daniel
Dana Sevak wrote:
>
> I realize that this is terribly basic, but I just don't seem to see it at
> this moment, so I would very much appreciate your help.
>
>
> How shall I transform this dataframe:
>
>> df1
> Name Index Value
> 1 a 1 0.1
> 2 a 2 0.2
> 3 a 3 0.3
> 4 a 4 0.4
> 5 b 1 2.1
> 6 b 2 2.2
> 7 b 3 2.3
> 8 b 4 2.4
>
>
> into this dataframe:
>
>> df2
> Index a b
> 1 1 0.1 2.1
> 2 2 0.2 2.2
> 3 3 0.3 2.3
> 4 4 0.4 2.4
>
>
> df1 = data.frame(c("a", "a", "a", "a", "b", "b", "b", "b"),
> c(1,2,3,4,1,2,3,4), c(0.1, 0.2, 0.3, 0.4, 2.1, 2.2, 2.3, 2.4))
> colnames(df1) = c("Name", "Index", "Value")
>
> df2 = data.frame(c(1,2,3,4), c(0.1, 0.2, 0.3, 0.4), c(2.1, 2.2, 2.3, 2.4))
> colnames(df2) = c("Index", "a", "b")
>
>
> Thank you very much.
>
> Dana
>
>
> ______________________________________________
> 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.
>
--
View this message in context:
http://r.789695.n4.nabble.com/Help-with-cast-reshape-tp3862176p3862404.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.
