quocduyenanhnguyen/Airlines_Web_Scrapping

I scrapped airline data from a Wiki page with Python, did some data cleaning with Google Sheet and SQL, then visualized the data with Tableau.

Software I used:

MySQL Workbench: to write SQL

PyCharm CE: to run Python script to scrap airlines data

Data source

Description:

• 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