Hello, I am trying to count the number of times a keyword occurs and graph it alongside other keywords.
An example CSV file is:
Store | Item | Item | Item
A Apple Orange
B Grape Orange
C Apple Orange
D Orange
So I want to be able to graph that Apple occurred 2x, Grape 1x, and Orange 4x.
I know I can set those columns to the number and have the first column be "Apple" and put a 1 in the row they occur. However, then I cannot use it as a keyword for search or other purposes.
Thanks!