- Use Python to develop a Twitter data crawler through Twitter's APIs to collect tweets data.
- Ddesign the SQL server, database schema, tables and entity-relationship model.
- Perform sentiment analysis on tweet data.
Use "!pip install --" command to install the following libraries:
!pip install pandas
!pip install sqlalchemy
!pip install transformers
!pip install pymysql
!pip install TensorFlow
!pip install snscrape
!pip install matplotlib
!pip install emoji
!pip install wordcloud
!pip install geopandas
!pip install spacy
!pip install pysentimiento
!pip install radar
!pip install ipywidgets
!pip install pandas-profiling
The scraped twitter data will be loaded and stored in a MySQL database table:
- Username
- Date
- TweetURL
- User
- Source
- Location
- Tweet
- Likes_Count
- Retweet_Count
- Quote_Count
- Reply_Count