Skip to content

Instantly share code, notes, and snippets.

@dvbportal

dvbportal/csv2json.py

Created January 22, 2014 18:50
Show Gist options
  • Save dvbportal/8564846 to your computer and use it in GitHub Desktop.
Save dvbportal/8564846 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. dvbportal created this gist Jan 22, 2014.
    20 changes: 20 additions & 0 deletions csv2json.py
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,20 @@
    import csv
    import json

    csvfile = open('DE.txt', 'r')
    jsonfile = open('de.json', 'w')

    fieldnames = ("countryCode","postalCode","placeName","adminName1","adminCode1","adminName2","adminCode2","adminName3","adminCode3","latitude","longitude","accuracy")
    reader = csv.DictReader(csvfile, fieldnames, delimiter='\t')
    jsonfile.write("{ \"docs\": [")

    for row in reader:
    lat = row["latitude"]
    lon = row["longitude"]
    row.pop("latitude")
    row.pop("longitude")
    row["loc"] = [float(lon), float(lat)]
    json.dump(row, jsonfile)
    jsonfile.write(",\n")

    jsonfile.write("]}")