Buy Me a Coffee? Your support is much appreciated!



Source Code

from collections import namedtuple
import requests
import pandas as pd # pip install pandas

url = 'https://gist.githubusercontent.com/ahmu83/38865147cf3727d221941a2ef8c22a77/raw/c647f74643c0b3f8407c28ddbb599e9f594365ca/US_States_and_Cities.json'
StateCity = namedtuple('StateCity', ('state', 'city'))

try:
    response = requests.get(url)
    data = response.json()

    results = []
    for state in data.keys():
        for city in data[state]:
            results.append(StateCity(state, city))
    
    df = pd.DataFrame(results)
    df.to_csv('state city.csv', index=False)
                
except Exception as e:
    print(e)