Grouping according to categories

Question

I am trying to categorize the companies according to the keywords I have listed. I have two data sheets:

(1) The first one has the companies. Each company has an "award title" and "research keywords".

(2) The second one has a list of keywords (categories).

I want to group companies under these categories based on the words in the "award title" and "multiple research keyword columns".

In the file I attached:

So at the end of the tail far right hand side I have the top one which shows the data set for companies. The words (in columns award title, research keywords 1,2,3 etc)

The bottom one which shows the category words.

Thank you very much for any help!

Analysis CA VA TX MA.yxmd

mokcay · Answer

Hi Luke also I am looking into machine learning or text mining. May be I can use that to recognize words and then classify. How would I do that to solve this problem?

mokcay · Answer

Thank you very much Luke! Plese find enclosed the exported version.

Exported Workflow.yxzp

Luke_C · Answer

Hi @mokcay

Your input files aren't included. You'll need to export the workflow via Options>Export Workflow to save it as a yxzp so we can run the data. I'd suggest creating some sample data if your data is sensitive.