Python Exercise: Get the latest number of confirmed, deaths, recovered and active cases of Novel Coronavirus Country wise
Write a Python program to get the latest number of confirmed, deaths, recovered and active cases of Novel Coronavirus (COVID-19) Country wise.
Sample Solution:
Python Code:
import pandas as pd
covid_data= pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_daily_reports/03-17-2020.csv')
covid_data['Active'] = covid_data['Confirmed'] - covid_data['Deaths'] - covid_data['Recovered']
result = covid_data.groupby('Country/Region')['Confirmed', 'Deaths', 'Recovered', 'Active'].sum().reset_index()
print(result)
Sample Output:
Country/Region Confirmed Deaths Recovered Active 0 Afghanistan 22 0 1 21 1 Albania 55 1 0 54 2 Algeria 60 4 12 44 3 Andorra 39 0 1 38 4 Antigua and Barbuda 1 0 0 1 5 Argentina 68 2 3 63 6 Armenia 78 0 1 77 7 Aruba 3 0 0 3 8 Australia 452 5 23 424 9 Austria 1332 3 1 1328 10 Azerbaijan 28 1 6 21 11 Bahrain 228 1 81 146 12 Bangladesh 10 0 3 7 13 Barbados 2 0 0 2 14 Belarus 36 0 3 33 15 Belgium 1243 10 1 1232 16 Benin 1 0 0 1 17 Bhutan 1 0 0 1 18 Bolivia 11 0 0 11 19 Bosnia and Herzegovina 26 0 2 24 20 Brazil 321 1 2 318 21 Brunei 56 0 0 56 22 Bulgaria 67 2 0 65 23 Burkina Faso 15 0 0 15 24 Cambodia 33 0 1 32 25 Cameroon 10 0 0 10 26 Canada 478 5 9 464 27 Central African Republic 1 0 0 1 28 Chile 201 0 0 201 29 China 81058 3230 68798 9030 30 Colombia 65 0 1 64 31 Congo (Brazzaville) 1 0 0 1 32 Congo (Kinshasa) 3 0 0 3 33 Costa Rica 41 0 0 41 34 Cote d'Ivoire 5 0 1 4 35 Croatia 65 0 4 61 36 Cruise Ship 696 7 325 364 37 Cuba 5 0 0 5 38 Cyprus 46 0 0 46 39 Czechia 396 0 3 393 40 Denmark 1024 4 1 1019 41 Dominican Republic 21 1 0 20 42 Ecuador 58 2 0 56 43 Egypt 196 4 32 160 44 Equatorial Guinea 1 0 0 1 45 Estonia 225 0 1 224 46 Eswatini 1 0 0 1 47 Ethiopia 5 0 0 5 48 Finland 321 0 10 311 49 France 7683 148 12 7523 50 French Guiana 11 0 0 11 51 Gabon 1 0 0 1 52 Georgia 34 0 1 33 53 Germany 9257 24 67 9166 54 Ghana 7 0 0 7 55 Greece 387 5 8 374 56 Greenland 1 0 0 1 57 Guadeloupe 18 0 0 18 58 Guam 3 0 0 3 59 Guatemala 6 1 0 5 60 Guernsey 0 0 0 0 61 Guinea 1 0 0 1 62 Guyana 7 1 0 6 63 Holy See 1 0 0 1 64 Honduras 8 0 0 8 65 Hungary 50 1 2 47 66 Iceland 220 1 0 219 67 India 142 3 14 125 68 Indonesia 172 5 8 159 69 Iran 16169 988 5389 9792 70 Iraq 154 11 32 111 71 Ireland 223 2 5 216 72 Israel 337 0 11 326 73 Italy 31506 2503 2941 26062 74 Jamaica 12 0 2 10 75 Japan 878 29 144 705 76 Jersey 0 0 0 0 77 Jordan 34 0 1 33 78 Kazakhstan 33 0 0 33 79 Kenya 3 0 0 3 80 Korea, South 8320 81 1407 6832 81 Kosovo 2 0 0 2 82 Kuwait 130 0 9 121 83 Latvia 49 0 1 48 84 Lebanon 120 3 3 114 85 Liberia 1 0 0 1 86 Liechtenstein 7 0 0 7 87 Lithuania 25 0 1 24 88 Luxembourg 140 1 0 139 89 Malaysia 673 2 49 622 90 Maldives 13 0 0 13 91 Malta 38 0 2 36 92 Martinique 16 1 0 15 93 Mauritania 1 0 0 1 94 Mayotte 1 0 0 1 95 Mexico 82 0 4 78 96 Moldova 30 0 1 29 97 Monaco 7 0 0 7 98 Mongolia 5 0 0 5 99 Montenegro 2 0 0 2 100 Morocco 38 2 1 35 101 Namibia 2 0 0 2 102 Nepal 1 0 1 0 103 Netherlands 1708 43 2 1663 104 New Zealand 12 0 0 12 105 Nigeria 3 0 0 3 106 North Macedonia 26 0 1 25 107 Norway 1463 3 1 1459 108 Oman 24 0 9 15 109 Pakistan 236 0 2 234 110 Panama 69 1 0 68 111 Paraguay 9 0 0 9 112 Peru 117 0 1 116 113 Philippines 187 12 5 170 114 Poland 238 5 13 220 115 Portugal 448 1 3 444 116 Puerto Rico 0 0 0 0 117 Qatar 439 0 4 435 118 Republic of the Congo 0 0 0 0 119 Reunion 9 0 0 9 120 Romania 184 0 16 168 121 Russia 114 0 8 106 122 Rwanda 7 0 0 7 123 Saint Lucia 2 0 0 2 124 Saint Vincent and the Grenadines 1 0 0 1 125 San Marino 109 7 4 98 126 Saudi Arabia 171 0 6 165 127 Senegal 26 0 2 24 128 Serbia 65 0 1 64 129 Seychelles 4 0 0 4 130 Singapore 266 0 114 152 131 Slovakia 72 0 0 72 132 Slovenia 275 1 0 274 133 Somalia 1 0 0 1 134 South Africa 62 0 0 62 135 Spain 11748 533 1028 10187 136 Sri Lanka 44 0 1 43 137 Sudan 1 1 0 0 138 Suriname 1 0 0 1 139 Sweden 1190 7 1 1182 140 Switzerland 2700 27 4 2669 141 Taiwan* 77 1 22 54 142 Tanzania 1 0 0 1 143 Thailand 177 1 41 135 144 The Bahamas 1 0 0 1 145 The Gambia 1 0 0 1 146 Togo 1 0 0 1 147 Trinidad and Tobago 5 0 0 5 148 Tunisia 24 0 0 24 149 Turkey 47 1 0 46 150 US 6421 108 17 6296 151 Ukraine 14 2 0 12 152 United Arab Emirates 98 0 23 75 153 United Kingdom 1960 56 53 1851 154 Uruguay 29 0 0 29 155 Uzbekistan 10 0 0 10 156 Venezuela 33 0 0 33 157 Vietnam 66 0 16 50 158 occupied Palestinian territory 0 0 0 0
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Python program to display first 5 rows from COVID-19 dataset.
Next: Write a Python program to get the latest number of confirmed deaths and recovered people of Novel Coronavirus (COVID-19) cases Country/Region - Province/State wise.
What is the difficulty level of this exercise?
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics