Loading Parking Violation Data and cleaning operations


In [7]:
import glob
import json
import pandas as pd
import requests

In [2]:
pd.set_option('display.max_columns', 500)

In [3]:
with open('dc_parking_violations.json', 'r') as f:
    parking_violations = json.load(f)

In [ ]:
for fullname, csv in parking_violations.items():
    download_file = csv + '.csv'
    local_filename = '_'.join(name.lower() for name in fullname.split() ) + '.csv'
    r = requests.get(download_file)
    with open(local_filename, 'wb') as f:
            f.write(r.content)

In [ ]: