Hi:
Suppose I create the dataframe df using the following code:
df <- data.frame( item1 = c('milk',
'bread','beer','beer','milk','beer'), item2 =c('bread',
'butter','diaper','diaper','bread', 'diaper'), stringsAsFactors = F);
df
item1 item2
1 milk bread
2 bread butter
3 beer diaper
4 beer diaper
5 milk bread
6 beer diaper
And now i want the following output:
milk,bread 2
bread,butter 1
beer,diaper 3
milk,bread 2
and "milk,bread" is a single datum. I hope this clarifies the problem!
Thanks!
On 3/18/12, John Kane <jrkrid...@inbox.com> wrote:
> ? table
>
> First however confirm "that milk,bread" is a single datum. str() should do
> this
>
> Can you post a sample of the data here using dput()?
>
> John Kane
> Kingston ON Canada
>
>
>> -----Original Message-----
>> From: mailme...@googlemail.com
>> Sent: Sun, 18 Mar 2012 13:12:48 +0200
>> To: r-help@r-project.org
>> Subject: [R] word frequency count
>>
>> Hi:
>>
>> I have a dataframe containing comma seperated group of words such as
>>
>> milk,bread
>> bread,butter
>> beer,diaper
>> beer,diaper
>> milk,bread
>> beer,diaper
>>
>> I want to output the frequency of occurrence of comma separated words
>> for each row and collapse duplicate rows, to make the output as shown
>> in the following dataframe:
>>
>> milk,bread 2
>> bread,butter 1
>> beer,diaper 3
>> milk,bread 2
>>
>> Thanks for help!
>>
>> deb
>>
>> ______________________________________________
>> 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.
>
> ____________________________________________________________
> FREE 3D MARINE AQUARIUM SCREENSAVER - Watch dolphins, sharks & orcas on your
> desktop!
> Check it out at http://www.inbox.com/marineaquarium
>
>
>
______________________________________________
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.
