On 11/21/07, Punit Anand <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> Since the fields in variables column are unique with respect to ID and
> fiscal year; any function like
> sum,min,max,mean etc will lead to the desired result
You should probably check that, as the warning only occurs when
aggregation is definitely occurring.
> Therefore cast(dataread, ID + Period ~ variable,sum)
> Will lead to the desired result in my case;
If you want a list of data frames by ID, you might also want to try:
cast(dataread, Period ~ variable | ID, sum)
Hadley
> Thanks,
> Punit
>
>
>
> -----Original Message-----
> From: Punit Anand
> Sent: Wednesday, November 21, 2007 11:21 AM
> To: 'r-help@r-project.org'
> Subject: Help Required in using cast (reshape package) function
>
> Hello everyone,
>
> I am new to R. I have data in the form of excel pivot table format and I
> want to cast it into a format which can make it compatible with
> computation.
>
> Since I already have the package in pivot format; I avoid melt function
> and use the cast directly.
> I inspect the
>
> dataread <- read.csv(".....", header=TRUE)
>
> Data in the format
> Id Region Country Industry
> Period variable value
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" "account payable" 10000
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" "account receivable" 50000
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" "XXXX" 70000
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" "YYYY" "NA"
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" "ZZZZ"
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" "AAAA" 10000
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" "ccccccc" 10000
>
> # I want to arrange data in the format
> Id Region Country Industry
> Period "account payable" "account receivable" XXXX" "YYYYY"
> "ZZZZ" "AAAA" "CCCCC"
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" 10000 50000 70000 "NA" 10000
> 10000
>
> # casting the data
> cast <- cast(dataread, ID + Period ~ variable)
>
> When I do that the data is casted as a pivot with a warning "Aggregation
> requires fun.aggregate: length used as default", and the casted data
> gives me the count of variables (as suggested by the warning )
>
> Id Region Country Industry
> Period "account payable" "account receivable" XXXX" "YYYYY"
> "ZZZZ" "AAAA" "CCCCC"
> "Aaa11 xx" "Latin America" "Mexico" "food & beverages"
> "2002:FY" 1 1 1 NA NA 10000
> 10000
>
> How do I use the fun.aggregate feature of the cast function to obtain
> the desired result?
>
> Moreover, I want to subdivide the casted data into subsets based on ids.
> How do I achieve that?
>
>
> Thanks in advance,
>
> Punit Anand
>
> ______________________________________________
> 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.
>
--
http://had.co.nz/
______________________________________________
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.
