def queryfreebase(query,url=FREEBASE_URL,api=apiKey):
import Freebase
# setup
q = Freebase.freebase(url,api)
# run query
rt = q.mqlread(query)
return (rt)
def __init__(self):
self.logger = logging.getLogger('CategoryTagger')
self.base = Freebase.Freebase()
#!/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' })
