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))