Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- file = open('../Data/turkiye_ilceler_12042017.csv')
- Read = csv.reader(file)
- Data = list(Read)
- sql = open('../Data/CityDistrict.sql', 'w')
- for Read in Data:
- for i in range(1, 970):
- x = '''INSERT INTO "District" ("Province_id", "District") VALUES (%s, '%s');\n''' % (Data[i][2], Data[i][1])
- sql.write(x)
- sql.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement