I have a dataset with the following columns:
STORE_ID | sales_value | retail_disc | Quantity |
---|---|---|---|
354 | 20 | -0.2 | 2 |
354 | 3 | 0 | 7 |
120 | 45 | 0 | 1 |
580 | 3 | -4 | 1 |
354 | 6 | 0 | 4 |
120 | 3 | 0 | 1 |
354 | 89 | -2 | 7 |
580 | 3 | 0 | 1 |
I need to cluster the sales_value and retail_disc and quantity. After the clustering I need to get the corresponding store ID in each sample