Question: Hi! I'm looking for help in the following python programming task. Please check the following covid.csv. We have to calculate a total number of deaths

Hi! I'm looking for help in the following python programming task.

Please check the following covid.csv. We have to calculate a total number of deaths and cases for each country using the latest date commulative_count. You can use year_week column for the date and get the commulative column. For example, cumulative count for country (Europe (total)) with the latest date is "32218360" as you can see in the covid. Using this data we can have the output like this screenshot:

THE NUMBERS CAN BE DIFFERENT SO DON'T WORRY ABOUT THE SAME OUTPUT.

Hi! I'm looking for help in the following python programming task. Please

Please note: We have to do everything programmatically. Hard-coding is not allowed to me. Please make sure of that.

Covid.csv

country,country_code,continent,population,indicator,weekly_count,year_week,rate_14_day,cumulative_count,source "Europe (total),,Europe,848075955,deaths,36317,2020-49,86.5488516296869,445680,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,deaths,36445,2020-50,85.796560521516,482125,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,deaths,35665,2020-51,85.0277614579935,517790,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,deaths,35806,2020-52,84.2742912101546,553596,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,deaths,39293,2021-03,91.7347078894602,701991,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,cases,1649457,2020-49,394.802019826161,20594760,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,cases,1692382,2020-50,394.049492890056,22287142,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,cases,1659360,2020-51,395.217194903256,23946502,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,cases,1713974,2020-52,397.763193274357,25660476,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,cases,1568022,2020-53,386.993167374967,27228498,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,cases,1881972,2021-01,406.802477969087,29110470,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,cases,1633935,2021-02,414.57454126264,30744405,""Epidemic intelligence, national weekly data""" "Europe (total),,Europe,848075955,cases,1473955,2021-03,366.463638271645,32218360,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,cases,37141,2020-49,706.800512405201,298187,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,cases,43384,2020-50,787.131415512036,341571,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,cases,47810,2020-51,891.420829633091,389381,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,cases,39076,2020-52,849.310154215198,428457,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,deaths,631,2020-51,117.299931526165,8950,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,deaths,659,2020-52,126.097426390627,9609,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,deaths,636,2020-53,126.58617610532,10245,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,deaths,606,2021-01,121.405429129581,10851,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,deaths,307,2021-02,89.2456979028239,11158,""Epidemic intelligence, national weekly data""" "Sweden,SWE,Europe,10230185,deaths,89,2021-03,38.7089774036344,11247,""Epidemic intelligence, national weekly data""" "Africa (total),,Africa,1339423921,deaths,4086,2020-53,5.91896252986212,67280,""Epidemic intelligence, national weekly data""" "Africa (total),,Africa,1339423921,deaths,5554,2021-01,7.19712396416131,72834,""Epidemic intelligence, national weekly data""" "Africa (total),,Africa,1339423921,deaths,6060,2021-02,8.67089187964413,78894,""Epidemic intelligence, national weekly data""" "Africa (total),,Africa,1339423921,deaths,6501,2021-03,9.37791225247201,85395,""Epidemic intelligence, national weekly data""" "Afghanistan,AFG,Asia,38928341,cases,0,2020-01,,0,""Epidemic intelligence, national weekly data""" "Afghanistan,AFG,Asia,38928341,cases,0,2020-02,0,0,""Epidemic intelligence, national weekly data""" "Afghanistan,AFG,Asia,38928341,cases,0,2020-03,0,0,""Epidemic intelligence, national weekly data""" "Afghanistan,AFG,Asia,38928341,cases,0,2020-04,0,0,""Epidemic intelligence, national weekly data""" "Afghanistan,AFG,Asia,38928341,cases,0,2020-05,0,0,""Epidemic intelligence, national weekly data""" "Afghanistan,AFG,Asia,38928341,cases,0,2020-06,0,0,""Epidemic intelligence, national weekly data""" "Afghanistan,AFG,Asia,38928341,cases,0,2020-07,0,0,""Epidemic intelligence, national weekly data""" "Afghanistan,AFG,Asia,38928341,cases,0,2020-08,0,0,""Epidemic intelligence, national weekly data"""

Confirmed Cases: 3230329979 Deaths: 4724720 Cases in Europe Confirmed Cases: 1041272085 Deaths: 85139162 Cases in Asia Confirmed Cases: 707376540 Deaths: 39735506 Cases in Africa Confirmed Cases: 110926550 Deaths: 7065634 Cases in America Confirmed Cases: 2540944 Deaths: 116386 Cases in Oceania Confirmed Cases: 1368210093 Deaths: 90971011

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!