For my Twitter analysis I wanted to actually look into the tweets, all well and good looking at when the tweets were posted and who posted them but what were they actually talking about?
Luckily I came across the following post which has a SQL query that allows you to extract the words from a column. I modified this, see the SQL code at the end, so that it looked at my table and also to exclude some common words. Why? Well I don't care if people are posting the words, and, the, & etc.
I won't re-post the code from my twitter to blogger post but I will follow the same steps to get the post that can be found here:
The code:
No comments:
Post a Comment