Aggregated Airfare Information: City Pair Information - Githubissues

jragh / US-Flights-Analysis

Python Dash Project using Polars, Dash Bootstrap and Plotly Dash to analyze US Aviation Flights

0 stars 0 forks source link

Aggregated Airfare Information: City Pair Information #17

Open jragh opened 1 month ago

jragh commented 1 month ago

Bring in airfare information for city pairs within the USA. Link to the report location is here.

Will need to look at Table 6 in the aforementioned link. Foreseen tasks below:

[x] Download and ingest data from link above
[ ] Create SQL Table and backend for Airfare pairs (Potential Summary table)
[ ] Create join back to the main table to determine if market matches to origin & destination columns
[ ] Incorporate this with the routes Page that will be introduced in the future
[ ] User selects both airports, and it will show carriers, passengers, potential revenue, estimated revenue, utilization on route

jragh commented 1 week ago

Switched to larger task due to number of items to be completed. Might need to split up this task into smaller ones. For now will stay the way it is.