Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administrator Limited Edition

Authors: Martif Way

1st Edition

B0CGG89N8Z

More Books

Students also viewed these Databases questions