Advertisement
Guest User

Untitled

a guest
Jan 29th, 2020
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.89 KB | None | 0 0
  1. import csv
  2.  
  3. cities = {}
  4.  
  5. with open('votes.csv', 'r') as file:
  6. reader = csv.reader(file)
  7. for row in reader:
  8. cities[row[0]] = {'City': '', 'lat': 0, 'long': 0}
  9. cities[row[1]] = {'City': '', 'lat': 0, 'long': 0}
  10.  
  11. with open('votes.csv', 'r') as file:
  12. reader = csv.reader(file)
  13. firstline = True
  14. for row in reader:
  15. if firstline:
  16. firstline = False
  17. continue
  18. leftlat = float(row[3])
  19. leftlong = float(row[4])
  20. rightlat = float(row[5])
  21. rightlong = float(row[6])
  22. if 60.228293 > leftlat > 60.144769 and 25.016669 > leftlong > 24.850740:
  23. cities[row[0]]['City'] = 'Helsinki'
  24. if 60.228293 > rightlat > 60.144769 and 25.016669 > rightlong > 24.850740:
  25. cities[row[1]]['City'] = 'Helsinki'
  26.  
  27. if 52.533404 > leftlat > 52.280065 and 5.071082 > leftlong > 4.711522:
  28. cities[row[0]]['City'] = 'Amsterdam'
  29. if 52.533404 > rightlat > 52.280065 and 5.071082 > rightlong > 4.711522:
  30. cities[row[1]]['City'] = 'Amsterdam'
  31.  
  32. if -22.73458 > leftlat > -23.100097 and 43.791765 > leftlong > 43.092451:
  33. cities[row[0]]['City'] = 'Rio_de_Janeiro'
  34. if -22.73458 > rightlat > -23.100097 and 43.791765 > rightlong > 43.092451:
  35. cities[row[1]]['City'] = 'Rio_de_Janeiro'
  36.  
  37. if 40.505653 > leftlat > 40.347361 and -3.546771 > leftlong > -3.796967:
  38. cities[row[0]]['City'] = 'Madrid'
  39. if 40.505653 > rightlat > 40.347361 and -3.546771 > rightlong > -3.796967:
  40. cities[row[1]]['City'] = 'Madrid'
  41.  
  42. if 33.887244 > leftlat > 33.651724 and -84.321082 > leftlong > -84.546420:
  43. cities[row[0]]['City'] = 'Madrid'
  44. if 33.887244 > rightlat > 33.651724 and -84.321082 > rightlong > -84.546420:
  45. cities[row[1]]['City'] = 'Madrid'
  46.  
  47.  
  48.  
  49.  
  50.  
  51. print(len(cities))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement