Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- cities = {}
- with open('votes.csv', 'r') as file:
- reader = csv.reader(file)
- for row in reader:
- cities[row[0]] = {'City': '', 'lat': 0, 'long': 0}
- cities[row[1]] = {'City': '', 'lat': 0, 'long': 0}
- with open('votes.csv', 'r') as file:
- reader = csv.reader(file)
- firstline = True
- for row in reader:
- if firstline:
- firstline = False
- continue
- leftlat = float(row[3])
- leftlong = float(row[4])
- rightlat = float(row[5])
- rightlong = float(row[6])
- if 60.228293 > leftlat > 60.144769 and 25.016669 > leftlong > 24.850740:
- cities[row[0]]['City'] = 'Helsinki'
- if 60.228293 > rightlat > 60.144769 and 25.016669 > rightlong > 24.850740:
- cities[row[1]]['City'] = 'Helsinki'
- if 52.533404 > leftlat > 52.280065 and 5.071082 > leftlong > 4.711522:
- cities[row[0]]['City'] = 'Amsterdam'
- if 52.533404 > rightlat > 52.280065 and 5.071082 > rightlong > 4.711522:
- cities[row[1]]['City'] = 'Amsterdam'
- if -22.73458 > leftlat > -23.100097 and 43.791765 > leftlong > 43.092451:
- cities[row[0]]['City'] = 'Rio_de_Janeiro'
- if -22.73458 > rightlat > -23.100097 and 43.791765 > rightlong > 43.092451:
- cities[row[1]]['City'] = 'Rio_de_Janeiro'
- if 40.505653 > leftlat > 40.347361 and -3.546771 > leftlong > -3.796967:
- cities[row[0]]['City'] = 'Madrid'
- if 40.505653 > rightlat > 40.347361 and -3.546771 > rightlong > -3.796967:
- cities[row[1]]['City'] = 'Madrid'
- if 33.887244 > leftlat > 33.651724 and -84.321082 > leftlong > -84.546420:
- cities[row[0]]['City'] = 'Madrid'
- if 33.887244 > rightlat > 33.651724 and -84.321082 > rightlong > -84.546420:
- cities[row[1]]['City'] = 'Madrid'
- print(len(cities))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement