Message-ID: <CAAxdm-5pNg40fk67BWFssDG4GBrBBdKLcZpk3Sfqtkx33hqYbg@mail.gmail.com>
Date: 2011-12-04T00:02:19Z
From: jim holtman
Subject: pivot table help
In-Reply-To: <CAGx1TMBVv=mMVjoXZsgJ=XKhwEOKgfUBb8a2wcNC3eta5rq0=A@mail.gmail.com>
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.