COVID DATA ANALYSIS

Question

Guys help out
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

Answer 1

Scarlet Witch
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 = df['deaths'] / df['cases']
df.insert(loc = len ( df.column ), column = 'ration' )

df.groupby('date')['ratio'].max().set_index()

Answer 2

Puneetha Gumpu what have you tried so far?

Answer 3

Post your attempt...

Answer 4

Quantum
Worked perfectly

Answer 5

Quantum
I'm working out on this one any suggestion.

You are given an array that represents house prices.
Calculate and output the percentage of houses that are within one standard deviation from the mean.

Answer 6

Joshua chola That question about house prices doesn't belong in this thread.

Answer 7

Sure.

Answer 8

hey can any one help me out with covid data analytics

Answer 9

Puneetha Gumpu Ok great

Answer 10

hey thanks for the reply i got it