Hi there! I have recently been touching on the subject of word processing.
I would like you to guide me with something that I really don’t know how to approach anymore.
I have a lot of data, among which I have a description column, where I am applying word processing.
I have the key words of this information, but I would like to pivot those words, have all my information and sum the words “If you find this word in this description, sum as many times as you find it in this description”.
For example, I have the column for event number and description. I want to add as a pivot the keywords “Fell, dangerous”. If in description appears 2 times fall. that appears :
Event number Description Fell Dangerous
0002 “He fell down the stairs. Earlier, he fell from a very dangerous place” 2 1
I would be very grateful