Creates a list of cities in JSON

csv2json_cities.py

# file URL: https://raw.githubusercontent.com/gsscoder/test-data/master/largest-cities.csv

import csv
import re

cities = []

with open('largest-cities.csv') as f:
    reader = csv.DictReader(f, delimiter=',')
    for row in reader:
        city = re.sub(r'(\().+?(\))', '', row['City'])
        cities.append(f'"{city}"') 

json = f'[\n{",".join(cities)}\n]'
json = json.replace(',', ',\n')

print(json)