'datetimestatus' : datetimestatus, } #ndx = [airport[0]] from pandas import DataFrame gatwdata = DataFrame( data, columns=['direction','scheduled','location','airline','flightno','status','datetimestatus'], #index=ndx, ) def stripletters(str): from string import digits return str.translate(None, digits) gatwdata.airline = gatwdata.airline.map(stripletters) gatwdata.airline = gatwdata.airline.map(airline_mapping) # 'BAGS DELIVERED', # 'CANCELLED', # '', # 'BAGGAGE IN HALL', # 'ESTIMATED 14:44', # 'EXPECTED 14:29', # 'DEPARTED 08:21', # 'SCHEDULED', # 'DELAYED 11:30', # 'DUE Monday 23:37', # 'LANDED 21:44', # 'BOARDING', # 'GATE OPEN', # 'TAXIED 19:59',