\n", " | City | \n", "
---|---|
0 | \n", "Berlin Germany | \n", "
1 | \n", "Washington DC United States | \n", "
2 | \n", "New York NY United States | \n", "
3 | \n", "Paris France | \n", "
4 | \n", "London United Kingdom | \n", "
\n", " | City | \n", "Coords | \n", "
---|---|---|
0 | \n", "Berlin Germany | \n", "(52.5170365, 13.3888599) | \n", "
1 | \n", "Washington DC United States | \n", "(38.8949549, -77.0366456) | \n", "
2 | \n", "New York NY United States | \n", "(40.7306458, -73.9866136) | \n", "
3 | \n", "Paris France | \n", "(48.8566101, 2.3514992) | \n", "
4 | \n", "London United Kingdom | \n", "(51.5073219, -0.1276474) | \n", "
\n", " | Date | \n", "Airline | \n", "Type | \n", "Time_Dep | \n", "Origin | \n", "Code_Origin | \n", "Flight | \n", "Code_Dest | \n", "Destination | \n", "Time_Arr | \n", "PlusOneDay | \n", "Aircraft | \n", "Booking | \n", "MilesProg | \n", "Paid | \n", "CO2 | \n", "Comment | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | \n", "1/1/00 | \n", "Virgin America | \n", "US | \n", "7:00 | \n", "Washington Dulles | \n", "IAD | \n", "VX1890 | \n", "SFO | \n", "San Francisco | \n", "10:10 | \n", "NaN | \n", "A320 | \n", "QUAHUA | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Return flight | \n", "
15 | \n", "1/1/00 | \n", "Virgin America | \n", "US | \n", "21:20 | \n", "San Francisco | \n", "SFO | \n", "VX456 | \n", "IAD | \n", "Washington Dulles | \n", "5:16 | \n", "1.0 | \n", "A320 | \n", "QUAHUA | \n", "NaN | \n", "NaN | \n", "NaN | \n", "Overnight outbound flight | \n", "
\n", " | id | \n", "ident | \n", "type | \n", "name | \n", "latitude_deg | \n", "longitude_deg | \n", "elevation_ft | \n", "continent | \n", "iso_country | \n", "iso_region | \n", "municipality | \n", "scheduled_service | \n", "gps_code | \n", "iata_code | \n", "local_code | \n", "home_link | \n", "wikipedia_link | \n", "keywords | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28336 | \n", "3771 | \n", "KPHL | \n", "large_airport | \n", "Philadelphia International Airport | \n", "39.871899 | \n", "-75.241096 | \n", "36.0 | \n", "NaN | \n", "US | \n", "US-PA | \n", "Philadelphia | \n", "yes | \n", "KPHL | \n", "PHL | \n", "PHL | \n", "http://www.phl.org/ | \n", "http://en.wikipedia.org/wiki/Philadelphia_Inte... | \n", "NaN | \n", "
37977 | \n", "325027 | \n", "PHL | \n", "closed | \n", "Erase Me 19 | \n", "0.000000 | \n", "-0.400000 | \n", "NaN | \n", "NaN | \n", "US | \n", "US-PA | \n", "NaN | \n", "no | \n", "NaN | \n", "PHL | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
\n", " | id | \n", "ident | \n", "type | \n", "name | \n", "latitude_deg | \n", "longitude_deg | \n", "elevation_ft | \n", "continent | \n", "iso_country | \n", "iso_region | \n", "municipality | \n", "scheduled_service | \n", "gps_code | \n", "iata_code | \n", "local_code | \n", "home_link | \n", "wikipedia_link | \n", "keywords | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28336 | \n", "3771 | \n", "KPHL | \n", "large_airport | \n", "Philadelphia International Airport | \n", "39.871899 | \n", "-75.241096 | \n", "36.0 | \n", "NaN | \n", "US | \n", "US-PA | \n", "Philadelphia | \n", "yes | \n", "KPHL | \n", "PHL | \n", "PHL | \n", "http://www.phl.org/ | \n", "http://en.wikipedia.org/wiki/Philadelphia_Inte... | \n", "NaN | \n", "
\n", " | Code_Origin | \n", "Code_Dest | \n", "
---|---|---|
2 | \n", "SEA | \n", "SFO | \n", "
3 | \n", "HKG | \n", "SEA | \n", "
4 | \n", "PVG | \n", "HKG | \n", "
5 | \n", "PEK | \n", "SHA | \n", "
6 | \n", "SFO | \n", "PEK | \n", "
\n", " | latitude_deg | \n", "longitude_deg | \n", "iata_code | \n", "
---|---|---|---|
29487 | \n", "41.920799 | \n", "-71.491402 | \n", "SFZ | \n", "
29488 | \n", "-6.362000 | \n", "146.710000 | \n", "KSG | \n", "
29489 | \n", "37.245701 | \n", "-93.388603 | \n", "SGF | \n", "
29490 | \n", "39.840302 | \n", "-83.840202 | \n", "SGH | \n", "
\n", " | Code_Origin | \n", "Code_Dest | \n", "lat_Origin | \n", "lon_Origin | \n", "lat_Dest | \n", "lon_Dest | \n", "
---|---|---|---|---|---|---|
0 | \n", "SEA | \n", "SFO | \n", "47.449001 | \n", "-122.308998 | \n", "37.618999 | \n", "-122.375 | \n", "
1 | \n", "CPH | \n", "SFO | \n", "55.617901 | \n", "12.656000 | \n", "37.618999 | \n", "-122.375 | \n", "
2 | \n", "ABQ | \n", "SFO | \n", "35.040199 | \n", "-106.609001 | \n", "37.618999 | \n", "-122.375 | \n", "
3 | \n", "IAD | \n", "SFO | \n", "38.944500 | \n", "-77.455803 | \n", "37.618999 | \n", "-122.375 | \n", "
4 | \n", "IAD | \n", "SFO | \n", "38.944500 | \n", "-77.455803 | \n", "37.618999 | \n", "-122.375 | \n", "