thr3ads.net - R help - [R] Simple reshape problem I am completely missing [Jul 2012]

If this information is useful, please help other people find it:
Share via:

John Kane

2012-Jul-24 17:17 UTC

[R] Simple reshape problem I am completely missing

I seem to be doing something really stupid or missing something really obvious 
but what?

I have a simple three column data.frame that I would like to reshape to wide
preferably using reshape2.

An example from
http://stackoverflow.com/questions/9617348/reshape-three-column-data-frame-to-matrix
looked perfect except I wanted a data frame but it seemed okay. I just changed
acast to dcast and it seems fine.

Stackoverflow example:
tmp <- data.frame(x=gl(2,3, labels=letters[24:25]),
                  y=gl(3,1,6, labels=letters[1:3]), 
                  z=c(1,2,3,3,3,2))
dd  <-  dcast(tmp, x~y, value.var="z")

My Example: Does NOT work

md2  <-  structure(list(group = structure(c(1L, 1L, 1L, 2L, 2L, 3L, 3L, 
4L, 4L, 4L, 5L, 5L, 6L, 6L, 7L, 7L, 7L, 8L, 8L), .Label = c("X1", 
"X2", "X3", "X4", "X5", "X6",
"X7", "X8"), class = "factor"),
    tps = structure(c(7L, 12L, 14L, 4L, 8L, 9L, 16L, 6L, 7L, 
    11L, 6L, 15L, 10L, 13L, 3L, 4L, 5L, 1L, 2L), .Label = c("A", 
    "C", "D", "E", "G", "I",
"L", "M", "N", "P", "Q",
"R", "S",
    "T", "V", "Y"), class = "factor"),
sum = c(0.914913196595112,
    0.0367565080432513, 0.0483302953616366, 0.982727803634948, 
    0.0172721963650521, 0.0483302953616366, 0.951669704638363, 
    0.89764100023006, 0.0850868034048879, 0.0172721963650521, 
    0.951669704638363, 0.0483302953616366, 0.963243491956749, 
    0.0367565080432513, 0.89764100023006, 0.0540287044083034, 
    0.0483302953616366, 0.982727803634948, 0.0172721963650521
    )), .Names = c("group", "tps", "sum"),
row.names = c(NA,
-19L), class = "data.frame")

dcast(md2,  group ~ tps , value.vars  = "sum")


What am I doing wrong?

John Kane
Kingston ON Canada

____________________________________________________________
FREE ONLINE PHOTOSHARING - Share your photos online with your friends and
family!
Visit http://www.inbox.com/photosharing to find out more!

jose Bartolomei

2012-Jul-24 17:23 UTC

head link

[R] Simple reshape problem I am completely missing

Did you melt first?

library(reshape2)
?melt
> Date: Tue, 24 Jul 2012 09:17:08 -0800
> From: jrkrideau@inbox.com
> To: r-help@r-project.org
> Subject: [R] Simple reshape problem I am completely missing
> 
> I seem to be doing something really stupid or missing something really
obvious  but what?
> 
> I have a simple three column data.frame that I would like to reshape to
wide preferably using reshape2.
> 
> An example from
http://stackoverflow.com/questions/9617348/reshape-three-column-data-frame-to-matrix
looked perfect except I wanted a data frame but it seemed okay. I just changed
acast to dcast and it seems fine.
> 
> Stackoverflow example:
> tmp <- data.frame(x=gl(2,3, labels=letters[24:25]),
>                   y=gl(3,1,6, labels=letters[1:3]), 
>                   z=c(1,2,3,3,3,2))
> dd  <-  dcast(tmp, x~y, value.var="z")
> 
> My Example: Does NOT work
> 
> md2  <-  structure(list(group = structure(c(1L, 1L, 1L, 2L, 2L, 3L, 3L, 
> 4L, 4L, 4L, 5L, 5L, 6L, 6L, 7L, 7L, 7L, 8L, 8L), .Label = c("X1",
> "X2", "X3", "X4", "X5",
"X6", "X7", "X8"), class = "factor"),
>     tps = structure(c(7L, 12L, 14L, 4L, 8L, 9L, 16L, 6L, 7L, 
>     11L, 6L, 15L, 10L, 13L, 3L, 4L, 5L, 1L, 2L), .Label = c("A", 
>     "C", "D", "E", "G",
"I", "L", "M", "N", "P",
"Q", "R", "S",
>     "T", "V", "Y"), class =
"factor"), sum = c(0.914913196595112,
>     0.0367565080432513, 0.0483302953616366, 0.982727803634948, 
>     0.0172721963650521, 0.0483302953616366, 0.951669704638363, 
>     0.89764100023006, 0.0850868034048879, 0.0172721963650521, 
>     0.951669704638363, 0.0483302953616366, 0.963243491956749, 
>     0.0367565080432513, 0.89764100023006, 0.0540287044083034, 
>     0.0483302953616366, 0.982727803634948, 0.0172721963650521
>     )), .Names = c("group", "tps", "sum"),
row.names = c(NA,
> -19L), class = "data.frame")
> 
> dcast(md2,  group ~ tps , value.vars  = "sum")
> 
> 
> What am I doing wrong?
> 
> John Kane
> Kingston ON Canada
> 
> ____________________________________________________________
> FREE ONLINE PHOTOSHARING - Share your photos online with your friends and
family!
> Visit http://www.inbox.com/photosharing to find out more!
> 
> ______________________________________________
> 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. 		 	   		  
	[[alternative HTML version deleted]]

arun

2012-Jul-24 17:45 UTC

head link

[R] Simple reshape problem I am completely missing

HI,

I think your group and tps variables have a lot of levels, so the combinations
which are not there might end up as NA.


Try this:
?md4<-data.frame(group=c(rep("X1",3),rep("X2",3)),tps=c("L","R","P","L","R","P"),sum=rnorm(6,15))> md4? group tps????? sum
1??? X1?? L 13.94542
2??? X1?? R 14.34785
3??? X1?? P 15.31574
4??? X2?? L 14.50404
5??? X2?? R 13.73331
6??? X2?? P 14.69673>? dd? <-? dcast(md4, group~tps, value.var="sum")
> dd? group??????? L??????? P??????? R
1??? X1 13.94542 15.31574 14.34785
2??? X2 14.50404 14.69673 13.73331

A.K.




----- Original Message -----
From: John Kane <jrkrideau at inbox.com>
To: r-help at r-project.org
Cc: 
Sent: Tuesday, July 24, 2012 1:17 PM
Subject: [R] Simple reshape problem I am completely missing

I seem to be doing something really stupid or missing something really obvious?
but what?

I have a simple three column data.frame that I would like to reshape to wide
preferably using reshape2.

An example from
http://stackoverflow.com/questions/9617348/reshape-three-column-data-frame-to-matrix
looked perfect except I wanted a data frame but it seemed okay. I just changed
acast to dcast and it seems fine.

Stackoverflow example:
tmp <- data.frame(x=gl(2,3, labels=letters[24:25]),
? ? ? ? ? ? ? ? ? y=gl(3,1,6, labels=letters[1:3]), 
? ? ? ? ? ? ? ? ? z=c(1,2,3,3,3,2))
dd? <-? dcast(tmp, x~y, value.var="z")

My Example: Does NOT work

md2? <-? structure(list(group = structure(c(1L, 1L, 1L, 2L, 2L, 3L, 3L, 
4L, 4L, 4L, 5L, 5L, 6L, 6L, 7L, 7L, 7L, 8L, 8L), .Label = c("X1", 
"X2", "X3", "X4", "X5", "X6",
"X7", "X8"), class = "factor"),
? ? tps = structure(c(7L, 12L, 14L, 4L, 8L, 9L, 16L, 6L, 7L, 
? ? 11L, 6L, 15L, 10L, 13L, 3L, 4L, 5L, 1L, 2L), .Label = c("A", 
? ? "C", "D", "E", "G", "I",
"L", "M", "N", "P", "Q",
"R", "S",
? ? "T", "V", "Y"), class = "factor"),
sum = c(0.914913196595112,
? ? 0.0367565080432513, 0.0483302953616366, 0.982727803634948, 
? ? 0.0172721963650521, 0.0483302953616366, 0.951669704638363, 
? ? 0.89764100023006, 0.0850868034048879, 0.0172721963650521, 
? ? 0.951669704638363, 0.0483302953616366, 0.963243491956749, 
? ? 0.0367565080432513, 0.89764100023006, 0.0540287044083034, 
? ? 0.0483302953616366, 0.982727803634948, 0.0172721963650521
? ? )), .Names = c("group", "tps", "sum"),
row.names = c(NA,
-19L), class = "data.frame")

dcast(md2,? group ~ tps , value.vars? = "sum")


What am I doing wrong?

John Kane
Kingston ON Canada

____________________________________________________________
FREE ONLINE PHOTOSHARING - Share your photos online with your friends and
family!
Visit http://www.inbox.com/photosharing to find out more!

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

John Kane

2012-Jul-24 18:17 UTC

head link

[R] Simple reshape problem I am completely missing

Looks like it. thanks

Now all I have to do is figgure out how to get rid of all the missing combos. 
Oh well another dat
thanks

John Kane
Kingston ON Canada

> -----Original Message-----
> From: smartpink111 at yahoo.com
> Sent: Tue, 24 Jul 2012 10:45:18 -0700 (PDT)
> To: jrkrideau at inbox.com
> Subject: Re: [R] Simple reshape problem I am completely missing
> 
> HI,
> 
> I think your group and tps variables have a lot of levels, so the
> combinations which are not there might end up as NA.
> 
> 
> Try this:
>
?md4<-data.frame(group=c(rep("X1",3),rep("X2",3)),tps=c("L","R","P","L","R","P"),sum=rnorm(6,15))
>> md4
> ? group tps????? sum
> 1??? X1?? L 13.94542
> 2??? X1?? R 14.34785
> 3??? X1?? P 15.31574
> 4??? X2?? L 14.50404
> 5??? X2?? R 13.73331
> 6??? X2?? P 14.69673
> >? dd? <-? dcast(md4, group~tps, value.var="sum")
>> dd
> ? group??????? L??????? P??????? R
> 1??? X1 13.94542 15.31574 14.34785
> 2??? X2 14.50404 14.69673 13.73331
> 
> A.K.
> 
> 
> 
> 
> ----- Original Message -----
> From: John Kane <jrkrideau at inbox.com>
> To: r-help at r-project.org
> Cc:
> Sent: Tuesday, July 24, 2012 1:17 PM
> Subject: [R] Simple reshape problem I am completely missing
> 
> I seem to be doing something really stupid or missing something really
> obvious? but what?
> 
> I have a simple three column data.frame that I would like to reshape to
> wide preferably using reshape2.
> 
> An example from
http://stackoverflow.com/questions/9617348/reshape-three-column-data-frame-to-matrix> looked perfect except I wanted a data frame but it seemed okay. I just
> changed acast to dcast and it seems fine.
> 
> Stackoverflow example:
> tmp <- data.frame(x=gl(2,3, labels=letters[24:25]),
> ? ? ? ? ? ? ? ? ? y=gl(3,1,6, labels=letters[1:3]),
> ? ? ? ? ? ? ? ? ? z=c(1,2,3,3,3,2))
> dd? <-? dcast(tmp, x~y, value.var="z")
> 
> My Example: Does NOT work
> 
> md2? <-? structure(list(group = structure(c(1L, 1L, 1L, 2L, 2L, 3L, 3L,
> 4L, 4L, 4L, 5L, 5L, 6L, 6L, 7L, 7L, 7L, 8L, 8L), .Label = c("X1",
> "X2", "X3", "X4", "X5",
"X6", "X7", "X8"), class = "factor"),
> ? ? tps = structure(c(7L, 12L, 14L, 4L, 8L, 9L, 16L, 6L, 7L,
> ? ? 11L, 6L, 15L, 10L, 13L, 3L, 4L, 5L, 1L, 2L), .Label = c("A",
> ? ? "C", "D", "E", "G",
"I", "L", "M", "N", "P",
"Q", "R", "S",
> ? ? "T", "V", "Y"), class =
"factor"), sum = c(0.914913196595112,
> ? ? 0.0367565080432513, 0.0483302953616366, 0.982727803634948,
> ? ? 0.0172721963650521, 0.0483302953616366, 0.951669704638363,
> ? ? 0.89764100023006, 0.0850868034048879, 0.0172721963650521,
> ? ? 0.951669704638363, 0.0483302953616366, 0.963243491956749,
> ? ? 0.0367565080432513, 0.89764100023006, 0.0540287044083034,
> ? ? 0.0483302953616366, 0.982727803634948, 0.0172721963650521
> ? ? )), .Names = c("group", "tps", "sum"),
row.names = c(NA,
> -19L), class = "data.frame")
> 
> dcast(md2,? group ~ tps , value.vars? = "sum")
> 
> 
> What am I doing wrong?
> 
> John Kane
> Kingston ON Canada
> 
> ____________________________________________________________
> FREE ONLINE PHOTOSHARING - Share your photos online with your friends and
> family!
> Visit http://www.inbox.com/photosharing to find out more!
> 
> ______________________________________________
> 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.
____________________________________________________________
FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!

Possibly Parallel Threads

Search for more reasonably related threads

R help - Jul 2012 - Simple reshape problem I am completely missing

[R] Simple reshape problem I am completely missing

[R] Simple reshape problem I am completely missing

[R] Simple reshape problem I am completely missing

[R] Simple reshape problem I am completely missing

Possibly Parallel Threads