text_html_output_1.png
import pandas as pd

df = pd.read_csv('/kaggle/input/customer-shopping-dataset/customer_shopping_data.csv')

df.drop(['invoice_no', 'customer_id', 'invoice_date'], axis=1, inplace=True)

df.isnull().sum()

g = df.groupby('gender')[['price']].sum().reset_index()
g

c = df.groupby('category')[['price']].sum().reset_index()
c