R help - Oct 2013 - Reshape

Hello,
 
I have data frame like the one created below,
 

 ##input data
Person <- c(1,1,1,1,1,1,2,2)
Amount <- c(100,10,100,10,100,10,50,150)
Date <- c("12/01/2012", "12/01/2012",
"01/01/2013","01/01/2013","02/01/2013","02/01/2013","12/01/2012","12/01/2012")
df <- data.frame(Person,Amount,Date)
 
I would like to transpose the Amount data so that I can get the total amount
paid by person and date.
So, it would look something like:
 
 
##Want it to look like:
 
Person Date              Amt1      Amt2
1          12/01/2012    100       10
1           01/01/2013   100       10
1           02/01/2013   100       10
2          12/01/2012     50        150
 
 
I have been working with reshape, but I am having trouble getting it to look
exactly right.
Thank you,
K

Hi,
Try:
library(plyr)
?res <-
reshape(ddply(df,.(Person),mutate,id=rep(1:2,length(Person)/2)),idvar=c("Person","Date"),timevar="id",direction="wide")
?colnames(res)[3:4] <- paste0("Amt",1:2)
rownames(res) <- 1:nrow(res)

? res
#? Person?????? Date Amt1 Amt2
#1????? 1 12/01/2012? 100?? 10
#2????? 1 01/01/2013? 100?? 10
#3????? 1 02/01/2013? 100?? 10
#4????? 2 12/01/2012?? 50? 150

A.K.


On Wednesday, October 16, 2013 11:54 PM, Kimberly Harris-McCoy <kmcreed32 at
hotmail.com> wrote:
Hello,

I have data frame like the one created below,


##input data
Person <- c(1,1,1,1,1,1,2,2)
Amount <- c(100,10,100,10,100,10,50,150)
Date <- c("12/01/2012", "12/01/2012",
"01/01/2013","01/01/2013","02/01/2013","02/01/2013","12/01/2012","12/01/2012")
df <- data.frame(Person,Amount,Date)

I would like to transpose the Amount data so that I can get the total amount
paid by person and date.
So, it would look something like:


##Want it to look like:

Person Date? ? ? ? ? ? ? Amt1? ? ? Amt2
1? ? ? ? ? 12/01/2012? ? 100? ? ?  10
1? ? ? ? ?  01/01/2013?  100? ? ?  10
1? ? ? ? ?  02/01/2013?  100? ? ?  10
2? ? ? ? ? 12/01/2012? ?  50? ? ? ? 150


I have been working with reshape, but I am having trouble getting it to look
exactly right.
Thank you,
K ??? ???  ??? ?  ??? ??? ? 
______________________________________________
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.