please solve all parts I am in need ( in pycharm)Question II: A data repository is maintained by Johns Hopkins University CSSE research center (https://github.com/CSSEGISandData/COVID-19/) about corona virus incidents. The site https://www.w3resource.com/python-exercises/project/covid-19/index.php includes some exercises on COVID-19 data set. You can look at these exercises before solving the following questions. First, get the latest covid data from github as follows:# Import data import pandas as pd covid_data= pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID19/master/csse_covid_19_data/csse_covid_19_daily_reports/05-10-2022.csv') covid_series= pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv') Display first 5 rows from COVID-19 daily summary (covid_data) and time series (covid_series) datasets. Write a Python program to get the latest number of confirmed, deaths, recovered and active cases of Novel Coronavirus (COVID-19) Country wise. The result should be sorted by Active cases. 10 pts) Write a Python program to get the countries data (Country/Region, Last Update,Confirmed, Deaths, # Recovered, Active, and death_confirmed ratio) of Novel Coronavirus (COVID-19). The death_confimed_ratio is # Deaths / Confirmed * 100. The result should only contain countries where confimed cases > 1000 and be sorted by death_confirmed ratio. From question 2, get the list of top 10 countries according to confirmed cases. Then select data belong to the top 10 countries from convid_series data frame. By grouping with 'Country/Region', get the sum of cases in countries. Only select the columns after the date ‘3/11/21’ that is the first date in which a death case recorded in Turkey. The following figure shows a part of data you will obtain:After getting these data, plot the graph of data by using the following code:%matplotlib inline import matplotlib.pyplot as plttemp2.T.plot(figsize=(15,15),lw=8) Country RegionConfirmed Deaths Recovered Active171US461437 1647825410 41954984Italy143626182792847096877156Spain15322215447521658561061France11878112228234138314065Germany11818126075240763167175United Kingdom65872799335957520170Turkey4228290821423923280Iran6622041103230929801120Netherlands2190324032781922216Belgium249832523516417296Last Update Confirmed Deaths Recovered Active Death_Confirmed_Ratio108414.10564234728470 9687712.726804135 5696412.2593241666 235143626 1827965077 797821762 2396117749 1221024983 2523153222 15447250 1911611.01001723206 8233310.3695155164 1729610.09886752165 8561010.08145079320581438.67520091413293 28025227618.50288513749710911687.059680Country_RegionAlgeria 2020-04-09 23:02:19Italy 2020-04-09 23:02:19United Kingdom 2020-04-09 23:02:19Netherlands 2020-04-09 23:02:19France 2020-04-09 23:02:19Belgium 2020-04-09 23:02:19Spain 2020-04-09 23:02:19Sweden 2020-04-09 23:02:19Indonesia 2020-04-09 23:02:19Morocco 2020-04-09 23:02:19 3/11/20 3/12/20 3/13/20 3/14/20 3/15/20 3/16/20 3/17/20 3/18/20 3/19/20 3/20/20 3/21/20 3/22/20 3/23/20 3/24/20 3/25/20 3/26/20 3/27/20Country/Region1486 1795 2257Belgium 314 314 559689 886 1058 12432815 3401 3743 4269 4937 6235 7284France 2293 2293 3681 4496 4532 6683 7715 9124 10970 12758 14463 16243 20123 22622 25600 29551 33402Germany 190820783675 4585 5795 7272 9257 12327 15320 19848 22213 24873 29056 32986 37323 43938 50871Iran 9000 10075 11364 12729 13938 14991 16169 17361 18407 19644 20610 21638 23049 24811 27017 2940632332Italy 12462 12462 17660 21157 24747 27980 31506 35713 41035 47021 53578 59138 63927 69176 74386 80589 86498Netherlands 503 503 806 962 1138 1416 1711 2058 2467 3003 3640 4217 4764 5580 6438 7468 8647Spain 2277 2277 5232 6391 7798 9942 1174813910 17963 20410 25374 28768 35136 39885 49515 57786 657195184798 192 359 6701529 1872 2433 3629 5698217964217783 13747 19273 25600 33276 43847 53740 65778 83836 1016578021960 2642 2716 4014 5067 5745 6726 8164 9640 11812 14745Turkey15123611663US1281272711443499 46321145 1551United Kingdom459459Country/RegionBelgiumFranceGermanyIranItalyNetherlandsSpainTurkeyUSUnited Kingdom

Here I have answer about first two images......

Answered: Country Region Confirmed Deaths…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

please solve all parts I am in need ( in pycharm)

Question II: A data repository is maintained by Johns Hopkins University CSSE research center (https://github.com/CSSEGISandData/COVID-19/) about corona virus incidents. The site https://www.w3resource.com/python-exercises/project/covid-19/index.php includes some exercises on COVID-19 data set. You can look at these exercises before solving the following questions. First, get the latest covid data from github as follows:

# Import data

import pandas as pd

covid_data= pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID19/master/csse_covid_19_data/csse_covid_19_daily_reports/05-10-2022.csv')

covid_series= pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-

19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv')

Display first 5 rows from COVID-19 daily summary (covid_data) and time series (covid_series) datasets.
Write a Python program to get the latest number of confirmed, deaths, recovered and active cases of Novel Coronavirus (COVID-19) Country wise. The result should be sorted by Active cases.
1. 10 pts) Write a Python program to get the countries data (Country/Region, Last Update,
Confirmed, Deaths, # Recovered, Active, and death_confirmed ratio) of Novel Coronavirus (COVID-19). The death_confimed_ratio is # Deaths / Confirmed * 100. The result should only contain countries where confimed cases > 1000 and be sorted by death_confirmed ratio.
From question 2, get the list of top 10 countries according to confirmed cases. Then select data belong to the top 10 countries from convid_series data frame. By grouping with 'Country/Region', get the sum of cases in countries. Only select the columns after the date ‘3/11/21’ that is the first date in which a death case recorded in Turkey. The following figure shows a part of data you will obtain:

After getting these data, plot the graph of data by using the following code:

%matplotlib inline import matplotlib.pyplot as plt

temp2.T.plot(figsize=(15,15),lw=8)