Skip to content

Instantly share code, notes, and snippets.

@rvipandey
Created June 27, 2020 06:01
Show Gist options
  • Save rvipandey/9e0eb97c6ccc439667a6dd8c66ae9dc5 to your computer and use it in GitHub Desktop.
Save rvipandey/9e0eb97c6ccc439667a6dd8c66ae9dc5 to your computer and use it in GitHub Desktop.
state_wise=state_wise_daily.groupby("State_Name").sum().reset_index()
state_wise["Mortality Rate Per 100"] =np.round(100*state_wise["Deceased"]/state_wise["Confirmed"],2)
state_wise['Mortality Rate Per 100'] = state_wise['Mortality Rate Per 100'].fillna(0)
state_wise.sort_values(by='Mortality Rate Per 100',ascending=False).style.background_gradient(cmap='Blues',subset=["Confirmed"])\
.background_gradient(cmap='Greens',subset=["Recovered"])\
.background_gradient(cmap='Reds',subset=["Deceased"])\
.background_gradient(cmap='YlOrBr',subset=["Mortality Rate Per 100"]).hide_index()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment