w3resource

Python Exercise: List countries with all cases of Novel Coronavirus recovered

Python Project: COVID-19 Exercise-8 with Solution

Write a Python program to list countries with all 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['Confirmed']==data['Recovered']]
result = result[['Country/Region', 'Confirmed', 'Recovered']]
result = result.sort_values('Confirmed', ascending=False)
result = result[result['Confirmed']>0]
result = result.reset_index(drop=True)
print(result)

Sample Output:

Dataset information:
<class 'pandas.core.frame.DataFrame'>
  Country/Region  Confirmed  Recovered
0          Nepal          1          1

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Python program to list countries with all cases of Novel Coronavirus (COVID-19) died.
Next: Write a Python program to get the top 10 countries data (Last Update, Country/Region, Confirmed, Deaths, Recovered) of Novel Coronavirus (COVID-19).

What is the difficulty level of this exercise?



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://www.w3resource.com/python-exercises/project/covid-19/python-covid-19-exercise-8.php