Python Exercise: List countries with no cases of Novel Coronavirus recovered
Python Project: COVID-19 Exercise-6 with Solution
Write a Python program to list countries with no cases of Novel Coronavirus (COVID-19) recovered.
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')
data = covid_data.groupby('Country/Region')['Confirmed', 'Deaths', 'Recovered'].sum().reset_index()
result = data[data['Recovered']==0][['Country/Region', 'Confirmed', 'Deaths', 'Recovered']]
print(result)
Sample Output:
Country/Region Confirmed Deaths Recovered 1 Albania 55 1 0 4 Antigua and Barbuda 1 0 0 7 Aruba 3 0 0 13 Barbados 2 0 0 16 Benin 1 0 0 17 Bhutan 1 0 0 18 Bolivia 11 0 0 21 Brunei 56 0 0 22 Bulgaria 67 2 0 23 Burkina Faso 15 0 0 25 Cameroon 10 0 0 27 Central African Republic 1 0 0 28 Chile 201 0 0 31 Congo (Brazzaville) 1 0 0 32 Congo (Kinshasa) 3 0 0 33 Costa Rica 41 0 0 37 Cuba 5 0 0 38 Cyprus 46 0 0 41 Dominican Republic 21 1 0 42 Ecuador 58 2 0 44 Equatorial Guinea 1 0 0 46 Eswatini 1 0 0 47 Ethiopia 5 0 0 50 French Guiana 11 0 0 51 Gabon 1 0 0 54 Ghana 7 0 0 56 Greenland 1 0 0 57 Guadeloupe 18 0 0 58 Guam 3 0 0 59 Guatemala 6 1 0 60 Guernsey 0 0 0 61 Guinea 1 0 0 62 Guyana 7 1 0 63 Holy See 1 0 0 64 Honduras 8 0 0 66 Iceland 220 1 0 76 Jersey 0 0 0 78 Kazakhstan 33 0 0 79 Kenya 3 0 0 81 Kosovo 2 0 0 85 Liberia 1 0 0 86 Liechtenstein 7 0 0 88 Luxembourg 140 1 0 90 Maldives 13 0 0 92 Martinique 16 1 0 93 Mauritania 1 0 0 94 Mayotte 1 0 0 97 Monaco 7 0 0 98 Mongolia 5 0 0 99 Montenegro 2 0 0 101 Namibia 2 0 0 104 New Zealand 12 0 0 105 Nigeria 3 0 0 110 Panama 69 1 0 111 Paraguay 9 0 0 116 Puerto Rico 0 0 0 118 Republic of the Congo 0 0 0 119 Reunion 9 0 0 122 Rwanda 7 0 0 123 Saint Lucia 2 0 0 124 Saint Vincent and the Grenadines 1 0 0 129 Seychelles 4 0 0 131 Slovakia 72 0 0 132 Slovenia 275 1 0 133 Somalia 1 0 0 134 South Africa 62 0 0 137 Sudan 1 1 0 138 Suriname 1 0 0 142 Tanzania 1 0 0 144 The Bahamas 1 0 0 145 The Gambia 1 0 0 146 Togo 1 0 0 147 Trinidad and Tobago 5 0 0 148 Tunisia 24 0 0 149 Turkey 47 1 0 151 Ukraine 14 2 0 154 Uruguay 29 0 0 155 Uzbekistan 10 0 0 156 Venezuela 33 0 0 158 occupied Palestinian territory 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 get the latest country wise deaths cases of Novel Coronavirus (COVID-19).
Next: Write a Python program to list countries with all cases of Novel Coronavirus (COVID-19) died.
What is the difficulty level of this exercise?
Python: Tips of the Day
Creates a dictionary with the same keys as the provided dictionary and values generated by running the provided function for each value:
Example:
def tips_map_values(obj, fn): ret = {} for key in obj.keys(): ret[key] = fn(obj[key]) return ret users = { 'Owen': { 'user': 'Owen', 'age': 29 }, 'Eddie': { 'user': 'Eddie', 'age': 15 } } print(tips_map_values(users, lambda u : u['age'])) # {'Owen': 29, 'Eddie': 15}
Output:
{'Owen': 29, 'Eddie': 15}
- New Content published on w3resource:
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- React - JavaScript Library
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework