Add conversion script

1 files changed, 28 insertions, 0 deletions

diff --git a/data.py b/data.py
new file mode 100644
index 0000000..0f77552
--- /dev/null
+++ b/data.py
@@ -0,0 +1,28 @@
+import csv
+import json
+import requests
+
+from pprint import pprint
+
+def fetch_geocodes(cities):
+    d = {}
+    url = 'http://maps.googleapis.com/maps/api/geocode/json'
+    for city in cities:
+        print 'fetching ' + city
+        res = requests.get(url, params={
+            'address': city,
+            'sensor': 'false'
+        })
+        city = unicode(city.decode('utf8')).encode('utf8')
+        d[city] = json.loads(res.content, encoding='utf8')
+    return d
+
+with open('data.csv', 'r') as f:
+    c = csv.reader(f, delimiter=',', quotechar='"')
+    data = [x for x in c]
+    parties = data[0][1:]
+    cities = map(lambda x: x[0], data)
+    city_data = fetch_geocodes(cities)
+    print city_data
+    with open('data.json', 'w') as out:
+        json.dump(city_data, out, indent=4, ensure_ascii=False)