[R] Newbie question: Converting Table

[David Winsemius]

On Sep 23, 2011, at 8:43 AM, Metronome123 wrote:

> Thanks, I will read the posting guide.

Please do it NOW. Before any further postings.

>
> Q1: thanks for helping me out!
>
> Q2: What I mean is that given the dataset:
>
> subject1,class1_yes, class2_no, class3_yes, class4_no
> subject2, class1_no, class2_no, class3_no, class4_yes
> subject3, class1_yes, class2_no, class3_yes, class4_no
>
> I want to count for each unique class combination the number of  
> subjects that share this whole combination.
>
> In this case the result should be:
>
> 2 counts for the combination class1_yes, class2_no, class3_yes,  
> class4_no
> 1 count for the combination class1_no, class2_no, class3_yes,   
> class4_yes
>
Perhaps:

with( datfrm, table( interaction( <names of columns> ) ) )

Had you read the Posting Guide you would have found that you are  
requested to post a working example and you are also given instruction  
how a proper working example can be created from your own data. The  
Posting Guide uses 'dump' but I usually use 'dput'.  Then we would not  
have needed to post guesswork and pseudo-code.

-- 
david.
>
> Regards,
>
>
> Lars
>
>
> Op 23 sep. 2011 (w38), om 14:12 heeft Petr Pikal [via R] het  
> volgende geschreven:
>
>>
>> [R] Newbie question: Converting Table
>>
>> Hi,
>>
>> I'm new to R, and I have searched helpfiles and this forum on my 2
>> questions. Hope you guys can help me out! :-)
>
> You did not search enough. You probably want table or xtabs
>
> Q1
> untested
>
> res <- xtabs(~subject+class, data=your.file)
> ifelse(res==1, "yes", "no")
>
> Q2
>
> I do not understand what exactly do you want. Please be more specific.
>
> BTW, if you are in it you'd rather give a look to posting guide.
>
> Regards
> Petr
>
>>
>> Many thanks in advance!
>>
>> Cheers,
>>
>>
>> Lars
>>
>> Q1: I imported a csv file with columnames subject and class. There  
>> are
> about
>
>> 1000 different classes...
>> It looks like this:
>> subject1, class1
>> subject1, class2
>> subject2, class1
>> subject2, class3
>> ...
>> subject999, class1
>> subject999, class2
>>
>> Now I want to transform this in R into a table (with columnnames
>> subject,class1,class2,...) like:
>> subject1, yes, yes, no, ...
>> subject2, yes, no, yes, ...
>> ...
>>
>> Q2: I want to count the matching class patterns in the previous table
>> (output: in a table with columns count, class1, ...). In this example
> for
>
>> only the subjects1,2 and 999 it looks like this:
>> 2,yes,yes,no,..
>> 1,yes,no,yes
>> ...
>>
>>
>>
>> -- 
>> View this message in context: http://r.789695.n4.nabble.com/Newbie-
>> question-Converting-Table-tp3836468p3836468.html
>> Sent from the R help mailing list archive at Nabble.com.
>>
>> ______________________________________________
>> [hidden email] 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.
>
> ______________________________________________
> [hidden email] 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.
>
>
> If you reply to this email, your message will be added to the  
> discussion below:
> http://r.789695.n4.nabble.com/Newbie-question-Converting-Table-tp3836468p3836611.html
> To unsubscribe from Newbie question: Converting Table, click here.
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Newbie-question-Converting-Table-tp3836468p3836711.html
> Sent from the R help mailing list archive at Nabble.com.
> 	[[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.

David Winsemius, MD
West Hartford, CT