+ 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
10 Answers
+ 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()
+ 1
Puneetha Gumpu what have you tried so far?
0
Post your attempt...
0
Quantum
Worked perfectly
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
Joshua chola That question about house prices doesn't belong in this thread.
0
Sure.
0
hey can any one help me out with covid data analytics
0
Puneetha Gumpu Ok great
- 1
hey thanks for the reply i got it
Often have questions like this?
Learn more efficiently, for free:
