First to do: Load SQL script into database to establish the connection first Setting it up in workbench Twitter SQL script is in the DB folder
Downloading necessary libraries, pandas and pyMySQL
- used pyMySQL - ran into issues with mySQLconector
Main 2 files we are working with twitterAPI and main.py TweetAPI is the middle file that communicates with DB backend and the main.py (client-side)
Couldnt upload tweets.csv
Run main.py file
Input password once you run main file Afterwords its going to run print statements sequentially Choose mannuly whcih ones to run or not Df - choose true or false