Is this what you want:
> x
id agency offer month product
1 1 a L gen star
2 2 b M feb meteor
3 3 c N gen moon
4 4 d O march moon> require(reshape2)
> dcast(x, agency + offer ~ product, fun = length)
Using product as value column: use value.var to override.
agency offer meteor moon star
1 a L 0 0 1
2 b M 1 0 0
3 c N 0 1 0
4 d O 0 1 0>
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
On Fri, Feb 28, 2014 at 6:56 AM, lara.palandra
<lara.palandra@libero.it>wrote:
> hi..i would create a pivot table in R and i would create two levels of
> columns. I'll try to explain better. I have a table so done:
>
> id agency offer month product
>
> 1 a L gen star
> 2 b M feb meteor
> 3 c N gen moon
> 4 d O march moon
> .. .. ... .... ....
>
> i'd like to aggregate this table in this way:
> <http://r.789695.n4.nabble.com/file/n4685993/pivot.png>
>
> in the table there is id count.
>
> help me!!
> Lara
>
>
>
> --
> View this message in context:
> http://r.789695.n4.nabble.com/pivot-table-tp4685993.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.
>
[[alternative HTML version deleted]]