In this project I want to create a user friendly dashboard is used for popular tweets for given keywords.
Details:
- get_data.py will search tweets for given keywords, do sentiment analysis and write into PostgreSQL database.
- Before executing get_data.py, You have to fill credentials.py for Twitter API, PostgreSQL database and keywords for twitter search.
- Tweepy is used for searching tweets and TextBlob is used for sentiment analysis.
- Tableau public doesnt support to connect PostgreSQL server. So I imported data from PostgreSQL database and convert it to excel file to upload Tabluea. tweets.xlsx is a sample of uploaded data.
You can experience dashboard at here