Skip to content

Instantly share code, notes, and snippets.

@rohitrajiit
Created June 2, 2020 09:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save rohitrajiit/f34ae77fb66390d2b06a36c536e908ff to your computer and use it in GitHub Desktop.
Save rohitrajiit/f34ae77fb66390d2b06a36c536e908ff to your computer and use it in GitHub Desktop.
districts_daily = requests.get('https://api.covid19india.org/districts_daily.json')
districts_daily = districts_daily.text
districts_daily = json.loads(districts_daily)
states = []; districts = []; dates = []; active = []; confirmed = []
deceased = []; recovered = []
for state in districts_daily["districtsDaily"]:
for district in districts_daily["districtsDaily"][state]:
for day in districts_daily["districtsDaily"][state][district]:
states.append(state)
districts.append(district)
dates.append(day['date'])
active.append(day['active'])
confirmed.append(day['confirmed'])
deceased.append(day['deceased'])
recovered.append(day['recovered'])
df = pandas.DataFrame({'state': states, 'district': districts, 'active': active, 'confirmed': confirmed,
'recovered': recovered, 'deceased': deceased, 'date': dates})
df['date'] = pandas.to_datetime(df['date'], format = '%Y-%m-%d')
df['active'] = df['active'].astype(int)
df['recovered'] = df['recovered'].astype(int)
df['deceased'] = df['deceased'].astype(int)
df['confirmed'] = df['confirmed'].astype(int)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment