Thanks, I will read the posting guide. 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 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@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.
