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)