PY
py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
import pandas as pd
import numpy as np
import datetime
df = pd.read_csv("/usercode/files/ca-covid.csv")
df.drop('state', axis=1, inplace=True)
df.to_csv("/usercode/files/ca-covid.csv", index=False)
x = df['date'] = pd.to_datetime(df['date'], format="%d.%m.%y")
y = df['weekday'] = x.dt.strftime("%A")
day = df['day'] = x.dt.strftime("%d")
df['month'] = pd.to_datetime(df['date'], format="%d.%m.%y").dt.month_name()
df = df[['weekday', 'month', 'date', 'day', 'cases', 'deaths']]
df.set_index('date', inplace=True)
df['ratio'] = np.where(df['cases'] == df['deaths'], 0, df['cases'] / df['deaths']) #create new column in df1 for price diff
print(df.groupby('month').sum())
print()
m = input()
print("Test")
print()
j = df[df['month'].str.contains(m)].max(1,['deaths'])
print(j)
print()
print(df.groupby('month')['cases'].nlargest())
print()
print(df.groupby('month')['deaths'].nlargest())
print()
print("Test: cases")
Enter to Rename, Shift+Enter to Preview
OUTPUT
Run