Database Reference
In-Depth Information
Finding other words used
Sometimes you might want to find out what other words are used in tweets about coffee.
You can do that with the following search:
index=twitter text=*coffee* | makemv text | mvexpand text | top 30 text
This search first searches for the word "coffee" in a text field, then creates a multivalued
field from the tweet, and then expands it so that each word is treated as a separate piece of
text. Then it takes the top 30 words that it finds.
You might be asking yourself how you would use this kind of information. This type of
analysis would be of interest to a marketer, who might want to use words that appear to be
associated with coffee in composing the script for an advertisement. The following screen-
shot shows the results that appear (1 of 2 pages). From this search, we can see that the
words
love
,
good
, and
cold
might be words worth considering:
Search of top 30 text fields found with *coffee*
When you do a search like this, you will notice that there are a lot of filler words (a, to, for,
and so on) that appear. You can do two things to remedy this. You can increase the limit for
top words so that you can see more of the words that come up, or you can rerun the search
using the following code. "Coffee" (with a capital C) is listed (on the unshown second
page) separately here from "coffee". The reason for this is that while the search is not case
