MySQL Workbench: to write SQL
PyCharm CE: to run Python script to scrap airlines data
- I scrapped airline data from a Wiki page, did some data cleaning in Google Sheet, imported the dataset to the database, did some more data cleaning, then created two views in the database and then connected Tableau to the data source to visualize.
- Attached to this repos is my Python script to scrap data, two airline CSV files after cleaning the data in Google Sheet, SQL queries and output of data cleaning.
- Link to Tableau viz: https://public.tableau.com/app/profile/anna.quoc.nguyen/viz/Top10airlinessortbynumberofscheduledpassengerkilometersflownandfreighttonnekilometersflown/Dashboard1