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.

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
Get step-by-step solutions from verified subject matter experts
