import pandas as pd

data={'product':['product_A','product_B','product_C','product_D'],

'quantity':[10,20,30,40],

'sales':[100,200,300,400],

'store':['store1','store2','store3''store4'],

'customer':['customer1','customer2','customer3','customer4']}

data = pd.DataFrame(data)

print(data)

product_sold=data[data['quantity']>0] ['product'].unique()

print(product_sold)

quantity_sold=data.groupby(['product'])['quantity'].sum().reset_index()

print(quantity_sold)	

quantity_sale_data.groupby(['product']).agg({'quantity': 'sum', 'sales': 'sum'}).reset_index()

print(quantity_sale)

quantity_store=data.groupby(['product', 'store']).agg({'quantity': 'sum'}).reset_index()

print(quantity_store) 

product_not_sold=data[ data['quantity']==0]['product'].unique()

print(product_not_sold)

customer_no_purchase=data [data[quantity]==0]['customer'].unique()


print(customer_no_purchase)