Skip to content

Report2_20181101~21

Jump to bottom
Charles Hsiao edited this page Nov 21, 2018 · 26 revisions

Report 2 - 2018/11/01~21

Summary

  • Parsing the flights data

    • Departure airport
    • Arrival airport
    • Airline ICAO
    • Aircraft Model

  • Parsing the aircraft information from: https://www.skybrary.aero/index.php/${model}

  • Export data to csv format

  • Total: 1339 Airlines, 4211 Airports, 9865 Flights

  • Code changes: 9 commits 160 ++ 62 --

Main commits

Complete get_airline_flights function: 7d9a344 

[{'airline': 'CPA', 'from': 'JFK', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'SFO', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'LAX', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'ORD', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'YVR', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LHR'}, {'airline': 'CPA', 'from': 'BNE', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ADL'}, {'airline': 'CPA', 'from': 'ANC', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'ANC', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'AKL', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LHR'}, {'airline': 'CPA', 'from': 'ORD', 'to': 'CDG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'YVR'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'MEL'}, {'airline': 'CPA', 'from': 'KIX', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SFO'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ORD'}, {'airline': 'CPA', 'from': 'MEL', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'LAX', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'YYZ', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'BNE'}, {'airline': 'CPA', 'from': 'IAD', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LAX'}, {'airline': 'CPA', 'from': 'JFK', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'NRT', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'BOS', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'EWR', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SUB'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SIN'}, {'airline': 'CPA', 'from': 'ICN', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'YVR', 'to': 'JFK'}, {'airline': 'CPA', 'from': 'NRT', 'to': 'TPE'}, {'airline': 'CPA', 'from': 'CTS', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'SFO', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'BKK'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ANC'}, {'airline': 'CPA', 'from': 'KIX', 'to': 'TPE'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LHR'}, {'airline': 'CPA', 'from': 'NGO', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HND', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'NRT'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'PER'}, {'airline': 'CPA', 'from': 'NRT', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SIN'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'BOM'}, {'airline': 'CPA', 'from': 'LAX', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'LAX', 'to': 'ANC'}, {'airline': 'CPA', 'from': 'CGK', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'NGO', 'to': 'TPE'}, {'airline': 'CPA', 'from': 'WTB', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'ANC', 'to': 'LAX'}, {'airline': 'CPA', 'from': 'TPE', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SIN'}, {'airline': 'CPA', 'from': 'DPS', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'CEB'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'YVR'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'CGK'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'HND'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'BKK'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'JFK'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ICN'}, {'airline': 'CPA', 'from': 'ANC', 'to': 'LCK'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'NGO'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'KHH'}, {'airline': 'CPA', 'from': 'PEK', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'BKK', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LAX'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'BOM'}, {'airline': 'CPA', 'from': 'SIN', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'TPE', 'to': 'ICN'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'MNL'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'KIX'}, {'airline': 'CPA', 'from': 'KIX', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'PEK'}, {'airline': 'CPA', 'from': 'YVR', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': ''}, {'airline': 'CPA', 'from': 'HKG', 'to': 'DEL'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SGN'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'DXB'}, {'airline': 'CPA', 'from': 'PVG', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'KIX', 'to': 'ICN'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'MNL'}, {'airline': 'CPA', 'from': 'TPE', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': ''}, {'airline': 'CPA', 'from': 'LHR', 'to': ''}, {'airline': 'CPA', 'from': 'HKG', 'to': 'PVG'}, {'airline': 'CPA', 'from': 'BKK', 'to': 'HKG'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'IAD'}]
Analysis
  • Aggregate flights information
  • Example data: {'airline': 'CPA', 'from': 'JFK', 'to': 'HKG'}
    • ['airline'] CPA: Airline ICAO
    • ['from'] JFK: Departure airport
    • ['to'] HKG: Arrival airport

Add get all airports function: 089cb08 

4211
Analysis
  • Totally 4211 airports

Output airports lists: 8c1e592 

[{'name': '\tPraslin Island Airport', 'iata': 'PRI', 'icao': 'FSPP', 'lat': -4.31929, 'lon': 55.69141, 'country': 'Seychelles', 'alt': 10}, {'name': '\r\nLong Seridan Airport', 'iata': 'ODN', 'icao': 'WBGI', 'lat': 3.976111, 'lon': 115.063301, 'country': 'Indonesia', 'alt': 607}, {'name': 'A Coruna Airport', 'iata': 'LCG', 'icao': 'LECO', 'lat': 43.302059, 'lon': -8.37725, 'country': 'Spain', 'alt': 326}, {'name': 'Aachen Merzbruck Airport', 'iata': 'AAH', 'icao': 'EDKA', 'lat': 50.823051, 'lon': 6.186111, 'country': 'Germany', 'alt': 623}, {'name': 'Aalborg Airport', 'iata': 'AAL', 'icao': 'EKYT', 'lat': 57.092781, 'lon': 9.849164, 'country': 'Denmark', 'alt': 10}, {'name': 'Aarhus Airport', 'iata': 'AAR', 'icao': 'EKAH', 'lat': 56.300011, 'lon': 10.619, 'country': 'Denmark', 'alt': 82}, {'name': 'Aarhus Sea Airport', 'iata': 'QEA', 'icao': 'EKAC', 'lat': 56.151993, 'lon': 10.247725, 'country': 'Denmark', 'alt': 1}, {'name': 'Aasiaat Airport', 'iata': 'JEG', 'icao': 'BGAA', 'lat': 68.72184, 'lon': -52.784698, 'country': 'Greenland', 'alt': 74}, {'name': 'Abadan Airport', 'iata': 'ABD', 'icao': 'OIAA', 'lat': 30.371111, 'lon': 48.228329, 'country': 'Iran', 'alt': 19}, {'name': 'Abakan International Airport', 'iata': 'ABA', 'icao': 'UNAA', 'lat': 53.740002, 'lon': 91.385002, 'country': 'Russia', 'alt': 831}, {'name': 'Abbotsford International Airport', 'iata': 'YXX', 'icao': 'CYXX', 'lat': 49.025269, 'lon': -122.360001, 'country': 'Canada', 'alt': 195}, {'name': 'Aberdeen International Airport', 'iata': 'ABZ', 'icao': 'EGPD', 'lat': 57.201939, 'lon': -2.19777, 'country': 'United Kingdom', 'alt': 215}, {'name': 'Aberdeen Regional Airport', 'iata': 'ABR', 'icao': 'KABR', 'lat': 45.439999, 'lon': -98.419998, 'country': 'United States', 'alt': 1302}, {'name': 'Abha Regional Airport', 'iata': 'AHB', 'icao': 'OEAB', 'lat': 18.24036, 'lon': 42.65662, 'country': 'Saudi Arabia', 'alt': 6858}, {'name': 'Abidjan Port Bouet Airport', 'iata': 'ABJ', 'icao': 'DIAP', 'lat': 5.261386, 'lon': -3.92629, 'country': "Cote D'ivoire (Ivory Coast)", 'alt': 21}, {'name': 'Abilene Regional Airport', 'iata': 'ABI', 'icao': 'KABI', 'lat': 32.411301, 'lon': -99.681801, 'country': 'United States', 'alt': 1790}, {'name': 'Abingdon Virginia Highlands Airport', 'iata': 'VJI', 'icao': 'KVJI', 'lat': 36.686111, 'lon': -82.033333, 'country': 'United States', 'alt': 2088}, {'name': 'Abu Dhabi Al Bateen Executive Airport', 'iata': 'AZI', 'icao': 'OMAD', 'lat': 24.428329, 'lon': 54.45808, 'country': 'United Arab Emirates', 'alt': 16}, {'name': 'Abu Dhabi International Airport', 'iata': 'AUH', 'icao': 'OMAA', 'lat': 24.43297, 'lon': 54.651131, 'country': 'United Arab Emirates', 'alt': 88}, {'name': 'Abu Musa Island Airport', 'iata': 'AEU', 'icao': 'OIBA', 'lat': 25.8757, 'lon': 55.033001, 'country': 'Iran', 'alt': 23}, {'name': 'Abu Simbel Airport', 'iata': 'ABS', 'icao': 'HEBL', 'lat': 22.37595, 'lon': 31.611719, 'country': 'Egypt', 'alt': 616}, {'name': 'Abuja Nnamdi Azikiwe International Airport', 'iata': 'ABV', 'icao': 'DNAA', 'lat': 9.006792, 'lon': 7.263172, 'country': 'Nigeria', 'alt': 1123}, {'name': 'Acapulco International Airport', 'iata': 'ACA', 'icao': 'MMAA', 'lat': 16.757059, 'lon': -99.753899, 'country': 'Mexico', 'alt': 16}]
Analysis
  • Example data: {'name': 'Taiwan Taoyuan International Airport', 'iata': 'TPE', 'icao': 'RCTP', 'lat': 25.07773, 'lon': 121.232803, 'country': 'Taiwan', 'alt': 106}
    • ['name'] Taiwan Taoyuan International Airport: Airport name
    • ['iata'] TPE: Airport code in IATA
    • ['icao'] RCTP: Airport code in ICAO
    • ['lat'] 25.07773: Latitude of the airport
    • ['lon'] 121.232803: Longitude of the airport
    • ['country']: Taiwan: The country name which airport located

Add flight aircraft information: f6e98f2 

[{'airline': 'CPA', 'from': 'HKG', 'to': 'JFK', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LHR', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'AKL', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'YYZ', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LAX', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SFO', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'ANC', 'to': 'HKG', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ORD', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'MEL', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'SYD', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'BNE', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'IAD', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'JFK', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'EWR', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'YYZ', 'to': 'ANC', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'CGK', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ANC', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'YYZ', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'BOS', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'ANC', 'to': 'MEX', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'BOM', 'aircraft': 'B744'}, {'airline': 'CPA', 'from': 'SFO', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ANC', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LHR', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'LAX', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'SFO', 'to': 'HKG', 'aircraft': 'A35K'}, {'airline': 'CPA', 'from': 'LAX', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'DPS', 'to': 'HKG', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'DEL', 'aircraft': 'B744'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'BOS', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'MLE', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'YVR', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'JFK', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'NRT', 'to': 'HKG', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'KIX', 'to': 'HKG', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'LAX', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'YVR', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'DXB', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'KIX', 'to': 'HKG', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'LHR', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'KIX', 'to': 'HKG', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'SIN', 'to': 'HKG', 'aircraft': 'A35K'}, {'airline': 'CPA', 'from': 'TPE', 'to': 'HKG', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'YYZ', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'JNB', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'EWR', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'TPE', 'to': 'HKG', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'TPE', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'MNL', 'to': 'HKG', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'BKK', 'to': 'HKG', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'ZRH', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SFO', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'DUB', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'BAH', 'to': 'DXB', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'CGK', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'SYD', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ANC', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'ICN', 'to': 'HKG', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'BKK', 'to': 'HKG', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'LGW', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'TPE', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'TPE', 'to': 'HKG', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'MAN', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'MXP', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'ATL', 'to': 'ANC', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SYD', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'MAA', 'aircraft': 'B744'}, {'airline': 'CPA', 'from': 'FCO', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'FRA', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'CDG', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'TPE', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'TPE', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'HKG', 'to': '', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'TPE', 'to': 'HKG', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'AMS', 'to': 'HKG', 'aircraft': 'B77W'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'SIN', 'aircraft': 'B773'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'ANC', 'aircraft': 'B748'}, {'airline': 'CPA', 'from': 'MNL', 'to': 'HKG', 'aircraft': 'A359'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'DEL', 'aircraft': 'A333'}, {'airline': 'CPA', 'from': 'HKG', 'to': 'DEL', 'aircraft': 'B748'}]
Analysis
  • Example data: {'airline': 'CPA', 'from': 'HKG', 'to': 'JFK', 'aircraft': 'B77W'}
    • ['airline'] CPA: Airline ICAO
    • ['from'] JFK: Departure airport
    • ['to'] HKG: Arrival airport
    • ['aircraft'] B77W: Aircraft model=Boeing 777-300ER

Print the flights information of all airlines: 63b30f1 

[]
[{'airline': 'JYH', 'from': 'NKG', 'to': 'HAK', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'HFE', 'to': 'LHW', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'SHE', 'to': 'CGO', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'CGQ', 'to': 'NKG', 'aircraft': 'B38M'}, {'airline': 'JYH', 'from': 'AVA', 'to': 'XIY', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'DLC', 'to': 'WUX', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'NKG', 'to': 'KWE', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'HRB', 'to': 'WNZ', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'TYN', 'to': 'KHN', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'URC', 'to': 'CAN', 'aircraft': 'B738'}, {'airline': 'JYH', 'from': 'MDL', 'to': 'CAN', 'aircraft': 'B738'}]
[{'airline': 'ABX', 'from': 'CVG', 'to': 'HRL', 'aircraft': 'B762'}, {'airline': 'ABX', 'from': 'CVG', 'to': 'MCO', 'aircraft': 'B763'}, {'airline': 'ABX', 'from': 'CVG', 'to': 'SJU', 'aircraft': 'B763'}, {'airline': 'ABX', 'from': 'SJO', 'to': 'MIA', 'aircraft': 'B763'}, {'airline': 'ABX', 'from': 'BDL', 'to': 'CVG', 'aircraft': 'B762'}, {'airline': 'ABX', 'from': 'TPA', 'to': '', 'aircraft': 'B762'}, {'airline': 'ABX', 'from': 'CAI', 'to': '', 'aircraft': 'B762'}]
[{'airline': 'ADR', 'from': 'MUC', 'to': 'BIO', 'aircraft': 'A319'}, {'airline': 'ADR', 'from': 'OTP', 'to': 'MUC', 'aircraft': 'A319'}, {'airline': 'ADR', 'from': 'GOT', 'to': 'MUC', 'aircraft': 'A319'}, {'airline': 'ADR', 'from': 'LJU', 'to': 'SKP', 'aircraft': 'CRJ9'}, {'airline': 'ADR', 'from': 'LJU', 'to': 'TIA', 'aircraft': 'CRJ9'}, {'airline': 'ADR', 'from': 'VIE', 'to': 'KIV', 'aircraft': 'CRJ9'}, {'airline': 'ADR', 'from': 'PRN', 'to': 'MUC', 'aircraft': 'CRJ9'}, {'airline': 'ADR', 'from': 'PRN', 'to': 'VIE', 'aircraft': 'CRJ9'}, {'airline': 'ADR', 'from': 'LJU', 'to': 'SAW', 'aircraft': 'CRJ7'}, {'airline': 'ADR', 'from': 'LJU', 'to': 'ZRH', 'aircraft': 'CRJ9'}]
[]
[]
[{'airline': 'AEE', 'from': 'FRA', 'to': 'SKG', 'aircraft': 'A321'}, {'airline': 'AEE', 'from': 'ZRH', 'to': 'ATH', 'aircraft': 'A321'}, {'airline': 'AEE', 'from': 'MUC', 'to': 'ATH', 'aircraft': 'A321'}, {'airline': 'AEE', 'from': 'VIE', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'DME', 'to': 'SKG', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'WAW', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'MXP', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'GVA', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'BCN', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'VIE', 'to': 'HER', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'CDG', 'to': 'ATH', 'aircraft': 'A321'}, {'airline': 'AEE', 'from': 'BRU', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'HAM', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'MUC', 'to': 'SPU', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'MAD', 'aircraft': 'A321'}, {'airline': 'AEE', 'from': 'BLQ', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'DME', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'LHR', 'aircraft': 'A321'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'LCA', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'RHO', 'aircraft': 'A319'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'AMS', 'aircraft': 'A321'}, {'airline': 'AEE', 'from': 'LHR', 'to': 'ATH', 'aircraft': 'A321'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'VCE', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'HAJ', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'DUS', 'to': 'SKG', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'DUS', 'to': 'ATH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'CDG', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'CPH', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'PRG', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'BUD', 'to': '', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'ATH', 'to': 'TXL', 'aircraft': 'A320'}, {'airline': 'AEE', 'from': 'SKG', 'to': 'MJT', 'aircraft': 'A320'}]

Add get_aircraft function for aircraft info retrieving: cde379d 

{'name': '777-300ER', 'manufacturer': 'BOEING', 'capacity': 'Heavy', 'apc': 'D'}
Analysis
  • Example data: {'name': '777-300ER', 'manufacturer': 'BOEING', 'capacity': 'Heavy', 'apc': 'D'}
    • ['name'] 777-300ER: Aircraft model name
    • ['manufacturer'] BOEING: Aircraft model manufacturer
    • ['capacity'] Heavy: ICAO Wake Turbulence Category
    • ['apc'] D: Aircraft_Approach_Category(APC)
  • ICAO Wake Turbulence Category: https://www.skybrary.aero/index.php/ICAO_Wake_Turbulence_Category
    • H (Heavy) aircraft types of 136 000 kg (300 000 lb) or more;
    • M (Medium) aircraft types less than 136 000 kg (300 000 lb) and more than 7 000 kg (15 500 lb); and
    • L (Light) aircraft types of 7 000 kg (15 500 lb) or less.
    • Super Heavy for Airbus A380-800 with a maximum take-off mass in the order of 560 000 kg. (see Airbus A380 Wake Vortex Guidance)
  • APC: https://www.skybrary.aero/index.php/Aircraft_Approach_Category_(APC)
    • A: Speed 90 knots or less.
    • B: Between 91 and 120 knots.
    • C: Between 121 and 140 knots.
    • D: Between 141 knots and 165 knots.
    • E: Speed 166 knots or more. Only assigned to certain Military Aircraft.

Complete flights info output to csv: f6a3dde 

JYH,NKG,HAK,B738,Medium
JYH,CGQ,NKG,B38M,Medium
JYH,NKG,KWE,B738,Medium
JYH,HFE,LHW,B738,Medium
JYH,DLC,WUX,B738,Medium
JYH,RGN,CAN,B738,Medium
JYH,HRB,WNZ,B738,Medium
JYH,SHE,CGO,B738,Medium
ABX,CVG,SEA,B762,Heavy
ABX,SJO,MIA,B763,Heavy
ABX,BDL,CVG,B762,Heavy
ADR,MUC,BIO,A319,Medium
ADR,OTP,MUC,A319,Medium
ADR,LJU,TRD,CRJ9,Medium
ADR,GOT,MUC,A319,Medium
ADR,LJU,SKP,CRJ7,Medium
ADR,VIE,KIV,CRJ9,Medium
ADR,TIA,FRA,CRJ9,Medium
ADR,PRN,VIE,CRJ9,Medium
ADR,LJU,ZRH,CRJ7,Medium
AEE,ATH,BOD,A320,Medium
AEE,ZRH,ATH,A321,Medium
AEE,MXP,ATH,A320,Medium
AEE,PRG,ATH,A320,Medium
AEE,BRU,ATH,A320,Medium
AEE,TXL,ATH,A320,Medium
AEE,BCN,ATH,A320,Medium
AEE,CPH,ATH,A320,Medium
AEE,STR,ATH,A320,Medium
AEE,CDG,ATH,A321,Medium
AEE,NCE,ATH,A320,Medium
AEE,LGW,ATH,A320,Medium
AEE,ATH,LCA,A321,Medium
AEE,ATH,TLS,A320,Medium
AEE,ATH,LYS,A320,Medium
AEE,AMS,ATH,A321,Medium
AEE,ATH,CDG,A320,Medium
AEE,ATH,RHO,A320,Medium
AEE,ATH,LHR,A321,Medium
AEE,SXF,SPU,A320,Medium
AEE,DUS,SKG,A320,Medium
AEE,ATH,HAM,A321,Medium
AEE,ATH,MRS,A320,Medium
AEE,DUS,ATH,A320,Medium
AEE,MAD,ATH,A321,Medium
AEE,EDI,ATH,A320,Medium
AEE,SKG,RHO,A320,Medium
EIN,LAX,DUB,A332,Heavy
Analysis
  • Total 9865 flights: output.csv
  • Example data: EIN,LAX,DUB,A332,Heavy
    • [0] EIN: Airline ICAO code
    • [1] LAX: Departure airport
    • [2] DUB: Arrival airport
    • [3] A332: Aircraft model
    • [4] Heavy: ICAO Wake Turbulence Category

Other commits

  • Print airline flights & Modify function name from get_airline to get_airline_flights: 2e9f3cf
  • Update get_all_airlines function: d54e783

What's Next

  • Import csv into Gephi for analysis

Getting Started

Project Progress

Clone this wiki locally