Google Spreadsheet Post #2070
I have a column with whole sentences in each cell. What I need is to count the frequency of each word in the column, and to display the results in a new column (in descending order of frequency). An example is: (row 1) The apple fell from the tree. (row 2) The dog chased after the cat. (row 3) The cat ran up the tree. The formula would show (in a new column): The - 6 Cat - 2 Tree -2 Chased - 1 ... Etc. Preferably there would be a way to include a list of stopwords (so that 'the, or, if', etc, were not included in the count). I would provide the stopwords, perhaps in a separate column within the spreadsheet. I am stumped - I have looked up and down the net for a solution, without luck.
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jun-07-2016
question by: Manny Sousera:
https://app.vcita.com/app/conversations/8fdiszatknkool66?flow=Email_ActionI have a column with whole sentences in each cell. What I need is to count the frequency of each word in the column, and to display the results in a new column (in descending order of frequency). An example is: (row 1) The apple fell from the tree. (row 2) The dog chased after the cat. (row 3) The cat ran up the tree. The formula would show (in a new column): The - 6 Cat - 2 Tree -2 Chased - 1 ... Etc. Preferably there would be a way to include a list of stopwords (so that 'the, or, if', etc, were not included in the count). I would provide the stopwords, perhaps in a separate column within the spreadsheet. I am stumped - I have looked up and down the net for a solution, without luck.
No comments:
Post a Comment