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: 90971011Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started