processing location tree

gistfile1.txt

import csv

with open("locations.csv","w") as csvfile:
    cw = csv.writer(csvfile)
    cw.writerow(["country","city","region1","location1","location2","location3"])
    with open("Location_Tree.csv","r") as infile:
        for l in infile:
            cw.writerow(map(lambda x: x.strip().replace('"',''),l.split('~')))