process.py 369 B

123456789101112131415161718
  1. #!/usr/bin/env python3
  2. import sys
  3. import csv
  4. """
  5. Strip unneeded data from world cities database.
  6. https://simplemaps.com/data/world-cities
  7. """
  8. with open(sys.argv[2], "w") as outfile:
  9. with open(sys.argv[1]) as infile:
  10. reader = csv.reader(infile, quotechar='"')
  11. next(reader) # skip header
  12. for row in reader:
  13. outfile.write(f"{row[2]}, {row[3]}\n")