+ 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

29th Mar 2021, 12:15 PM
Joshua chola
Joshua chola - avatar
10 odpowiedzi
+ 7
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()
29th Mar 2021, 12:27 PM
Joshua chola
Joshua chola - avatar
+ 1
Puneetha Gumpu what have you tried so far?
1st Apr 2021, 7:11 AM
Joshua chola
Joshua chola - avatar
0
Post your attempt...
29th Mar 2021, 12:19 PM
Scarlet Witch
Scarlet Witch - avatar
0
Quantum Worked perfectly
29th Mar 2021, 1:10 PM
Joshua chola
Joshua chola - avatar
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.
29th Mar 2021, 1:15 PM
Joshua chola
Joshua chola - avatar
0
Joshua chola That question about house prices doesn't belong in this thread.
29th Mar 2021, 1:19 PM
Jan
Jan - avatar
0
Sure.
29th Mar 2021, 1:28 PM
Joshua chola
Joshua chola - avatar
0
hey can any one help me out with covid data analytics
1st Apr 2021, 6:57 AM
Puneetha Gumpu
Puneetha Gumpu - avatar
0
1st Apr 2021, 7:14 AM
Joshua chola
Joshua chola - avatar
- 1
hey thanks for the reply i got it
1st Apr 2021, 7:13 AM
Puneetha Gumpu
Puneetha Gumpu - avatar