text_plain_output_2.png text_plain_output_1.png image_output_1.png
import pandas as pd

train = pd.read_csv('../input/juniper-networks-global-ai-challenge/training_dataset.csv')
test = pd.read_csv('../input/juniper-networks-global-ai-challenge/test_dataset.csv')

train.register__sales_dollar_amt_this_hour.plot.density(color='red')

y_train = train['register__sales_dollar_amt_this_hour']
train = train.drop(['region__peak_sales_dollar_amt_per_hour_v2', 'region__peak_returns_dollar_amt_per_hour_v2', 'Unnamed: 0'], axis=1)
test = test.drop(['region__peak_sales_dollar_amt_per_hour_v2', 'region__peak_returns_dollar_amt_per_hour_v2'], axis=1)

train['observation_timestamp'] = pd.to_datetime(train['observation_timestamp'])
test['observation_timestamp'] = pd.to_datetime(test['observation_timestamp'])

pd.to_datetime(train['observation_timestamp']).dt.month