text_plain_output_1.png
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

submission = pd.read_csv('/kaggle/input/tabular-playground-series-sep-2022/sample_submission.csv')
train = pd.read_csv('/kaggle/input/tabular-playground-series-sep-2022/train.csv')
test = pd.read_csv('/kaggle/input/tabular-playground-series-sep-2022/test.csv')

train.groupby(train['day'])['num_sold'].mean().sort_values(ascending=False)

train.groupby(train['month'])['num_sold'].mean().sort_values(ascending=False)

train.groupby(train['year'])['num_sold'].mean().sort_values(ascending=False)

train.groupby(train['dayofweek'])['num_sold'].mean().sort_values(ascending=False)

train.isnull().sum()

train.groupby(train['Covid'])['num_sold'].mean()