COVID Data Analysis - from course data science (python)

Question

Did any one pass this project?

"You are working with the COVID dataset for California, which includes the number of cases and deaths for each day of 2020.
Find the day when the deaths/cases ratio was largest.
To do this, you need to first calculate the deaths/cases ratio and add it as a column to the DataFrame with the name 'ratio', then find the row that corresponds to the largest value."

Link to this project: https://www.sololearn.com/learning/eom-project/1161/1162

I used the code below

print(df[df['ratio'] == df['ratio'].max()])

and got the output as follows

cases deaths ratio
date
10.03.20 7 1 0.142857

Unfortunately, the test case 1 doesn't let me pass. Could any one help me on this?

Answer 1

Thanks Derrickee for your answer.
Actually, your code is the same as mine with 1 redundant ' before the second df.

I found out what is wrong with this project:
- Do not change the link of the data source (the csv file) or you will get wrong answer. At first, I thought the link was wrong and I replaced it by the one we met during the course about Covid data in California. This act helps me to test the result on a python IDE but in fact it is the reason for the whole thing.

Answer 2

import pandas as pd

df = pd.read_csv("/usercode/files/ca-covid.csv")

df.drop('state', axis=1, inplace=True)
df.set_index('date', inplace=True)
df["ratio"] = df["deaths"] / df["cases"]
max_ratio = df.loc[df["ratio"] == df["ratio"].max()]
print(max_ratio)

Answer 3

df['ratio'] = df['deaths'] / df['cases']
print (df['df['ratio'] == df['ratio'].max()])

Read the question carefully😁

Answer 4

"""
sorry but why wouldn't this work? can someone explain?

df['ratio'] = df['deaths'] / df['cases']
print (df['df['ratio'].max()])
"""

Because df['ratio'].max() returns only max value of ratio so it looks like this: df[max_value_of_ratio] so it is mistake. When you want to get row from df you should equal it to the whole column. I did it with .loc method:

df["ratio"] = df["deaths"] / df["cases"]
max_ratio = df.loc[df["ratio"] == df["ratio"].max()]

print(max_ratio)

Answer 5

import pandas as pd

df = pd.read_csv("/usercode/files/ca-covid.csv")
df.set_index('date', inplace=True)
df.drop('state', axis=1, inplace=True)

print(df.iloc[-1])

Answer 6

df['ratio'] = df['deaths'] / df['cases']
print (df[df['ratio'] == df['ratio'].max()])

this work fine

Answer 7

import pandas as pd

df = pd.read_csv("/usercode/files/ca-covid.csv")

df.drop('state', axis=1, inplace=True)
df.set_index('date', inplace=True)

df['ratio'] = df['deaths']/df['cases']

print(df[ df['ratio']==df['ratio'].max() ])

Answer 8

I made it simple stupid and got a needed output

print(df.iloc[-1])

Answer 9

sorry but why wouldn't this work? can someone explain?

df['ratio'] = df['deaths'] / df['cases']
print (df['df['ratio'].max()])

Answer 10

Could anyone comment here what is the error here?

import pandas as pd

df = pd.read_csv("/usercode/files/ca-covid.csv")

df.drop('state', axis=1, inplace=True)
df.set_index('date', inplace=True)
ratio=(deaths/cases)*100
df.insert('ratio')
max_ratio=df.groupby('ratio')['ratio'].max()
print(max_ratio)

Answer 11

print(df[df['ratio']==df['ratio'].max()])
works fine.

Answer 12

!Derrickee remove " ' " before df in the print line that will bring syntax

Answer 13

import pandas as pd

df = pd.read_csv("/usercode/files/ca-covid.csv")

df.drop('state', axis=1, inplace=True)
df.set_index('date', inplace=True)
df['ratio']=df['deaths']/df['cases']
print(df.nlargest(1,'ratio'))

Answer 14

its very simple

you have to find the ratio ist

df['ratio'] = df['deaths']/df['cases']

then find the max ratio and print it

print(df[df['ratio'] == df['ratio'].max()])

Answer 15

import numpy as np

data = np.array([120, 98, 150, 65, 42, 100, 190, 220, 140, 110, 88, 89, 100, 120, 50, 180, 155, 42, 89, 77, 200, 190, 125, 98, 77, 40, 39, 59, 30, 67])

mean=np .mean(data)

counter=0

for i in data:
if i>mean:
counter+=1
print(counter)