geojsondata.py

active = []
confirmed = []
deaths = []
deltaconfirmed = []
deltadeaths = []
deltarecovered = []
recovered = []
state = []
for data in districts_daily['statewise']:
    active.append(data['active'])
    confirmed.append(data['confirmed'])
    deaths.append(data['deaths'])
    deltaconfirmed.append(data['deltaconfirmed'])
    deltadeaths.append(data['deltadeaths'])
    deltarecovered.append(data['deltarecovered'])
    recovered.append(data['recovered'])
    state.append(data['state'])

statedf = pandas.DataFrame({'active':active,
'confirmed':confirmed,
'deaths':deaths,
'deltaconfirmed':deltaconfirmed,
'deltadeaths':deltadeaths,
'deltarecovered':deltarecovered,
'recovered':recovered,
'state':state})
statedf['active'] = statedf['active'].astype(int)
statedf['confirmed'] = statedf['confirmed'].astype(int)
statedf['deaths'] = statedf['deaths'].astype(int)
statedf['recovered'] = statedf['recovered'].astype(int)
statedf['deltaconfirmed'] = statedf['deltaconfirmed'].astype(int)
statedf['deltarecovered'] = statedf['deltarecovered'].astype(int)
statedf['deltadeaths'] = statedf['deltadeaths'].astype(int)
statedf = statedf[statedf['state']!='Total']