When can the data contain 1/0 for amount and kgs

retail
data_wrangling

#1

Hello,

I have been asked to gain insights from the below dataset:

Here amount and kgs are 0/1,this is baffling for me.
Can someone please guide me on how to interpret this data.
The objective is to find most profitable customers


#2

@pagal_guy- I think you can find most profitable customer by multiplying Amount with Kgs for each unique
Customer ID.In this way, you can find a most profitable customer.

Hope this helps!

Regards,
Hinduja


#3

Hello@pagal_guy
Customers with amount at least 1 and kg 1, have bought at least some product whereas customers with (0,1), (1,0) and (0,0) combination of products might have misrecorded readings and have not bought anything.