dataset in picture Use the given dataset to perform the following using python: Name of dataframe (your reg_no+your_name) Import the given data set Find out its header and information Calculate the...


dataset in picture



  1. Use the given dataset to perform the following using python:

  2. Name of dataframe (your reg_no+your_name)

  3. Import the given data set

  4. Find out its header and information

  5. Calculate the mean, median and mode of covid_deaths, covid_recoveries, and covid_cases

  6. Find out the total of covid affected cases(all three cases) in all countries

  7. Find out the total of covid related deaths in all countries







































































Countriescovid_deathscovid_recoveriescovid_cases
Pakistan1000052000055000
India12000120000130000
Bangladesh14000123000120000
Srilanka1900021300045000
Bhutan1200021244000
Nepal1000900012300
Australia8000056000032100
Singapore200013000012345
England10000032000089765
USA10000089000087898

ITCLABFINALCSV - Excel<br>File<br>Home<br>Insert<br>Page Layout<br>Formulas<br>Data<br>Review<br>View<br>Power Pivot<br>O Tell me what you want to do...<br>Usama Sarwar & Share<br>% Cut<br>E AutoSum -<br>Calibri<br>11<br>EWrap Text<br>General<br>Normal<br>Bad<br>Good<br>Ee Copy -<br>V Fill -<br>Paste<br>BIU-<br>A -<br>O Merge & Center -<br>$ - % ,<br>e0 .00<br>.00<br>Conditional Format as Neutral<br>Calculation<br>Check Cell<br>Insert Delete Format<br>Sort & Find &<br>V Format Painter<br>Formatting - Table -<br>Clear<br>Filter - Select -<br>Clipboard<br>Font<br>Alignment<br>Number<br>Styles<br>Cells<br>Editing<br>D11<br>fr<br>87898<br>A<br>B<br>C<br>F<br>G<br>H<br>K<br>M<br>N<br>P<br>R<br>V<br>1 Countries covid_dea covid_recc covid_cases<br>2 Pakistan<br>3 India<br>4 Bangladesl<br>5 Srilanka<br>6 Bhutan<br>7 Nepal<br>8 Australia<br>9 Singapore<br>10 England<br>11 USA<br>10000<br>520000<br>55000<br>12000<br>120000<br>130000<br>14000<br>123000<br>120000<br>19000<br>213000<br>45000<br>12000<br>212<br>44000<br>1000<br>9000<br>12300<br>80000<br>560000<br>32100<br>2000<br>130000<br>12345<br>100000<br>320000<br>89765<br>100000<br>890000<br>87898|<br>12<br>13<br>14<br>15<br>16<br>17<br>18<br>19<br>20<br>21<br>22<br>23<br>24<br>25<br>26<br>27<br>28<br>29<br>30<br>

Extracted text: ITCLABFINALCSV - Excel File Home Insert Page Layout Formulas Data Review View Power Pivot O Tell me what you want to do... Usama Sarwar & Share % Cut E AutoSum - Calibri 11 EWrap Text General Normal Bad Good Ee Copy - V Fill - Paste BIU- A - O Merge & Center - $ - % , e0 .00 .00 Conditional Format as Neutral Calculation Check Cell Insert Delete Format Sort & Find & V Format Painter Formatting - Table - Clear Filter - Select - Clipboard Font Alignment Number Styles Cells Editing D11 fr 87898 A B C F G H K M N P R V 1 Countries covid_dea covid_recc covid_cases 2 Pakistan 3 India 4 Bangladesl 5 Srilanka 6 Bhutan 7 Nepal 8 Australia 9 Singapore 10 England 11 USA 10000 520000 55000 12000 120000 130000 14000 123000 120000 19000 213000 45000 12000 212 44000 1000 9000 12300 80000 560000 32100 2000 130000 12345 100000 320000 89765 100000 890000 87898| 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Jun 11, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?