Sentiment analysis of ISU Twitter followers
Rewrite in progress
- Set up stream with criteria for ISU
- @IllinoisStateU
- #ISU
- #ilstu
- #illinoisstate
- Listen for tweets
- When tweet collected, extract the fields we want (and fake up some fields)
- Transform data types when necessary
- Load to the staging tables for sentiment scoring
- Et finito/ad infinitum
- Set up the db in a different script which will get called when the listener starts. The script will check to see that all of the tables/indices are created and create them if not.
- Write a new parser/db program which will take in a raw tweet, extract the user/text/etc, mock up an age/gender, and then write that to the staging tables
- Also, need to add markers (per/see Mike)