def queryfreebase(query,url=FREEBASE_URL,api=apiKey): import Freebase # setup q = Freebase.freebase(url,api) # run query rt = q.mqlread(query) return (rt)
#!/usr/bin/env python # This script cleanses two kinds of csv files import Freebase url = 'https://www.googleapis.com/freebase/v1/mqlread' api = '~/Documents/keys/.freebase_api_key' q = Freebase.freebase(url,api) # query = [{'limit': 13000, 'name': None, 'type': '/aviation/airport', 'iata':[]}] # js = q.mqlread(query) # js = [row for row in js['result'] if row['iata']] # airport = DataFrame(js) # airport.iata = [each[0] for each in airport.iata] # del airport['type'] query =[{ "limit": 13000, "icao_airline_designator": None, "type": "/aviation/airline", "iata_airline_designator": None, "name": None }] js = q.mqlread(query) js = [row for row in js['result'] if row['iata_airline_designator']] # airline = DataFrame(js) # del airline['type'] airline_mapping = {row['iata_airline_designator']:row['name'] for row in js} airline_mapping.update({ u'EZY' : u'Easyjet' })