text_plain_output_1.png
import pandas as pd

items = pd.read_csv('/kaggle/input/competitive-data-science-predict-future-sales/items.csv')
submission = pd.read_csv('/kaggle/input/competitive-data-science-predict-future-sales/sample_submission.csv')
items_cat = pd.read_csv('/kaggle/input/competitive-data-science-predict-future-sales/item_categories.csv')
train = pd.read_csv('/kaggle/input/competitive-data-science-predict-future-sales/sales_train.csv')
shops = pd.read_csv('/kaggle/input/competitive-data-science-predict-future-sales/shops.csv')
test = pd.read_csv('/kaggle/input/competitive-data-science-predict-future-sales/test.csv')

df_items = pd.merge(left=items, right=items_cat, on='item_category_id')

df_shops = pd.merge(left=train, right=shops, on='shop_id')

df = pd.merge(left=df_shops, right=df_items, on='item_id')

df.shape

df.nunique()

df.describe()