text_html_output_1.png
import pandas as pd

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

data = pd.read_excel('/kaggle/input/market-basket-analysis/Assignment-1_Data.xlsx')

data.columns

data.Date.unique()

data.groupby('Itemname').mean()

data[data.Itemname == '12 COLOURED PARTY BALLOONS']

data.isna().sum()

data.Itemname.unique()
data.CustomerID.unique()

data.fillna({'Itemname': 'no', 'CustomerID': 'Others'}, inplace=True)
data.isna().sum()

data.CustomerID.unique()

data.describe()