[R] pivot table help

jim holtman jholtman at gmail.com
Sun Dec 4 01:05:18 CET 2011


Forgot, you can also do this:

> dcast(x.m, Cluster ~ value, fun = length)
  Cluster ind1 ind2 ind3
1       1    1    1    0
2       2    1    0    1
3       3    1    1    0
>


On Sat, Dec 3, 2011 at 7:02 PM, jim holtman <jholtman at gmail.com> wrote:
> try this:
>
>> x <- read.table(text = "Cluster   Member1    Member2
> + 1            ind1           ind2
> + 2            ind3           ind1
> + 3            ind2           ind1", as.is = TRUE, header = TRUE)
>> require(reshape2)
>> x.m <- melt(x, id = "Cluster")
>> x.m
>  Cluster variable value
> 1       1  Member1  ind1
> 2       2  Member1  ind3
> 3       3  Member1  ind2
> 4       1  Member2  ind2
> 5       2  Member2  ind1
> 6       3  Member2  ind1
>> table(x.m$Cluster, x.m$value)
>
>    ind1 ind2 ind3
>  1    1    1    0
>  2    1    0    1
>  3    1    1    0
>>
>
>
> On Sat, Dec 3, 2011 at 5:53 PM, Richard M. Heiberger <rmh at temple.edu> wrote:
>> Pivot tables are an Excel concept, not an R concept.
>>
>> That means you must give an example of your starting pivot table as an R
>> object (use dump() so we can pick it up from the email and execute it
>> immediately).
>> and an example of the R object you want as the result.
>> Use a trivial but complete example.
>>
>> An example of dump
>>
>> tmp <- matrix(1:6,2,3)
>> tmp
>> dump("tmp","")
>> Be sure to read the posting guide before sending your revised request.
>>
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html>
>> and provide commented, minimal, self-contained, reproducible code.
>>
>> Rich
>> On Sat, Dec 3, 2011 at 5:27 PM, set <astareh at hotmail.com> wrote:
>>
>>> Hello R-users,
>>>
>>> I've got a huge table with about 20.00 rows and 50 columns. The table now
>>> has headers as Members1, Members2 etc. My data are 8 different individuals.
>>> And I've got a column with clusters. So each individual belongs to
>>> different
>>> clusters and can occurs multiple times within a cluster (that's the reason
>>> that there can be more than 8 members). I want a presence/ absence table
>>> for
>>> each individual within each cluster.
>>> So I want to go from:
>>> Cluster   Member1    Member2  etc.
>>> 1            ind1           ind2
>>> 2            ind3           ind1
>>> 3            ind2           ind1
>>>
>>> to
>>>
>>> cluster    ind1          ind2      ind3
>>> 1            1               1          0
>>> 2            1                0         1
>>> 3            1               1          0
>>>
>>> Has anybody any idea how I can do this? I already tried alot of things with
>>> pivottables (using cast()) But I think I'm missing out on something.
>>> thank you
>>>
>>> --
>>> View this message in context:
>>> http://r.789695.n4.nabble.com/pivot-table-help-tp4155144p4155144.html
>>> Sent from the R help mailing list archive at Nabble.com.
>>>
>>> ______________________________________________
>>> 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<http://www.r-project.org/posting-guide.html>
>>> and provide commented, minimal, self-contained, reproducible code.
>>>
>>
>>        [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> 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.
>
>
>
> --
> 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.



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



More information about the R-help mailing list