 COVID DATA ANALYSIS | Sololearn: Learn to code for FREE!

+1

# COVID DATA ANALYSIS

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

+3

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()

+2

+1

Quantum Worked perfectly

+1

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

+1

hey can any one help me out with covid data analytics

+1

Puneetha Gumpu what have you tried so far?

+1

Puneetha Gumpu Ok great

0

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.

0

hey thanks for the reply i got it