Hi r-help-boun...@r-project.org napsal dne 26.03.2010 10:41:29:
> Hi, > > I have a column in a data frame looking something like: > > $sex $language $count > male english 0 > male english 0 > female english 32 > male spanish 154 > female english 11 > female norweigan 7 > > and so on. > What I want to do is to order these in to categories, for instance one > category where count>=0 & count<10 and so on.. Break your counts into desired levels, see ?cut cut(1:100, breaks=10) > > I want my data to turn out looking something like: > > male english 0-10 1324 > male english 11-20 756 > ..... > male spanish 0-10 354 > ... > female english 0-10 1557 > ... aggregate your data with(your.data, aggregate(count, list(sex, language, cutted.count), length)) Regards Petr > > and so on, where the right hand is the count of the number of people in each > category. > Up until now I've been subsetting the data frame into each category, and > then counting number of rows in each subset. However I now have a large > amount of different factor combinations which makes this process tedious. > > Any help would be appreciated! > Chris > > [[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. ______________________________________________ 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.