Skip to content

Instantly share code, notes, and snippets.

@mashhadazam

mashhadazam/ConsolidatedDataCovid19.py

Created March 6, 2020 15:00
Show Gist options
  • Save mashhadazam/54076bd7985001867d6c41abfb3835d3 to your computer and use it in GitHub Desktop.
Save mashhadazam/54076bd7985001867d6c41abfb3835d3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ConsolidatedDataCovid19.py
CountryConsolidated=pd.merge(ConfirmedCasesCountry,NewCasesCountry,how='left',left_index=True,right_index=True)
CountryConsolidated=pd.merge(CountryConsolidated,NewDeathsCountry,how='left',left_index=True,right_index=True)
CountryConsolidated=pd.merge(CountryConsolidated,DeathsCountry,how='left',left_index=True,right_index=True)
CountryConsolidated=pd.merge(CountryConsolidated,RecoveriesCountry,how='left',left_index=True,right_index=True)
CountryConsolidated=pd.merge(CountryConsolidated,NewRecoveriesCountry,how='left',left_index=True,right_index=True)
CountryConsolidated['Active Cases']=CountryConsolidated['Total Confirmed Cases']-CountryConsolidated['Total Deaths']-CountryConsolidated['Total Recoveries']
CountryConsolidated['Share of Recoveries - Closed Cases']=np.round(CountryConsolidated['Total Recoveries']/(CountryConsolidated['Total Recoveries']+CountryConsolidated['Total Deaths']),2)
CountryConsolidated['Death to Cases Ratio']=np.round(CountryConsolidated['Total Deaths']/CountryConsolidated['Total Confirmed Cases'],3)
CountryConsolidated.tail(2)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment