How to count words in a data frame based on a list of dictionary terms in R?

50 pts.
Tags:
Oracle
Oracle Hyperion
I'm trying to perform a dictionary count of terms in a factor of strings. I have a factor called Names. An example below:
[1] GP - Hyperion Planning Upgrade
[2] Application Support Renewal
[3] Oracle EBS upgrade 11.5 to 12.1
[4] Bluemix Services
[5] Cognos 11 Upgrade
I also have a list of dictionary terms called terms:
[1] "IBM"     "Oracle"     "SQL Server"     "Cognos"     "Azure"
What I need from R is to create a dataframe from the list of terms and a total count of each team from the Names factor. Example:
         term       count
1        IBM         3
2        Oracle      6
3        SQL Server  0
4        Cognos      2
5        Azure       9
Of note: the term can be in multiple times in a single name. it counts as once. I would like to ask if anyone has any examples on this that I could derive from Hyperion Planning. Thanks.

Software/Hardware used:
Software

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    What does your current code look like and what problems are you having?
    115,650 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: