In [2]:
import pandas as pd, json, numpy as np
import matplotlib.pyplot as plt
%matplotlib inline
Load airports of each country
In [7]:
L=json.loads(file('../json/L.json','r').read())
M=json.loads(file('../json/M.json','r').read())
N=json.loads(file('../json/N.json','r').read())
In [15]:
import requests
In [15]:
AP={}
for c in M:
if c not in AP:AP[c]={}
for i in range(len(L[c])):
AP[c][N[c][i]]=L[c][i]
In [18]:
sch={}
record schedules for 2 weeks, then augment count with weekly flight numbers. seasonal and seasonal charter will count as once per week for 3 months, so 12/52 per week. TGM separate, since its history is in the past.
In [24]:
baseurl='https://www.airportia.com/'
import requests, urllib2
SC={}
parse Arrivals
In [ ]:
for c in AP:
print c
airportialinks=AP[c]
sch={}
for i in airportialinks:
print i,
if i not in sch:sch[i]={}
#march 4-31 = 4 weeks
for d in range (4,32):
if d not in sch[i]:
try:
#capture token
url=baseurl+airportialinks[i]+'arrivals/201703'+str(d)
s = requests.Session()
cookiesopen = s.get(url)
cookies=str(s.cookies)
fcookies=[[k[:k.find('=')],k[k.find('=')+1:k.find(' for ')]] for k in cookies[cookies.find('Cookie '):].split('Cookie ')[1:]]
#push token
opener = urllib2.build_opener()
for k in fcookies:
opener.addheaders.append(('Cookie', k[0]+'='+k[1]))
#read html
m=s.get(url).content
sch[i][url]=pd.read_html(m)[0]
except: pass #print 'no tables',i,d
print
SC[c]=sch
Canada
YUY YUX XBW ZQS XBR YUL
parse Departures
In [ ]:
SD={}
In [ ]:
for c in AP:
print c
airportialinks=AP[c]
sch={}
for i in airportialinks:
print i,
if i not in sch:sch[i]={}
#march 4-31 = 4 weeks
for d in range (4,32):
if d not in sch[i]:
try:
#capture token
url=baseurl+airportialinks[i]+'departures/201703'+str(d)
s = requests.Session()
cookiesopen = s.get(url)
cookies=str(s.cookies)
fcookies=[[k[:k.find('=')],k[k.find('=')+1:k.find(' for ')]] for k in cookies[cookies.find('Cookie '):].split('Cookie ')[1:]]
#push token
opener = urllib2.build_opener()
for k in fcookies:
opener.addheaders.append(('Cookie', k[0]+'='+k[1]))
#read html
m=s.get(url).content
sch[i][url]=pd.read_html(m)[0]
except: pass #print 'no tables',i,d
print
SD[c]=sch
In [ ]:
In [ ]:
In [27]:
SC
Out[27]:
{'Hungary': {u'BUD': {u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170311': Flight From Airline Scheduled Arrival Status \
0 W62264 Nice NCE Wizz Air 00:35 00:43 Landed
1 W62336 Milan MXP Wizz Air 00:50 00:51 Landed
2 W62372 Madrid MAD Wizz Air 00:55 00:56 Landed
3 W62494 Tenerife TFS Wizz Air 00:55 00:58 Landed
4 W62394 Lisbon LIS Wizz Air 02:10 01:47 Landed
5 W62248 Kutaisi KUT Wizz Air 07:50 07:41 Landed
6 EW4990 Stuttgart STR Eurowings 09:10 09:05 Landed
7 AB4990 Stuttgart STR Air Berlin 09:10 NaN Scheduled
8 LO533 Warsaw WAW LOT 09:25 09:28 Landed
9 4U9784 Dusseldorf DUS Germanwings 09:35 09:25 Landed
10 LH1674 Munich MUC Lufthansa 09:45 09:36 Landed
11 FR8368 Madrid MAD Ryanair 11:05 10:57 Landed
12 N7753 Helsinki HEL Brava Linhas Aereas 11:50 NaN Scheduled
13 DY1550 Oslo OSL Norwegian 12:00 11:53 Landed
14 BA868 London LHR British Airways 12:25 12:29 Landed
15 PC457 Istanbul SAW Pegasus Airlines 12:35 12:22 Landed
16 U28423 London LGW EasyJet 12:45 12:52 Landed
17 W62354 Catania CTA Wizz Air 12:55 13:37 Delayed
18 U23311 Venice VCE EasyJet 13:55 13:52 Landed
19 W62224 Glasgow GLA Wizz Air 14:05 13:50 Landed
20 U23855 Paris CDG EasyJet 14:30 14:24 Landed
21 MS751 Cairo CAI EgyptAir 14:55 14:48 Landed
22 W62360 Naples NAP Wizz Air 15:20 15:28 Landed
23 FR8358 Manchester MAN Ryanair 15:35 15:34 Landed
24 W62388 Alicante ALC Wizz Air 15:40 15:39 Landed
25 W62410 Malmo MMX Wizz Air 15:55 15:32 Landed
26 W62486 Cluj-Napoca CLJ Wizz Air 17:20 17:08 Landed
27 FR8744 Billund BLL Ryanair 17:35 17:15 Landed
28 U24345 Lyon LYS EasyJet 17:55 18:25 Delayed
29 W62496 Luqa MLA Wizz Air 18:45 18:57 Landed
30 N7755 Helsinki HEL Brava Linhas Aereas 19:30 NaN Scheduled
31 AY755 Helsinki HEL Finnair 19:30 19:21 Landed
32 W62300 Hahn HHN Wizz Air 19:35 19:18 Landed
33 W62472 Sofia SOF Wizz Air 20:00 19:50 Landed
34 FR2621 Eilat VDA Ryanair 20:15 20:10 Landed
35 FR8394 Barcelona BCN Ryanair 20:35 20:50 Landed
36 TK6389 Kiev KBP Turkish Airlines 20:40 19:13 Landed
37 W62218 Birmingham BHX Wizz Air 22:00 22:11 Landed
38 W62208 London LTN Wizz Air 22:00 21:46 Landed
39 FR8398 Nurnberg NUE Ryanair 23:05 22:37 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
30 Track >
31 Track >
32 Track >
33 Track >
34 Track >
35 Track >
36 Track >
37 Track >
38 Track >
39 Track > ,
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170312': Flight From Airline Scheduled Arrival Status \
0 FR8206 Bristol BRS Ryanair 00:15 23:51 Landed
1 W62452 Larnaca LCA Wizz Air 00:25 00:02 Landed
2 W62406 Gothenburg GOT Wizz Air 00:55 00:41 Landed
3 W62390 Malaga AGP Wizz Air 01:20 01:10 Landed
4 W62498 Dubai DWC Wizz Air 01:50 01:55 Landed
5 QR8231 Doha DOH Qatar Air Cargo 06:25 08:30 Delayed
6 SM631 Hurghada HRG Air Cairo 08:00 07:43 Landed
7 W62474 Kiev IEV Wizz Air 08:50 08:36 Landed
8 DY3550 Copenhagen CPH SmartLynx 10:25 10:29 Landed
9 LY2365 Tel Aviv TLV El Al 10:45 10:23 Landed
10 A3878 Athens ATH Aegean Airlines 10:50 10:42 Landed
11 DY1550 Oslo OSL Norwegian 11:00 10:53 Landed
12 FR8368 Madrid MAD Ryanair 11:05 10:51 Landed
13 W62292 Dortmund DTM Wizz Air 11:20 11:14 Landed
14 EI672 Dublin DUB Aer Lingus 11:25 11:29 Landed
15 DY4487 Stockholm ARN Norwegian 12:05 11:50 Landed
16 BA868 London LHR British Airways 12:25 12:27 Landed
17 PC457 Istanbul SAW Pegasus Airlines 12:35 12:03 Landed
18 U28423 London LGW EasyJet 12:45 12:54 Landed
19 W62468 Warsaw WAW Wizz Air 12:45 12:37 Landed
20 FR2274 Malaga AGP Ryanair 12:55 12:40 Landed
21 AH2040 Algiers ALG Air Algerie 13:00 13:12 Landed
22 B2813 Minsk MSQ Belavia 13:20 13:20 Landed
23 U21233 Basel BSL EasyJet 13:55 13:58 Landed
24 U24623 Berlin SXF EasyJet 14:10 14:22 Landed
25 4U7782 Hamburg HAM Germanwings 14:40 14:41 Landed
26 RO233 Bucharest OTP Tarom 14:45 14:33 Landed
27 BT491 Riga RIX Air Baltic 14:45 14:39 Landed
28 MS751 Cairo CAI EgyptAir 14:55 14:45 Landed
29 W62362 Bari BRI Wizz Air 15:00 14:45 Landed
.. ... ... ... ... ... ...
34 W62410 Malmo MMX Wizz Air 15:55 15:37 Landed
35 HV6773 Rotterdam RTM Transavia 16:25 16:21 Landed
36 FR8414 Paris BVA Ryanair 16:35 16:21 Landed
37 U28425 London LGW EasyJet 16:40 16:56 Delayed
38 QR201 Doha DOH Qatar Airways 17:40 17:25 Landed
39 SN2825 Brussels BRU Brussels Airlines 18:00 17:57 Landed
40 FR5046 Treviso TSF Ryanair 18:25 18:12 Landed
41 W62404 Stockholm NYO Wizz Air 18:45 18:29 Landed
42 LS897 Manchester MAN Jet2 18:50 18:40 Landed
43 AY755 Helsinki HEL Finnair 19:30 19:14 Landed
44 AB8266 Berlin TXL Air Berlin 19:35 20:20 Delayed
45 LS787 Edinburgh EDI Jet2 19:50 19:36 Landed
46 W62470 Bucharest OTP Wizz Air 20:00 19:44 Landed
47 OK788 Prague PRG Czech Airlines 20:20 20:14 Landed
48 W62274 Eindhoven EIN Wizz Air 20:20 20:12 Landed
49 FR1242 Athens ATH Ryanair 20:30 20:16 Landed
50 FR8394 Barcelona BCN Ryanair 20:35 20:35 Landed
51 EW1788 Dusseldorf DUS Eurowings 20:45 20:44 Landed
52 D8442 Helsinki HEL Norwegian 21:00 20:59 Landed
53 4U788 Cologne CGN Germanwings 21:05 20:57 Landed
54 LO531 Warsaw WAW LOT 21:05 21:03 Landed
55 U24609 Berlin SXF EasyJet 21:05 20:57 Landed
56 DY1552 Oslo OSL Norwegian 21:45 21:39 Landed
57 4U2784 Stuttgart STR Germanwings 21:50 21:39 Landed
58 W62208 London LTN Wizz Air 22:00 22:03 Landed
59 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
60 FR8398 Nurnberg NUE Ryanair 23:05 23:00 Landed
61 SN2829 Brussels BRU Brussels Airlines 23:30 23:32 Landed
62 LY2367 Tel Aviv TLV El Al 23:40 23:13 Landed
63 W62356 Bologna BLQ Wizz Air 23:50 23:43 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
.. ...
34 Track >
35 Track >
36 Track >
37 Track >
38 Track >
39 Track >
40 Track >
41 Track >
42 Track >
43 Track >
44 Track >
45 Track >
46 Track >
47 Track >
48 Track >
49 Track >
50 Track >
51 Track >
52 Track >
53 Track >
54 Track >
55 Track >
56 Track >
57 Track >
58 Track >
59 Track >
60 Track >
61 Track >
62 Track >
63 Track >
[64 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170313': Flight From Airline Scheduled Arrival Status \
0 W62392 Fuerteventura FUE Wizz Air 00:25 00:05 Landed
1 FR8358 Manchester MAN Ryanair 00:45 00:38 Landed
2 W62336 Milan MXP Wizz Air 00:45 00:36 Landed
3 W62372 Madrid MAD Wizz Air 00:55 00:49 Landed
4 W62428 Reykjavik KEF Wizz Air 01:50 01:23 Landed
5 W62394 Lisbon LIS Wizz Air 01:55 01:51 Landed
6 W62474 Kiev IEV Wizz Air 08:50 08:30 Landed
7 B2811 Minsk MSQ Belavia 09:05 08:50 Landed
8 W62500 Baku GYD Wizz Air 09:05 08:53 Landed
9 EW4990 Stuttgart STR Eurowings 09:10 08:58 Landed
10 4U788 Cologne CGN Germanwings 09:20 09:17 Landed
11 LO533 Warsaw WAW LOT 09:25 09:23 Landed
12 4U9784 Dusseldorf DUS Germanwings 09:35 09:25 Landed
13 RO231 Bucharest OTP Tarom 09:45 09:45 Landed
14 LH1674 Munich MUC Air Dolomiti 09:45 09:45 Landed
15 OK786 Prague PRG Czech Airlines 09:45 09:45 Landed
16 HV6771 Rotterdam RTM Transavia 10:15 10:07 Landed
17 LY2365 Tel Aviv TLV El Al 10:45 10:40 Landed
18 A3878 Athens ATH Aegean Airlines 10:50 10:44 Landed
19 U27915 Amsterdam AMS EasyJet 11:05 10:51 Landed
20 EI672 Dublin DUB Aer Lingus 11:15 11:04 Landed
21 W62292 Dortmund DTM Wizz Air 11:20 11:08 Landed
22 DY3550 Copenhagen CPH Norwegian 11:40 11:31 Landed
23 B2812 Belgrade BEG Belavia 11:50 NaN Scheduled
24 W62282 Brussels CRL Wizz Air 12:00 11:53 Landed
25 DY4487 Stockholm ARN Norwegian 12:05 11:57 Landed
26 FR1025 Dublin DUB Ryanair 12:20 12:16 Landed
27 BA868 London LHR British Airways 12:25 12:22 Landed
28 PC457 Istanbul SAW Pegasus Airlines 12:35 12:12 Landed
29 W62468 Warsaw WAW Wizz Air 12:45 12:44 Landed
.. ... ... ... ... ... ...
39 U24345 Lyon LYS EasyJet 16:15 15:56 Landed
40 FR8414 Paris BVA Ryanair 16:35 16:19 Landed
41 U28425 London LGW EasyJet 16:40 16:38 Landed
42 U24623 Berlin SXF EasyJet 17:10 NaN NaN
43 QR201 Doha DOH Qatar Airways 17:40 17:13 Landed
44 LS897 Manchester MAN Jet2 17:50 17:45 Landed
45 SN2825 Brussels BRU Brussels Airlines 18:00 17:57 Landed
46 FR5024 Pisa PSA Ryanair 18:20 18:19 Landed
47 W62404 Stockholm NYO Wizz Air 18:45 18:29 Landed
48 LS607 East Midlands EMA Jet2 18:55 18:34 Landed
49 W62448 Thessaloniki SKG Wizz Air 19:30 19:12 Landed
50 LS431 Leeds LBA Jet2 19:35 19:23 Landed
51 AB8266 Berlin TXL Air Berlin 19:35 NaN Scheduled
52 CA721 Minsk MSQ Air China 19:40 NaN Scheduled
53 OK788 Prague PRG Czech Airlines 20:20 19:57 Landed
54 W62274 Eindhoven EIN Wizz Air 20:20 20:12 Landed
55 4U2784 Stuttgart STR Germanwings 20:20 20:12 Landed
56 FR1242 Athens ATH Ryanair 20:30 20:05 Landed
57 FR8394 Barcelona BCN Ryanair 20:35 20:22 Landed
58 TO3742 Paris ORY Transavia 20:40 20:37 Landed
59 EW1788 Dusseldorf DUS Eurowings 20:45 20:37 Landed
60 FR8432 Brussels CRL Ryanair 20:55 20:37 Landed
61 LH1680 Munich MUC Air Dolomiti 21:00 NaN Scheduled
62 LO531 Warsaw WAW LOT 21:05 21:03 Landed
63 U23311 Venice VCE EasyJet 21:55 NaN Scheduled
64 W62208 London LTN Wizz Air 22:00 21:39 Landed
65 FR8246 Rome CIA Ryanair 22:35 22:33 Landed
66 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
67 FR8398 Nurnberg NUE Ryanair 23:05 22:48 Landed
68 SN2829 Brussels BRU Brussels Airlines 23:30 23:28 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
.. ...
39 Track >
40 Track >
41 Track >
42 Track >
43 Track >
44 Track >
45 Track >
46 Track >
47 Track >
48 Track >
49 Track >
50 Track >
51 Track >
52 Track >
53 Track >
54 Track >
55 Track >
56 Track >
57 Track >
58 Track >
59 Track >
60 Track >
61 Track >
62 Track >
63 Track >
64 Track >
65 Track >
66 Track >
67 Track >
68 Track >
[69 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170314': Flight From Airline Scheduled Arrival Status \
0 W62264 Nice NCE Wizz Air 00:35 00:41 Landed
1 W62336 Milan MXP Wizz Air 00:45 00:41 Landed
2 W62494 Tenerife TFS Wizz Air 00:55 00:41 Landed
3 W62372 Madrid MAD Wizz Air 01:05 01:00 Landed
4 W62210 London LTN Wizz Air 01:20 01:30 Landed
5 W62394 Lisbon LIS Wizz Air 01:55 01:57 Landed
6 W62248 Kutaisi KUT Wizz Air 07:50 07:32 Landed
7 LO533 Warsaw WAW LOT 09:25 09:19 Landed
8 4U9784 Dusseldorf DUS Germanwings 09:35 09:10 Landed
9 OK786 Prague PRG Czech Airlines 09:45 09:42 Landed
10 LH1674 Munich MUC Air Dolomiti 09:45 09:38 Landed
11 HV6771 Rotterdam RTM Transavia 10:15 10:06 Landed
12 LY2365 Tel Aviv TLV El Al 10:45 10:33 Landed
13 DY3550 Copenhagen CPH Norwegian 11:05 11:04 Landed
14 FR8368 Madrid MAD Ryanair 11:05 11:06 Landed
15 BA868 London LHR British Airways 12:25 12:31 Landed
16 U28423 London LGW EasyJet 12:45 12:50 Landed
17 W62354 Catania CTA Wizz Air 12:55 12:37 Landed
18 4U7782 Hamburg HAM Germanwings 13:40 13:39 Landed
19 DY1550 Oslo OSL Norwegian 14:00 13:37 Landed
20 W62224 Glasgow GLA Wizz Air 14:05 14:07 Landed
21 FR2967 Las Palmas LPA Ryanair 14:40 14:37 Landed
22 MS751 Cairo CAI EgyptAir 14:55 14:45 Landed
23 W62360 Naples NAP Wizz Air 15:20 15:13 Landed
24 W62410 Malmo MMX Wizz Air 15:55 15:49 Landed
25 D82570 London LGW Norwegian 15:55 15:41 Landed
26 U24623 Berlin SXF EasyJet 16:30 NaN NaN
27 U28425 London LGW EasyJet 16:40 16:28 Landed
28 W62486 Cluj-Napoca CLJ Wizz Air 17:20 17:01 Landed
29 FR8206 Bristol BRS Ryanair 17:25 17:36 Landed
30 FR8744 Billund BLL Ryanair 17:35 17:28 Landed
31 CV7332 Hong Kong HKG Cargolux 17:45 NaN Scheduled
32 SN2825 Brussels BRU Brussels Airlines 18:00 18:02 Landed
33 W62496 Luqa MLA Wizz Air 18:45 18:42 Landed
34 AY755 Helsinki HEL Finnair 19:30 19:14 Landed
35 AB8266 Berlin TXL Air Berlin 19:35 NaN Scheduled
36 W62300 Hahn HHN Wizz Air 19:35 19:31 Landed
37 W62472 Sofia SOF Wizz Air 20:00 19:48 Landed
38 RO237 Bucharest OTP Tarom 20:20 20:16 Landed
39 EW4916 Stuttgart STR Eurowings 20:20 20:31 Landed
40 OK788 Prague PRG Czech Airlines 20:20 20:12 Landed
41 4U9782 Dusseldorf DUS Germanwings 20:45 20:37 Landed
42 HV6773 Rotterdam RTM Transavia 20:55 20:52 Landed
43 LH1680 Munich MUC Air Dolomiti 21:00 20:59 Landed
44 LO531 Warsaw WAW LOT 21:05 21:03 Landed
45 D8442 Helsinki HEL Norwegian 21:25 21:12 Landed
46 W62218 Birmingham BHX Wizz Air 22:00 21:44 Landed
47 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
48 FR8398 Nurnberg NUE Ryanair 23:05 22:48 Landed
49 SN2829 Brussels BRU Brussels Airlines 23:30 23:32 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
30 Track >
31 Track >
32 Track >
33 Track >
34 Track >
35 Track >
36 Track >
37 Track >
38 Track >
39 Track >
40 Track >
41 Track >
42 Track >
43 Track >
44 Track >
45 Track >
46 Track >
47 Track >
48 Track >
49 Track > ,
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170315': Flight From Airline Scheduled Arrival Status \
0 FR8358 Manchester MAN Ryanair 00:20 00:17 Landed
1 W62452 Larnaca LCA Wizz Air 00:25 23:50 Landed
2 W62406 Gothenburg GOT Wizz Air 00:55 00:43 Landed
3 W62210 London LTN Wizz Air 01:20 00:58 Landed
4 W62390 Malaga AGP Wizz Air 01:20 01:38 Delayed
5 W62498 Dubai DWC Wizz Air 01:50 01:36 Landed
6 TK6391 Kiev KBP ULS Airlines Cargo 06:25 05:58 Landed
7 W62474 Kiev IEV Wizz Air 08:50 08:41 Landed
8 LO533 Warsaw WAW LOT 09:25 09:21 Landed
9 4U9784 Dusseldorf DUS Germanwings 09:35 09:17 Landed
10 LH1674 Munich MUC Air Dolomiti 09:45 09:40 Landed
11 OK786 Prague PRG Czech Airlines 09:45 09:28 Landed
12 RO231 Bucharest OTP Tarom 09:45 09:36 Landed
13 HV6771 Rotterdam RTM Transavia 10:15 10:03 Landed
14 LY2365 Tel Aviv TLV El Al 10:45 10:40 Landed
15 FR8368 Madrid MAD Ryanair 11:05 11:01 Landed
16 U27915 Amsterdam AMS EasyJet 11:05 10:34 Landed
17 W62292 Dortmund DTM Wizz Air 11:20 11:23 Landed
18 EI672 Dublin DUB Aer Lingus 12:00 11:27 Landed
19 DY4487 Stockholm ARN Norwegian 12:05 11:53 Landed
20 BA868 London LHR British Airways 12:25 12:16 Landed
21 EW4990 Stuttgart STR Eurowings 12:35 12:29 Landed
22 W62468 Warsaw WAW Wizz Air 12:45 NaN Scheduled
23 4U7782 Hamburg HAM Germanwings 12:50 12:40 Landed
24 W62376 Barcelona BCN Wizz Air 12:55 13:09 Landed
25 U21233 Basel BSL EasyJet 13:55 13:52 Landed
26 DY1550 Oslo OSL Norwegian 14:00 13:39 Landed
27 W62362 Bari BRI Wizz Air 15:10 15:11 Landed
28 W62396 Porto OPO Wizz Air 15:35 15:34 Landed
29 FR5046 Treviso TSF Ryanair 15:55 15:43 Landed
30 U23853 Paris CDG EasyJet 16:15 16:13 Landed
31 U28425 London LGW EasyJet 16:40 16:30 Landed
32 U24623 Berlin SXF EasyJet 17:10 17:13 Landed
33 BA866 London LHR British Airways 17:50 17:40 Landed
34 SN2825 Brussels BRU Brussels Airlines 18:00 17:53 Landed
35 TK6391 Kiev KBP Turkish Airlines 18:30 NaN Scheduled
36 W62404 Stockholm NYO Wizz Air 18:45 18:34 Landed
37 OS721 Vienna VIE Austrian Airlines 19:05 NaN Scheduled
38 AB8266 Berlin TXL Air Berlin 19:35 19:16 Landed
39 CA722 Minsk MSQ Air China 19:40 NaN Scheduled
40 CA721 Minsk MSQ Air China 19:40 19:33 Landed
41 FR2274 Malaga AGP Ryanair 19:45 19:46 Landed
42 W62470 Bucharest OTP Wizz Air 20:00 19:33 Landed
43 LX2258 Zurich ZRH Helvetic Airways 20:05 20:05 Landed
44 OK788 Prague PRG Czech Airlines 20:20 20:12 Landed
45 4U2784 Stuttgart STR Germanwings 20:20 20:14 Landed
46 W62274 Eindhoven EIN Wizz Air 20:25 20:04 Landed
47 FR1242 Athens ATH Ryanair 20:30 20:27 Landed
48 FR8394 Barcelona BCN Ryanair 20:35 20:37 Landed
49 EW1788 Dusseldorf DUS Eurowings 20:45 20:35 Landed
50 FR2621 Eilat VDA Ryanair 20:50 21:24 Delayed
51 LH1680 Munich MUC Air Dolomiti 21:00 20:59 Landed
52 LO531 Warsaw WAW LOT 21:05 21:03 Landed
53 4U788 Cologne CGN Germanwings 21:05 20:57 Landed
54 FR8371 London STN Ryanair 22:00 21:39 Landed
55 CV7333 Hong Kong HKG Cargolux 22:30 NaN Scheduled
56 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
57 FR8398 Nurnberg NUE Ryanair 23:05 23:00 Landed
58 SN2829 Brussels BRU Brussels Airlines 23:30 23:30 Landed
59 W62356 Bologna BLQ Wizz Air 23:50 23:41 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
30 Track >
31 Track >
32 Track >
33 Track >
34 Track >
35 Track >
36 Track >
37 Track >
38 Track >
39 Track >
40 Track >
41 Track >
42 Track >
43 Track >
44 Track >
45 Track >
46 Track >
47 Track >
48 Track >
49 Track >
50 Track >
51 Track >
52 Track >
53 Track >
54 Track >
55 Track >
56 Track >
57 Track >
58 Track >
59 Track > ,
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170316': Flight From Airline Scheduled Arrival Status \
0 LH1682 Munich MUC Lufthansa 00:15 00:14 Landed
1 W62400 Lanzarote ACE Wizz Air 00:15 00:13 Landed
2 FR8414 Paris BVA Ryanair 00:45 00:41 Landed
3 W62336 Milan MXP Wizz Air 00:50 00:45 Landed
4 W62372 Madrid MAD Wizz Air 01:05 00:53 Landed
5 W62210 London LTN Wizz Air 01:20 01:10 Landed
6 W62428 Reykjavik KEF Wizz Air 01:50 01:55 Landed
7 W62394 Lisbon LIS Wizz Air 01:55 01:49 Landed
8 LO533 Warsaw WAW LOT 09:25 09:08 Landed
9 RO231 Bucharest OTP Tarom 09:45 09:38 Landed
10 LH1674 Munich MUC Air Dolomiti 09:45 09:39 Landed
11 OK786 Prague PRG Czech Airlines 09:45 09:38 Landed
12 HV6771 Rotterdam RTM Transavia 10:15 10:04 Landed
13 U24609 Berlin SXF EasyJet 10:25 10:12 Landed
14 U24345 Lyon LYS EasyJet 10:35 10:38 Landed
15 LY2365 Tel Aviv TLV El Al 10:45 10:51 Landed
16 DY3550 Copenhagen CPH Norwegian 11:05 10:59 Landed
17 FR8368 Madrid MAD Ryanair 11:05 10:57 Landed
18 W62292 Dortmund DTM Wizz Air 11:20 11:27 Landed
19 EI672 Dublin DUB Aer Lingus 11:25 11:14 Landed
20 BA868 London LHR British Airways 12:25 12:21 Landed
21 PC457 Istanbul SAW Pegasus Airlines 12:35 12:10 Landed
22 U28423 London LGW EasyJet 12:45 12:59 Landed
23 W62490 Moscow VKO Wizz Air 12:50 12:25 Landed
24 W62376 Barcelona BCN Wizz Air 12:55 12:49 Landed
25 AH2040 Algiers ALG Air Algerie 13:00 13:23 Delayed
26 LS787 Edinburgh EDI Jet2 13:00 13:03 Landed
27 4U7782 Hamburg HAM Germanwings 13:40 13:28 Landed
28 U21233 Basel BSL EasyJet 13:55 13:49 Landed
29 DY1550 Oslo OSL Norwegian 14:00 13:39 Landed
.. ... ... ... ... ... ...
35 QR8231 Doha DOH Qatar Air Cargo 16:25 16:29 Landed
36 U28425 London LGW EasyJet 16:40 16:37 Landed
37 B2812 Belgrade BEG Belavia 16:50 NaN Scheduled
38 U24623 Berlin SXF EasyJet 17:05 16:57 Landed
39 U23311 Venice VCE EasyJet 17:15 16:59 Landed
40 FR8206 Bristol BRS Ryanair 17:25 17:31 Landed
41 BA866 London LHR British Airways 17:50 18:10 Delayed
42 SN2825 Brussels BRU Brussels Airlines 18:00 17:53 Landed
43 QR201 Doha DOH Qatar Airways 18:10 17:41 Landed
44 W62496 Luqa MLA Wizz Air 18:45 18:40 Landed
45 OS721 Vienna VIE Austrian Airlines 19:05 NaN Scheduled
46 AY755 Helsinki HEL Finnair 19:30 19:10 Landed
47 AB8266 Berlin TXL Air Berlin 19:35 19:29 Landed
48 LX2258 Zurich ZRH Swiss 20:05 20:10 Landed
49 RO237 Bucharest OTP Tarom 20:20 20:21 Landed
50 TK6387 Kiev KBP Turkish Airlines 20:20 NaN Scheduled
51 OK788 Prague PRG Czech Airlines 20:20 20:08 Landed
52 EW1788 Dusseldorf DUS Eurowings 20:45 20:38 Landed
53 FR8432 Brussels CRL Ryanair 20:55 20:39 Landed
54 LH1680 Munich MUC Lufthansa 21:00 NaN Scheduled
55 LO531 Warsaw WAW LOT 21:05 20:37 Landed
56 D8442 Helsinki HEL Norwegian 21:25 20:59 Landed
57 4U2784 Stuttgart STR Germanwings 21:50 21:45 Landed
58 FR8371 London STN Ryanair 22:00 21:47 Landed
59 W62208 London LTN Wizz Air 22:00 21:43 Landed
60 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
61 FR8398 Nurnberg NUE Ryanair 23:05 22:45 Landed
62 SN2829 Brussels BRU Brussels Airlines 23:30 23:26 Landed
63 LY2367 Tel Aviv TLV El Al 23:40 23:42 Landed
64 AB8260 Berlin TXL Air Berlin 23:55 23:45 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
.. ...
35 Track >
36 Track >
37 Track >
38 Track >
39 Track >
40 Track >
41 Track >
42 Track >
43 Track >
44 Track >
45 Track >
46 Track >
47 Track >
48 Track >
49 Track >
50 Track >
51 Track >
52 Track >
53 Track >
54 Track >
55 Track >
56 Track >
57 Track >
58 Track >
59 Track >
60 Track >
61 Track >
62 Track >
63 Track >
64 Track >
[65 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170317': Flight From Airline Scheduled Arrival \
0 LH1682 Munich MUC Lufthansa 00:15 00:11
1 FR8358 Manchester MAN Ryanair 00:20 00:16
2 W62406 Gothenburg GOT Wizz Air 00:55 00:37
3 W62210 London LTN Wizz Air 01:20 01:04
4 W62498 Dubai DWC Wizz Air 01:50 01:48
5 TK6387 Kiev KBP ULS Airlines Cargo 06:55 06:45
6 OS1471 Vienna VIE Austrian Airlines 08:20 NaN
7 W62474 Kiev IEV Wizz Air 08:50 08:28
8 TK1035 Istanbul IST Turkish Airlines 09:20 09:28
9 LO533 Warsaw WAW LOT 09:25 09:04
10 4U9784 Dusseldorf DUS Germanwings 09:35 09:26
11 LH1674 Munich MUC Air Dolomiti 09:45 09:41
12 OK786 Prague PRG Czech Airlines 09:45 09:40
13 LX2250 Zurich ZRH Swiss 09:50 10:02
14 AF1394 Paris CDG Air France 10:05 09:55
15 HV6771 Rotterdam RTM Transavia 10:15 09:57
16 U24609 Berlin SXF EasyJet 10:25 10:06
17 FR196 Berlin SXF Ryanair 10:35 10:23
18 LY2365 Tel Aviv TLV El Al 10:45 10:41
19 A3878 Athens ATH Aegean Airlines 10:50 10:48
20 W62334 Milan MXP Wizz Air 10:50 10:37
21 AB8262 Berlin TXL Eurowings 11:00 10:49
22 LH1334 Frankfurt FRA Lufthansa 11:05 11:15
23 U27915 Amsterdam AMS EasyJet 11:05 10:46
24 FR8418 Rome CIA Ryanair 11:10 10:59
25 6H715 Tel Aviv TLV Israir Airlines 11:15 11:43
26 W62292 Dortmund DTM Wizz Air 11:20 11:36
27 QR199 Doha DOH Qatar Airways 11:25 11:58
28 EI672 Dublin DUB Aer Lingus 11:25 11:14
29 OS713 Vienna VIE Austrian Airlines 11:40 NaN
.. ... ... ... ... ...
91 CA722 Minsk MSQ Air China 19:40 NaN
92 W62470 Bucharest OTP Wizz Air 20:00 19:56
93 LX2258 Zurich ZRH Swiss 20:05 20:05
94 OK788 Prague PRG Czech Airlines 20:20 20:29
95 RO237 Bucharest OTP Tarom 20:20 20:38
96 W62274 Eindhoven EIN Wizz Air 20:25 20:19
97 TK1037 Istanbul IST Turkish Airlines 20:30 NaN
98 TK1037 Istanbul IST Turkish Airlines 20:30 20:41
99 FR1242 Athens ATH Ryanair 20:30 20:26
100 FR8394 Barcelona BCN Ryanair 20:35 20:34
101 EW9782 Dusseldorf DUS Eurowings 20:45 20:32
102 TO3742 Paris ORY Transavia 20:50 20:44
103 LH1680 Munich MUC Lufthansa 21:00 NaN
104 4U788 Cologne CGN Germanwings 21:05 20:56
105 LO531 Warsaw WAW LOT 21:05 20:49
106 DY1552 Oslo OSL Norwegian 21:45 21:34
107 4U2784 Stuttgart STR Germanwings 21:50 21:40
108 W62208 London LTN Wizz Air 22:00 21:50
109 FR8371 London STN Ryanair 22:00 21:33
110 FR8246 Rome CIA Ryanair 22:35 22:30
111 W62448 Thessaloniki SKG Wizz Air 22:40 22:39
112 BA870 London LHR British Airways 22:40 22:35
113 SU2468 Moscow SVO Aeroflot 22:55 22:56
114 OS717 Vienna VIE Austrian Airlines 23:00 NaN
115 FR8398 Nurnberg NUE Ryanair 23:05 NaN
116 SN2829 Brussels BRU Brussels Airlines 23:30 23:40
117 AB8260 Berlin TXL Air Berlin 23:55 23:47
118 W62284 Brussels CRL Wizz Air 23:55 23:39
119 AF1694 Paris CDG Air France 23:55 23:40
120 LH1342 Frankfurt FRA Lufthansa 00:00 23:54
Status Unnamed: 6
0 Landed Track >
1 Landed Track >
2 Landed Track >
3 Landed Track >
4 Landed Track >
5 Landed Track >
6 Scheduled Track >
7 Landed Track >
8 Landed Track >
9 Landed Track >
10 Landed Track >
11 Landed Track >
12 Landed Track >
13 Landed Track >
14 Landed Track >
15 Landed Track >
16 Landed Track >
17 Landed Track >
18 Landed Track >
19 Landed Track >
20 Landed Track >
21 Landed Track >
22 Landed Track >
23 Landed Track >
24 Landed Track >
25 Delayed Track >
26 Delayed Track >
27 Delayed Track >
28 Landed Track >
29 Scheduled Track >
.. ... ...
91 Scheduled Track >
92 Landed Track >
93 Landed Track >
94 Landed Track >
95 Delayed Track >
96 Landed Track >
97 Scheduled Track >
98 Landed Track >
99 Landed Track >
100 Landed Track >
101 Landed Track >
102 Landed Track >
103 Scheduled Track >
104 Landed Track >
105 Landed Track >
106 Landed Track >
107 Landed Track >
108 Landed Track >
109 Landed Track >
110 Landed Track >
111 Landed Track >
112 Landed Track >
113 Landed Track >
114 Scheduled Track >
115 Scheduled Track >
116 Landed Track >
117 Landed Track >
118 Landed Track >
119 Landed Track >
120 Landed Track >
[121 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170318': Flight From Airline Scheduled Arrival Status \
0 LH1342 Frankfurt FRA Lufthansa 00:00 23:54 Landed
1 KL1979 Amsterdam AMS KLM 00:05 00:03 Landed
2 LH1682 Munich MUC Lufthansa 00:15 00:10 Landed
3 W62264 Nice NCE Wizz Air 00:35 01:09 Delayed
4 FR1023 Dublin DUB Ryanair 00:40 01:08 Delayed
5 W62336 Milan MXP Wizz Air 00:50 00:40 Landed
6 FR604 Copenhagen CPH Ryanair 00:50 00:32 Landed
7 W62372 Madrid MAD Wizz Air 00:55 00:57 Landed
8 W62494 Tenerife TFS Wizz Air 00:55 00:30 Landed
9 W62210 London LTN Wizz Air 01:20 02:16 Delayed
10 W62394 Lisbon LIS Wizz Air 02:10 02:21 Landed
11 W62248 Kutaisi KUT Wizz Air 07:50 07:36 Landed
12 EW4990 Stuttgart STR Eurowings 09:10 09:04 Landed
13 FR196 Berlin SXF Ryanair 09:20 08:59 Landed
14 TK1035 Istanbul IST Turkish Airlines 09:20 09:38 Delayed
15 LO533 Warsaw WAW LOT 09:25 09:23 Landed
16 4U9784 Dusseldorf DUS Germanwings 09:35 09:09 Landed
17 LH1674 Munich MUC Lufthansa 09:45 09:36 Landed
18 LX2250 Zurich ZRH Swiss 09:50 09:48 Landed
19 AF1394 Paris CDG AirExplore 10:05 10:31 Delayed
20 W62334 Milan MXP Wizz Air 10:50 10:47 Landed
21 AB8262 Berlin TXL Air Berlin 11:00 10:46 Landed
22 FR8368 Madrid MAD Ryanair 11:05 11:08 Landed
23 LH1334 Frankfurt FRA Lufthansa 11:05 10:57 Landed
24 FR8418 Rome CIA Ryanair 11:10 10:57 Landed
25 QR199 Doha DOH Qatar Airways 11:25 11:09 Landed
26 OS713 Vienna VIE Austrian Airlines 11:40 11:35 Landed
27 AY753 Helsinki HEL Finnair 11:50 11:38 Landed
28 W62272 Eindhoven EIN Wizz Air 12:00 12:02 Landed
29 DY1550 Oslo OSL Norwegian 12:00 12:41 Delayed
.. ... ... ... ... ... ...
58 FR8445 London STN Ryanair 16:10 16:21 Landed
59 AF1294 Paris CDG BH Air 16:35 17:17 Delayed
60 LH1678 Munich MUC Lufthansa 16:35 16:26 Landed
61 U21333 Geneva GVA EasyJet 16:35 16:34 Landed
62 W62340 Rome FCO Wizz Air 16:55 16:52 Landed
63 KL1977 Amsterdam AMS KLM 17:15 17:11 Landed
64 W62486 Cluj-Napoca CLJ Wizz Air 17:20 17:12 Landed
65 LO537 Warsaw WAW LOT 17:25 17:37 Landed
66 FR8744 Billund BLL Ryanair 17:35 17:23 Landed
67 AZ478 Rome FCO Alitalia 17:45 17:36 Landed
68 U24345 Lyon LYS EasyJet 17:55 17:39 Landed
69 W62496 Luqa MLA Wizz Air 18:45 18:51 Landed
70 LH1340 Frankfurt FRA Lufthansa 19:00 18:59 Landed
71 W62206 London LTN Wizz Air 19:00 19:16 Delayed
72 AY755 Helsinki HEL Finnair 19:30 19:08 Landed
73 W62300 Hahn HHN Wizz Air 19:35 19:51 Delayed
74 W62472 Sofia SOF Wizz Air 20:00 19:43 Landed
75 FR2621 Eilat VDA Ryanair 20:15 20:12 Landed
76 TK1037 Istanbul IST Turkish Airlines 20:30 NaN Scheduled
77 TK1037 Istanbul IST Turkish Airlines 20:30 20:33 Landed
78 FR8394 Barcelona BCN Ryanair 20:35 20:35 Landed
79 TK6389 Kiev KBP Turkish Airlines 20:40 NaN Scheduled
80 W62208 London LTN Wizz Air 22:00 21:45 Landed
81 W62218 Birmingham BHX Wizz Air 22:00 21:52 Landed
82 BA870 London LHR British Airways 22:40 22:34 Landed
83 SU2468 Moscow SVO Aeroflot 22:55 22:48 Landed
84 FR8398 Nurnberg NUE Ryanair 23:05 22:32 Landed
85 AF1694 Paris CDG Air France 23:55 23:34 Landed
86 W62284 Brussels CRL Wizz Air 23:55 00:30 Delayed
87 AB8260 Berlin TXL Air Berlin 23:55 23:33 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
.. ...
58 Track >
59 Track >
60 Track >
61 Track >
62 Track >
63 Track >
64 Track >
65 Track >
66 Track >
67 Track >
68 Track >
69 Track >
70 Track >
71 Track >
72 Track >
73 Track >
74 Track >
75 Track >
76 Track >
77 Track >
78 Track >
79 Track >
80 Track >
81 Track >
82 Track >
83 Track >
84 Track >
85 Track >
86 Track >
87 Track >
[88 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170319': Flight From Airline Scheduled Arrival Status \
0 LH1342 Frankfurt FRA Lufthansa 00:05 23:58 Landed
1 KL1979 Amsterdam AMS KLM 00:05 23:51 Landed
2 FR8206 Bristol BRS Ryanair 00:15 00:12 Landed
3 LH1682 Munich MUC Lufthansa 00:15 00:09 Landed
4 W62452 Larnaca LCA Wizz Air 00:25 00:57 Delayed
5 FR604 Copenhagen CPH Ryanair 00:45 00:31 Landed
6 W62406 Gothenburg GOT Wizz Air 00:55 01:08 Landed
7 W62390 Malaga AGP Wizz Air 01:20 01:09 Landed
8 W62210 London LTN Wizz Air 01:20 01:38 Delayed
9 W62498 Dubai DWC Wizz Air 01:50 02:45 Delayed
10 QR8231 Doha DOH Qatar Air Cargo 06:25 09:32 Delayed
11 SM631 Hurghada HRG Air Cairo 08:00 07:56 Landed
12 W62474 Kiev IEV Wizz Air 08:50 08:37 Landed
13 FR196 Berlin SXF Ryanair 09:20 08:58 Landed
14 TK1035 Istanbul IST Turkish Airlines 09:20 09:25 Landed
15 AF1394 Paris CDG Air France 10:05 NaN Scheduled
16 DY3550 Copenhagen CPH SmartLynx 10:25 10:13 Landed
17 LY2365 Tel Aviv TLV El Al 10:45 10:58 Landed
18 A3878 Athens ATH Aegean Airlines 10:50 10:57 Landed
19 W62334 Milan MXP Wizz Air 10:50 10:42 Landed
20 DY1550 Oslo OSL Norwegian 11:00 10:51 Landed
21 FR8368 Madrid MAD Ryanair 11:05 10:50 Landed
22 LH1334 Frankfurt FRA Lufthansa 11:05 11:02 Landed
23 FR8418 Rome CIA Ryanair 11:10 11:01 Landed
24 W62292 Dortmund DTM Wizz Air 11:20 11:13 Landed
25 EI672 Dublin DUB Aer Lingus 11:25 10:59 Landed
26 QR199 Doha DOH Qatar Airways 11:25 11:20 Landed
27 OS713 Vienna VIE Austrian Airlines 11:40 NaN Scheduled
28 AY753 Helsinki HEL Finnair 11:50 11:36 Landed
29 W62272 Eindhoven EIN Wizz Air 12:00 12:04 Landed
.. ... ... ... ... ... ...
89 4U6900 Berlin TXL Germanwings 20:00 19:48 Landed
90 W62470 Bucharest OTP Wizz Air 20:00 19:41 Landed
91 LX2258 Zurich ZRH Swiss 20:05 19:52 Landed
92 W62274 Eindhoven EIN Wizz Air 20:20 20:12 Landed
93 RO237 Bucharest OTP Tarom 20:20 20:14 Landed
94 OK788 Prague PRG Czech Airlines 20:20 20:07 Landed
95 FR1242 Athens ATH Ryanair 20:30 20:35 Landed
96 TK1037 Istanbul IST Turkish Airlines 20:30 20:41 Landed
97 TK1037 Istanbul IST Turkish Airlines 20:30 NaN Scheduled
98 FR8394 Barcelona BCN Ryanair 20:35 20:57 Delayed
99 EW1788 Dusseldorf DUS Eurowings 20:45 20:30 Landed
100 D8442 Helsinki HEL Norwegian 21:00 20:45 Landed
101 U24609 Berlin SXF EasyJet 21:05 NaN Scheduled
102 LO531 Warsaw WAW LOT 21:05 20:48 Landed
103 4U788 Cologne CGN Germanwings 21:05 21:19 Landed
104 DY1552 Oslo OSL Norwegian 21:45 21:40 Landed
105 4U2784 Stuttgart STR Germanwings 21:50 21:45 Landed
106 W62208 London LTN Wizz Air 22:00 21:47 Landed
107 FR8371 London STN Ryanair 22:00 21:34 Landed
108 BA870 London LHR British Airways 22:40 22:23 Landed
109 SU2468 Moscow SVO Aeroflot 22:55 22:43 Landed
110 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
111 FR8398 Nurnberg NUE Ryanair 23:05 22:37 Landed
112 SN2829 Brussels BRU Brussels Airlines 23:30 23:25 Landed
113 LY2367 Tel Aviv TLV El Al 23:40 NaN Scheduled
114 W62356 Bologna BLQ Wizz Air 23:50 23:42 Landed
115 AB8260 Berlin TXL Air Berlin 23:55 NaN Scheduled
116 AF1694 Paris CDG Air France 23:55 23:36 Landed
117 W62284 Brussels CRL Wizz Air 23:55 23:40 Landed
118 LH1342 Frankfurt FRA Lufthansa 00:00 23:57 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
.. ...
89 Track >
90 Track >
91 Track >
92 Track >
93 Track >
94 Track >
95 Track >
96 Track >
97 Track >
98 Track >
99 Track >
100 Track >
101 Track >
102 Track >
103 Track >
104 Track >
105 Track >
106 Track >
107 Track >
108 Track >
109 Track >
110 Track >
111 Track >
112 Track >
113 Track >
114 Track >
115 Track >
116 Track >
117 Track >
118 Track >
[119 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170320': Flight From Airline Scheduled Arrival \
0 LH1342 Frankfurt FRA Lufthansa 00:00 23:57
1 KL1979 Amsterdam AMS KLM 00:05 NaN
2 LH1682 Munich MUC Lufthansa 00:15 00:06
3 W62392 Fuerteventura FUE Wizz Air 00:25 00:16
4 W62336 Milan MXP Wizz Air 00:45 00:27
5 FR8358 Manchester MAN Ryanair 00:45 00:39
6 FR604 Copenhagen CPH Ryanair 00:55 00:43
7 FR1023 Dublin DUB Ryanair 00:55 00:36
8 W62372 Madrid MAD Wizz Air 00:55 00:38
9 W62210 London LTN Wizz Air 01:20 01:23
10 W62428 Reykjavik KEF Wizz Air 01:50 03:28
11 W62394 Lisbon LIS Wizz Air 01:55 01:47
12 W62474 Kiev IEV Wizz Air 08:50 08:38
13 W62500 Baku GYD Wizz Air 09:05 09:01
14 B2811 Minsk MSQ Belavia 09:05 08:54
15 EW4990 Stuttgart STR Eurowings 09:10 08:55
16 4U788 Cologne CGN Germanwings 09:20 09:04
17 TK1035 Istanbul IST Turkish Airlines 09:20 09:35
18 LO533 Warsaw WAW LOT 09:25 09:15
19 4U9784 Dusseldorf DUS Germanwings 09:35 09:18
20 FR196 Berlin SXF Ryanair 09:40 09:23
21 OK786 Prague PRG Czech Airlines 09:45 09:19
22 RO231 Bucharest OTP Tarom 09:45 09:48
23 LH1674 Munich MUC Air Dolomiti 09:45 09:21
24 LX2250 Zurich ZRH Swiss 09:50 09:42
25 AF1394 Paris CDG AirExplore 10:05 10:22
26 HV6771 Rotterdam RTM Transavia 10:15 10:00
27 LY2365 Tel Aviv TLV El Al 10:45 11:08
28 W62334 Milan MXP Wizz Air 10:50 10:45
29 A3878 Athens ATH Aegean Airlines 10:50 10:58
.. ... ... ... ... ...
97 W62448 Thessaloniki SKG Wizz Air 19:30 19:40
98 AB8266 Berlin TXL Air Berlin 19:35 19:34
99 CA722 Minsk MSQ Air China 19:40 NaN
100 CA721 Minsk MSQ Air China 19:40 19:38
101 LX2258 Zurich ZRH Swiss 20:05 19:54
102 4U2784 Stuttgart STR Germanwings 20:20 20:12
103 W62274 Eindhoven EIN Wizz Air 20:20 20:18
104 OK788 Prague PRG Czech Airlines 20:20 20:10
105 FR1242 Athens ATH Ryanair 20:30 20:21
106 TK1037 Istanbul IST Turkish Airlines 20:30 20:18
107 FR8394 Barcelona BCN Ryanair 20:35 20:27
108 TO3742 Paris ORY Transavia 20:40 20:18
109 EW1788 Dusseldorf DUS Eurowings 20:45 20:31
110 FR8432 Brussels CRL Ryanair 20:55 20:44
111 LH1680 Munich MUC Lufthansa 21:00 NaN
112 LO531 Warsaw WAW LOT 21:05 20:54
113 OS1473 Vienna VIE Austrian Airlines 21:40 NaN
114 U23311 Venice VCE EasyJet 21:55 21:54
115 W62208 London LTN Wizz Air 22:00 22:45
116 FR8371 London STN Ryanair 22:00 21:46
117 FR8246 Rome CIA Ryanair 22:35 NaN
118 BA870 London LHR British Airways 22:40 22:13
119 SU2468 Moscow SVO Aeroflot 22:55 22:52
120 OS717 Vienna VIE Austrian Airlines 23:00 NaN
121 FR8398 Nurnberg NUE Ryanair 23:05 22:39
122 SN2829 Brussels BRU Brussels Airlines 23:30 23:39
123 W62284 Brussels CRL Wizz Air 23:55 23:52
124 AB8260 Berlin TXL Air Berlin 23:55 00:00
125 AF1694 Paris CDG Air France 23:55 23:41
126 LH1342 Frankfurt FRA Lufthansa 00:00 NaN
Status Unnamed: 6
0 Landed Track >
1 Scheduled Track >
2 Landed Track >
3 Landed Track >
4 Landed Track >
5 Landed Track >
6 Landed Track >
7 Landed Track >
8 Landed Track >
9 Landed Track >
10 Delayed Track >
11 Landed Track >
12 Landed Track >
13 Landed Track >
14 Landed Track >
15 Landed Track >
16 Landed Track >
17 Landed Track >
18 Landed Track >
19 Landed Track >
20 Landed Track >
21 Landed Track >
22 Landed Track >
23 Landed Track >
24 Landed Track >
25 Delayed Track >
26 Landed Track >
27 Delayed Track >
28 Landed Track >
29 Landed Track >
.. ... ...
97 Landed Track >
98 Landed Track >
99 Scheduled Track >
100 Landed Track >
101 Landed Track >
102 Landed Track >
103 Landed Track >
104 Landed Track >
105 Landed Track >
106 Landed Track >
107 Landed Track >
108 Landed Track >
109 Landed Track >
110 Landed Track >
111 Scheduled Track >
112 Landed Track >
113 Scheduled Track >
114 Landed Track >
115 Delayed Track >
116 Landed Track >
117 Scheduled Track >
118 Landed Track >
119 Landed Track >
120 Scheduled Track >
121 Landed Track >
122 Landed Track >
123 Landed Track >
124 Landed Track >
125 Landed Track >
126 Scheduled Track >
[127 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170321': Flight From Airline Scheduled Arrival Status \
0 LH1342 Frankfurt FRA Lufthansa 00:00 NaN Scheduled
1 KL1979 Amsterdam AMS KLM 00:05 NaN Scheduled
2 LH1682 Munich MUC Lufthansa 00:15 00:09 Landed
3 W62264 Nice NCE Wizz Air 00:35 00:45 Landed
4 FR1023 Dublin DUB Ryanair 00:40 00:26 Landed
5 W6906 Lisbon LIS Wizz Air 00:45 01:13 Delayed
6 W62336 Milan MXP Wizz Air 00:45 00:36 Landed
7 FR604 Copenhagen CPH Ryanair 00:45 00:30 Landed
8 W62494 Tenerife TFS Wizz Air 00:55 01:10 Landed
9 W62372 Madrid MAD Wizz Air 01:05 01:17 Landed
10 W62210 London LTN Wizz Air 01:20 01:25 Landed
11 W62394 Lisbon LIS Wizz Air 01:55 01:45 Landed
12 W62248 Kutaisi KUT Wizz Air 07:50 07:28 Landed
13 FR196 Berlin SXF Ryanair 08:40 08:24 Landed
14 TK1035 Istanbul IST Turkish Airlines 09:20 09:13 Landed
15 LO533 Warsaw WAW LOT 09:25 09:25 Landed
16 4U9784 Dusseldorf DUS Germanwings 09:35 09:36 Landed
17 LH1674 Munich MUC Air Dolomiti 09:45 09:40 Landed
18 OK786 Prague PRG Czech Airlines 09:45 09:32 Landed
19 RO231 Bucharest OTP Tarom 09:45 09:47 Landed
20 LX2250 Zurich ZRH Swiss 09:50 09:45 Landed
21 AF1394 Paris CDG Air France 10:05 10:10 Landed
22 HV6771 Rotterdam RTM Transavia 10:15 09:57 Landed
23 LY2365 Tel Aviv TLV El Al 10:45 10:42 Landed
24 W62334 Milan MXP Wizz Air 10:50 10:44 Landed
25 AB8262 Berlin TXL Air Berlin 11:00 10:57 Landed
26 DY3550 Copenhagen CPH Norwegian 11:05 10:59 Landed
27 LH1334 Frankfurt FRA Lufthansa 11:05 11:04 Landed
28 FR8368 Madrid MAD Ryanair 11:05 10:44 Landed
29 FR8418 Rome CIA Ryanair 11:10 11:25 Landed
.. ... ... ... ... ... ...
77 SN2825 Brussels BRU Brussels Airlines 18:00 17:51 Landed
78 W62496 Luqa MLA Wizz Air 18:45 19:08 Delayed
79 W62206 London LTN Wizz Air 19:00 18:59 Landed
80 LH1340 Frankfurt FRA Lufthansa 19:00 18:59 Landed
81 OS721 Vienna VIE Austrian Airlines 19:05 NaN Scheduled
82 AY755 Helsinki HEL Finnair 19:30 19:33 Landed
83 W62300 Hahn HHN Wizz Air 19:35 19:29 Landed
84 AB8266 Berlin TXL Air Berlin 19:35 19:31 Landed
85 W62472 Sofia SOF Wizz Air 20:00 19:50 Landed
86 LX2258 Zurich ZRH Swiss 20:05 20:03 Landed
87 OK788 Prague PRG Czech Airlines 20:20 20:16 Landed
88 RO237 Bucharest OTP Tarom 20:20 20:08 Landed
89 EW4916 Stuttgart STR Eurowings 20:20 20:37 Delayed
90 TK1037 Istanbul IST Turkish Airlines 20:30 20:12 Landed
91 4U9782 Dusseldorf DUS Germanwings 20:45 20:37 Landed
92 HV6773 Rotterdam RTM Transavia 20:55 20:42 Landed
93 LH1680 Munich MUC Lufthansa 21:00 NaN Scheduled
94 LO531 Warsaw WAW LOT 21:05 21:03 Landed
95 D8442 Helsinki HEL Norwegian 21:25 21:20 Landed
96 W62218 Birmingham BHX Wizz Air 22:00 22:03 Landed
97 FR8371 London STN Ryanair 22:00 21:50 Landed
98 BA870 London LHR British Airways 22:40 22:37 Landed
99 SU2468 Moscow SVO Aeroflot 22:55 23:05 Landed
100 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
101 FR8398 Nurnberg NUE Ryanair 23:05 22:43 Landed
102 SN2829 Brussels BRU Brussels Airlines 23:30 23:30 Landed
103 W62284 Brussels CRL Wizz Air 23:55 00:13 Delayed
104 AB8260 Berlin TXL Air Berlin 23:55 00:02 Landed
105 AF1694 Paris CDG Air France 23:55 00:11 Delayed
106 LH1342 Frankfurt FRA Lufthansa 00:00 23:58 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
.. ...
77 Track >
78 Track >
79 Track >
80 Track >
81 Track >
82 Track >
83 Track >
84 Track >
85 Track >
86 Track >
87 Track >
88 Track >
89 Track >
90 Track >
91 Track >
92 Track >
93 Track >
94 Track >
95 Track >
96 Track >
97 Track >
98 Track >
99 Track >
100 Track >
101 Track >
102 Track >
103 Track >
104 Track >
105 Track >
106 Track >
[107 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170322': Flight From Airline Scheduled Arrival Status \
0 LH1342 Frankfurt FRA Lufthansa 00:00 23:58 Landed
1 KL1979 Amsterdam AMS KLM 00:05 00:19 Landed
2 LH1682 Munich MUC Lufthansa 00:15 00:02 Landed
3 FR8358 Manchester MAN Ryanair 00:20 00:34 Landed
4 W62452 Larnaca LCA Wizz Air 00:25 01:21 Delayed
5 FR604 Copenhagen CPH Ryanair 00:45 00:24 Landed
6 FR1023 Dublin DUB Ryanair 00:55 00:53 Landed
7 W62406 Gothenburg GOT Wizz Air 00:55 00:51 Landed
8 W62390 Malaga AGP Wizz Air 01:20 01:15 Landed
9 W62210 London LTN Wizz Air 01:20 01:13 Landed
10 W62498 Dubai DWC Wizz Air 01:50 01:40 Landed
11 TK6391 Kiev KBP ULS Airlines Cargo 06:25 NaN Scheduled
12 W62474 Kiev IEV Wizz Air 08:50 08:41 Landed
13 TK1035 Istanbul IST Turkish Airlines 09:20 09:03 Landed
14 FR196 Berlin SXF Ryanair 09:20 08:57 Landed
15 LO533 Warsaw WAW LOT 09:25 09:21 Landed
16 4U9784 Dusseldorf DUS Germanwings 09:35 09:25 Landed
17 LH1674 Munich MUC Air Dolomiti 09:45 09:38 Landed
18 OK786 Prague PRG Czech Airlines 09:45 09:42 Landed
19 RO231 Bucharest OTP Tarom 09:45 09:25 Landed
20 LX2250 Zurich ZRH Swiss 09:50 09:47 Landed
21 AF1394 Paris CDG Air France 10:05 09:55 Landed
22 LY2365 Tel Aviv TLV El Al 10:45 10:23 Landed
23 W62334 Milan MXP Wizz Air 10:50 10:49 Landed
24 AB8262 Berlin TXL Air Berlin 11:00 10:59 Landed
25 LH1334 Frankfurt FRA Lufthansa 11:05 11:04 Landed
26 FR8368 Madrid MAD Ryanair 11:05 10:42 Landed
27 U27915 Amsterdam AMS EasyJet 11:05 10:34 Landed
28 FR8418 Rome CIA Ryanair 11:10 11:25 Landed
29 W62292 Dortmund DTM Wizz Air 11:20 11:23 Landed
.. ... ... ... ... ... ...
81 CA722 Minsk MSQ Air China 19:40 NaN Scheduled
82 CA721 Minsk MSQ Air China 19:40 19:31 Landed
83 FR2274 Malaga AGP Ryanair 19:45 19:33 Landed
84 W62470 Bucharest OTP Wizz Air 20:00 19:55 Landed
85 LX2258 Zurich ZRH Helvetic Airways 20:05 20:08 Landed
86 4U2784 Stuttgart STR Germanwings 20:20 20:18 Landed
87 OK788 Prague PRG Czech Airlines 20:20 20:27 Landed
88 W62274 Eindhoven EIN Wizz Air 20:25 20:14 Landed
89 FR1242 Athens ATH Ryanair 20:30 20:20 Landed
90 TK1037 Istanbul IST Turkish Airlines 20:30 20:00 Landed
91 FR8394 Barcelona BCN Ryanair 20:35 20:22 Landed
92 TO3742 Paris ORY Transavia 20:40 20:20 Landed
93 EW1788 Dusseldorf DUS Eurowings 20:45 20:44 Landed
94 FR2621 Eilat VDA Ryanair 20:50 21:01 Landed
95 FR1023 Dublin DUB Ryanair 21:00 20:48 Landed
96 LH1680 Munich MUC Lufthansa 21:00 NaN Scheduled
97 4U788 Cologne CGN Germanwings 21:05 20:57 Landed
98 LO531 Warsaw WAW LOT 21:05 NaN Scheduled
99 FR8371 London STN Ryanair 22:00 22:01 Landed
100 CV7333 Hong Kong HKG Cargolux 22:30 NaN Scheduled
101 RO237 Bucharest OTP Tarom 22:40 22:24 Landed
102 BA870 London LHR British Airways 22:40 22:43 Landed
103 SU2468 Moscow SVO Aeroflot 22:55 23:00 Landed
104 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
105 FR8398 Nurnberg NUE Ryanair 23:05 23:05 Landed
106 SN2829 Brussels BRU Brussels Airlines 23:30 23:28 Landed
107 W62356 Bologna BLQ Wizz Air 23:50 23:47 Landed
108 W62284 Brussels CRL Wizz Air 23:55 23:47 Landed
109 AB8260 Berlin TXL Air Berlin 23:55 23:54 Landed
110 AF1694 Paris CDG Air France 23:55 23:54 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
.. ...
81 Track >
82 Track >
83 Track >
84 Track >
85 Track >
86 Track >
87 Track >
88 Track >
89 Track >
90 Track >
91 Track >
92 Track >
93 Track >
94 Track >
95 Track >
96 Track >
97 Track >
98 Track >
99 Track >
100 Track >
101 Track >
102 Track >
103 Track >
104 Track >
105 Track >
106 Track >
107 Track >
108 Track >
109 Track >
110 Track >
[111 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170323': Flight From Airline Scheduled Arrival Status \
0 LH1342 Frankfurt FRA Lufthansa 00:05 00:04 Landed
1 KL1979 Amsterdam AMS KLM 00:05 00:17 Landed
2 LH1682 Munich MUC Lufthansa 00:15 00:06 Landed
3 W62400 Lanzarote ACE Wizz Air 00:15 23:54 Landed
4 FR604 Copenhagen CPH Ryanair 00:45 00:41 Landed
5 FR8414 Paris BVA Ryanair 00:45 00:32 Landed
6 W62336 Milan MXP Wizz Air 00:50 00:36 Landed
7 W62372 Madrid MAD Wizz Air 01:05 01:21 Delayed
8 W62210 London LTN Wizz Air 01:20 01:17 Landed
9 W62428 Reykjavik KEF Wizz Air 01:50 01:34 Landed
10 W62394 Lisbon LIS Wizz Air 01:55 02:00 Landed
11 TK1035 Istanbul IST Turkish Airlines 09:20 09:13 Landed
12 FR196 Berlin SXF Ryanair 09:20 09:08 Landed
13 LO533 Warsaw WAW LOT 09:25 09:30 Landed
14 RO231 Bucharest OTP Tarom 09:45 09:45 Landed
15 OK786 Prague PRG Czech Airlines 09:45 09:42 Landed
16 LH1674 Munich MUC Air Dolomiti 09:45 09:40 Landed
17 LX2250 Zurich ZRH Swiss 09:50 09:47 Landed
18 AF1394 Paris CDG Air France 10:05 10:14 Landed
19 HV6771 Rotterdam RTM Transavia 10:15 10:14 Landed
20 U24609 Berlin SXF EasyJet 10:25 10:08 Landed
21 U24345 Lyon LYS EasyJet 10:35 10:01 Landed
22 LY2365 Tel Aviv TLV El Al 10:45 10:40 Landed
23 W62334 Milan MXP Wizz Air 10:50 10:59 Landed
24 AB8262 Berlin TXL Air Berlin 11:00 10:59 Landed
25 DY3550 Copenhagen CPH Norwegian 11:05 11:08 Landed
26 FR8368 Madrid MAD Ryanair 11:05 10:44 Landed
27 LH1334 Frankfurt FRA Lufthansa 11:05 11:04 Landed
28 FR8418 Rome CIA Ryanair 11:10 11:03 Landed
29 W62292 Dortmund DTM Wizz Air 11:20 11:38 Delayed
.. ... ... ... ... ... ...
80 QR201 Doha DOH Qatar Airways 18:10 17:51 Landed
81 W62496 Luqa MLA Wizz Air 18:45 18:49 Landed
82 LH1340 Frankfurt FRA Lufthansa 19:00 18:57 Landed
83 W62206 London LTN Wizz Air 19:00 18:51 Landed
84 OS721 Vienna VIE Austrian Airlines 19:05 NaN Scheduled
85 AY755 Helsinki HEL Finnair 19:30 19:33 Landed
86 AB8266 Berlin TXL Air Berlin 19:35 19:44 Landed
87 LX2258 Zurich ZRH Swiss 20:05 NaN Scheduled
88 OK788 Prague PRG Czech Airlines 20:20 20:18 Landed
89 TK6387 Kiev KBP Turkish Airlines 20:20 NaN Scheduled
90 RO237 Bucharest OTP Tarom 20:20 20:12 Landed
91 TK1037 Istanbul IST Turkish Airlines 20:30 20:12 Landed
92 EW1788 Dusseldorf DUS Eurowings 20:45 20:59 Landed
93 FR8432 Brussels CRL Ryanair 20:55 20:37 Landed
94 LH1680 Munich MUC Lufthansa 21:00 20:52 Landed
95 LO531 Warsaw WAW LOT 21:05 21:03 Landed
96 D8442 Helsinki HEL Norwegian 21:25 21:26 Landed
97 4U2784 Stuttgart STR Germanwings 21:50 21:50 Landed
98 FR8371 London STN Ryanair 22:00 21:48 Landed
99 W62208 London LTN Wizz Air 22:00 22:01 Landed
100 BA870 London LHR British Airways 22:40 22:56 Delayed
101 SU2468 Moscow SVO Aeroflot 22:55 23:07 Landed
102 OS717 Vienna VIE Austrian Airlines 23:00 NaN Scheduled
103 FR8398 Nurnberg NUE Ryanair 23:05 22:52 Landed
104 SN2829 Brussels BRU Brussels Airlines 23:30 23:32 Landed
105 LY2367 Tel Aviv TLV El Al 23:40 NaN Scheduled
106 W62284 Brussels CRL Wizz Air 23:55 00:15 Delayed
107 AF1694 Paris CDG Air France 23:55 00:02 Landed
108 AB8260 Berlin TXL Air Berlin 23:55 00:06 Landed
109 LH1342 Frankfurt FRA Lufthansa 00:00 00:00 Landed
Unnamed: 6
0 Track >
1 Track >
2 Track >
3 Track >
4 Track >
5 Track >
6 Track >
7 Track >
8 Track >
9 Track >
10 Track >
11 Track >
12 Track >
13 Track >
14 Track >
15 Track >
16 Track >
17 Track >
18 Track >
19 Track >
20 Track >
21 Track >
22 Track >
23 Track >
24 Track >
25 Track >
26 Track >
27 Track >
28 Track >
29 Track >
.. ...
80 Track >
81 Track >
82 Track >
83 Track >
84 Track >
85 Track >
86 Track >
87 Track >
88 Track >
89 Track >
90 Track >
91 Track >
92 Track >
93 Track >
94 Track >
95 Track >
96 Track >
97 Track >
98 Track >
99 Track >
100 Track >
101 Track >
102 Track >
103 Track >
104 Track >
105 Track >
106 Track >
107 Track >
108 Track >
109 Track >
[110 rows x 7 columns],
u'https://www.airportia.com//hungary/budapest-liszt-ferenc-international-airport/arrivals/20170324': Flight From Airline Scheduled Arrival \
0 LH1342 Frankfurt FRA Lufthansa 00:00 00:00
1 KL1979 Amsterdam AMS KLM 00:05 00:19
2 LY2367 Tel Aviv TLV El Al 00:10 23:59
3 LH1682 Munich MUC Lufthansa 00:15 00:12
4 FR8358 Manchester MAN Ryanair 00:20 00:32
5 FR604 Copenhagen CPH Ryanair 00:50 00:43
6 FR1023 Dublin DUB Ryanair 00:55 00:49
7 W62406 Gothenburg GOT Wizz Air 00:55 00:53
8 W62210 London LTN Wizz Air 01:20 01:15
9 W62498 Dubai DWC Wizz Air 01:50 03:04
10 TK6387 Kiev KBP ULS Airlines Cargo 06:55 06:41
11 W62474 Kiev IEV Wizz Air 08:50 08:41
12 TK1035 Istanbul IST Turkish Airlines 09:20 08:56
13 LO533 Warsaw WAW LOT 09:25 09:21
14 4U9784 Dusseldorf DUS Germanwings 09:35 09:38
15 LH1674 Munich MUC Air Dolomiti 09:45 09:40
16 OK786 Prague PRG Czech Airlines 09:45 09:25
17 LX2250 Zurich ZRH Swiss 09:50 09:40
18 AF1394 Paris CDG Air France 10:05 NaN
19 HV6771 Rotterdam RTM Transavia 10:15 10:12
20 U24609 Berlin SXF EasyJet 10:25 10:17
21 FR196 Berlin SXF Ryanair 10:35 10:19
22 LY2365 Tel Aviv TLV Israir Airlines 10:45 10:49
23 A3878 Athens ATH Aegean Airlines 10:50 10:55
24 W62334 Milan MXP Wizz Air 10:50 11:06
25 AB8262 Berlin TXL Air Berlin 11:00 11:04
26 LH1334 Frankfurt FRA Lufthansa 11:05 11:06
27 U27915 Amsterdam AMS EasyJet 11:05 10:59
28 FR8418 Rome CIA Ryanair 11:10 10:51
29 W62292 Dortmund DTM Wizz Air 11:20 11:27
.. ... ... ... ... ...
94 CA721 Minsk MSQ Air China 19:40 19:36
95 CA722 Minsk MSQ Air China 19:40 NaN
96 W62470 Bucharest OTP Wizz Air 20:00 19:59
97 LX2258 Zurich ZRH Swiss 20:05 20:05
98 OK788 Prague PRG Czech Airlines 20:20 20:37
99 RO237 Bucharest OTP Tarom 20:20 20:12
100 W62274 Eindhoven EIN Wizz Air 20:25 20:31
101 FR1242 Athens ATH Ryanair 20:30 20:18
102 TK1037 Istanbul IST Turkish Airlines 20:30 20:18
103 FR8394 Barcelona BCN Ryanair 20:35 20:48
104 TO3742 Paris ORY Transavia 20:40 20:35
105 EW9782 Dusseldorf DUS Eurowings 20:45 20:44
106 LH1680 Munich MUC Lufthansa 21:00 NaN
107 4U788 Cologne CGN Germanwings 21:05 21:14
108 LO531 Warsaw WAW LOT 21:05 21:01
109 DY1552 Oslo OSL Norwegian 21:45 21:44
110 4U2784 Stuttgart STR Germanwings 21:50 NaN
111 FR8371 London STN Ryanair 22:00 22:09
112 W62208 London LTN Wizz Air 22:00 22:13
113 FR8246 Rome CIA Ryanair 22:35 22:35
114 W62448 Thessaloniki SKG Wizz Air 22:40 22:33
115 BA870 London LHR British Airways 22:40 22:52
116 SU2468 Moscow SVO Aeroflot 22:55 23:32
117 OS717 Vienna VIE Austrian Airlines 23:00 NaN
118 FR8398 Nurnberg NUE Ryanair 23:05 22:48
119 SN2829 Brussels BRU Brussels Airlines 23:30 23:39
120 AB8260 Berlin TXL Air Berlin 23:55 23:54
121 AF1694 Paris CDG Air France 23:55 00:02
122 W62284 Brussels CRL Wizz Air 23:55 00:00
123 LH1342 Frankfurt FRA Lufthansa 00:00 23:56
Status Unnamed: 6
0 Landed Track >
1 Landed Track >
2 Landed Track >
3 Landed Track >
4 Landed Track >
5 Landed Track >
6 Landed Track >
7 Landed Track >
8 Landed Track >
9 Delayed Track >
10 Landed Track >
11 Landed Track >
12 Landed Track >
13 Landed Track >
14 Landed Track >
15 Landed Track >
16 Landed Track >
17 Landed Track >
18 Scheduled Track >
19 Landed Track >
20 Landed Track >
21 Landed Track >
22 Landed Track >
23 Landed Track >
24 Delayed Track >
25 Landed Track >
26 Landed Track >
27 Landed Track >
28 Landed Track >
29 Landed Track >
.. ... ...
94 Landed Track >
95 Scheduled Track >
96 Landed Track >
97 Landed Track >
98 Delayed Track >
99 Landed Track >
100 Landed Track >
101 Landed Track >
102 Landed Track >
103 Landed Track >
104 Landed Track >
105 Landed Track >
106 Scheduled Track >
107 Landed Track >
108 Landed Track >
109 Landed Track >
110 Scheduled Track >
111 Landed Track >
112 Landed Track >
113 Landed Track >
114 Landed Track >
115 Landed Track >
116 Delayed Track >
117 Scheduled Track >
118 Landed Track >
119 Landed Track >
120 Landed Track >
121 Landed Track >
122 Landed Track >
123 Landed Track >
[124 rows x 7 columns]},
u'DEB': {u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170311': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67854 London LTN Wizz Air 00:55 00:36 Landed Track >
1 W67852 London LTN Wizz Air 13:25 13:20 Landed Track >
2 W67862 Eindhoven EIN Wizz Air 19:10 18:55 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170312': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67874 Milan BGY Wizz Air 18:10 18:02 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170313': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67854 London LTN Wizz Air 00:55 00:49 Landed Track >
1 LH1686 Munich MUC Lufthansa 13:35 13:44 Landed Track >
2 W67868 Paris BVA Wizz Air 13:55 13:46 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170314': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67854 London LTN Wizz Air 00:55 00:43 Landed Track >
1 W67852 London LTN Wizz Air 13:25 13:35 Landed Track >
2 W67862 Eindhoven EIN Wizz Air 19:10 19:01 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170315': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 LH1686 Munich MUC Lufthansa 13:35 13:26 Landed Track >
1 W67874 Milan BGY Wizz Air 18:10 18:08 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170316': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67854 London LTN Wizz Air 00:55 00:40 Landed Track >
1 W67852 London LTN Wizz Air 13:25 13:36 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170317': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 LH1686 Munich MUC Lufthansa 13:35 13:17 Landed Track >
1 W67868 Paris BVA Wizz Air 13:55 13:30 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170318': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67854 London LTN Wizz Air 00:55 00:38 Landed Track >
1 W67852 London LTN Wizz Air 13:25 13:13 Landed Track >
2 W67862 Eindhoven EIN Wizz Air 19:10 18:34 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170319': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67874 Milan BGY Wizz Air 18:10 17:59 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170320': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67854 London LTN Wizz Air 00:55 00:34 Landed Track >
1 LH1686 Munich MUC Lufthansa 13:35 13:14 Landed Track >
2 W67868 Paris BVA Wizz Air 13:55 13:26 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170321': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67854 London LTN Wizz Air 00:55 00:36 Landed Track >
1 W67852 London LTN Wizz Air 13:25 13:05 Landed Track >
2 W67862 Eindhoven EIN Wizz Air 19:10 18:55 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170322': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 LH1686 Munich MUC Lufthansa 13:35 13:20 Landed Track >
1 W67874 Milan BGY Wizz Air 18:10 18:08 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170323': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 W67854 London LTN Wizz Air 00:55 00:36 Landed Track >
1 W67852 London LTN Wizz Air 13:25 13:12 Landed Track >,
u'https://www.airportia.com//hungary/debrecen-international-airport/arrivals/20170324': Flight From Airline Scheduled Arrival Status Unnamed: 6
0 LH1686 Munich MUC Lufthansa 13:35 13:37 Landed Track >
1 W67868 Paris BVA Wizz Air 13:55 13:44 Landed Track >},
u'MCQ': {},
u'PEV': {},
u'QGY': {},
u'QZD': {},
u'SOB': {}}}
for c in AP: print c airportialinks=AP[c] sch={} for i in airportialinks: print i, if i not in sch:sch[i]={}
#march 4-31 = 4 weeks
for d in range (4,32):
if d not in sch[i]:
try:
#capture token
url=baseurl+airportialinks[i]+'arrivals/201703'+str(d)
s = requests.Session()
cookiesopen = s.get(url)
cookies=str(s.cookies)
fcookies=[[k[:k.find('=')],k[k.find('=')+1:k.find(' for ')]] for k in cookies[cookies.find('Cookie '):].split('Cookie ')[1:]]
#push token
opener = urllib2.build_opener()
for k in fcookies:
opener.addheaders.append(('Cookie', k[0]+'='+k[1]))
#read html
m=s.get(url).content
sch[i][url]=pd.read_html(m)[0]
except: pass #print 'no tables',i,d
print
SC[c]=sch
In [42]:
mdf=pd.DataFrame()
In [43]:
for i in sch:
for d in sch[i]:
df=sch[i][d].drop(sch[i][d].columns[3:],axis=1).drop(sch[i][d].columns[0],axis=1)
df['To']=i
df['Date']=d
mdf=pd.concat([mdf,df])
In [44]:
mdf=mdf.replace('Hahn','Frankfurt')
mdf=mdf.replace('Hahn HHN','Frankfurt HHN')
In [45]:
mdf['City']=[i[:i.rfind(' ')] for i in mdf['From']]
mdf['Airport']=[i[i.rfind(' ')+1:] for i in mdf['From']]
In [46]:
file("mdf_ae_arrv.json",'w').write(json.dumps(mdf.reset_index().to_json()))
In [47]:
len(mdf)
Out[47]:
12955
In [48]:
airlines=set(mdf['Airline'])
In [49]:
cities=set(mdf['City'])
In [50]:
file("cities_ae_arrv.json",'w').write(json.dumps(list(cities)))
file("airlines_ae_arrv.json",'w').write(json.dumps(list(airlines)))
In [51]:
citycoords={}
In [53]:
for i in cities:
if i not in citycoords:
if i==u'Birmingham': z='Birmingham, UK'
elif i==u'Valencia': z='Valencia, Spain'
elif i==u'Naples': z='Naples, Italy'
elif i==u'St. Petersburg': z='St. Petersburg, Russia'
elif i==u'Bristol': z='Bristol, UK'
elif i==u'Victoria': z='Victoria, Seychelles'
elif i==u'Washington': z='Washington, DC'
elif i==u'Odessa': z='Odessa, Ukraine'
else: z=i
citycoords[i]=Geocoder(apik).geocode(z)
print i
Basel
Bratislava
Mineralnye Vody
Johannesburg
Liege
Perth
Hargeisa
San Francisco
Beirut
Jizan
Bahrain
Zaragoza
Bushehr
Chennai
Abu Dhabi
Delhi
Tyumen
Victoria
Baghdad
Mangalore
Newcastle
Catania
Chandigarh
Brussels
Ahmedabad
Jeddah
Varanasi
Dubai
Addis Ababa
Kigali
Chittagong
Sulaimaniyah
Dublin
Nagpur
Phnom Penh
Rome
Accra
Denpasar
Kunming
Mogadishu
Taipei
Ostrava
Alexandria
Casablanca
Qeshm Island
Brisbane
Cairo
Osaka
Washington
Bandar Abbas
Milan
London
Sialkot
Seattle
Abadan
Rostov-on-Don
Cochin
Shiraz
Yangon
Auckland
Angeles City
Dakar
Kish Island
Cluj-Napoca
Damascus
Amritsar
Sydney
Amman
Kolkata
Yekaterinburg
Basra
Multan
Edinburgh
Sao Paulo
Zanzibar
Seoul
Stockholm
Singapore
Moscow
Rahim Yar Khan
Assiut
Kuala Lumpur
Riyan
Berlin
Katowice
Los Angeles
Tiruchirapalli
Tehran
Manchester
Bangalore
Astana
Sana'a
Sohag
Karachi
Kuwait City
Lucknow
Fort Lauderdale
Asmara
Rabat
Cape Town
Stuttgart
Dammam
Bologna
Hambantota
Kathmandu
Al Ain
Male
Frankfurt
Hyderabad
Sylhet
Ashgabat
Zurich
Madrid
Baku
Bangor
Novosibirsk
Adelaide
Lyon
Abha
Istanbul
Dallas
Hofuf
Hanoi
Mashhad
Luxembourg
Manila
Lahore
Vienna
Muscat
Nice
Juba
Brunei
St. Petersburg
Luanda
Skopje
Durban
Jaipur
Khartoum
Medina
Salalah
Ra'sal-Khaymah
Larnaca
Quetta
Ahvaz
Faisalabad
Mombasa
Bishkek
Hong Kong
Toronto
Kandahar
Algiers
Hannover
Kazan
Tokyo
Islamabad
Rio de Janeiro
Hamburg
Orlando
Athens
Tabuk
Bosaso
Wuhan
Tunis
Ha'il
Sharjah
Sayun
Aden
Isfahan
Nairobi
Yerevan
Bucharest
Beijing
Madurai
Najaf
Doha
Memphis
Kozhikode
Djibouti
New York
Birmingham
Boston
Taif
Venice
Mumbai
Shanghai
Goa
Pune
Entebbe
Kabul
Ho Chi Minh City
Al-Qassim
Tashkent
Turbat
Lamerd
Glasgow
Chabahar
Odessa
Benghazi
Phuket
Geneva
Helsinki
Dushanbe
Munich
Bangkok
Krasnodar
Yinchuan
Colombo
Peshawar
Zahedan
Lar
Chongqing
Dhaka
Budapest
Dar-es-Salaam
Coimbatore
Jakarta
Dusseldorf
Barcelona
Urumqi
Melbourne
Minsk
Sarajevo
Almaty
Tbilisi
Port Louis
Houston
Chengdu
Belgrade
Riyadh
Prague
Sofia
Thiruvananthapuram
Samara
Lagos
Chicago
Lisbon
Amsterdam
Copenhagen
Lusaka
Sakaka
Warsaw
In [54]:
citysave={}
for i in citycoords:
citysave[i]={"coords":citycoords[i][0].coordinates,
"country":citycoords[i][0].country}
In [55]:
file("citysave_ae_arrv.json",'w').write(json.dumps(citysave))
Content source: csaladenes/aviation
Similar notebooks: