Count of individual words in a dataset

[dovitt]

I have a dataset that has employee ids with line items that list experiences at prior employers. I’m looking to separate all of the words and summarize the count by word and by employee id. Any tips would be nice! 

[Qiu]

@dovitt 
Can you kindly provide a sample input and desired output?

[Emmanuel_G · Accepted solution]

Hi @dovitt ,

I just did a test that you will find attached which gives you a word count for each job.

Let me know if that's what you were thinking or if it helps

Otherwise provide an input dataset and a desired file output.

Cheers ! 

[dovitt]

Awesome! Thank you, just had to use some regex I hadn't used before.

(\b[^\s]+\b)

Thanks!