'A way to place multiple data within same coordinate
I'm working with a DF of 78000~ clients each with a RFV Classification(Recency, Frequency, Value) and i'm trying to place them in a heatmap to demonstrate how they spend based on the RFV classification. But as the RFV allows only for simple integer from 1 to 5 as classification, i found it difficult to display it without them overlaping. Im trying it in plotly with Xarray.
My DF
| COD_CLIENT | RECENCY | Medium value | R | FV | RFV | RFV_Score | RFV_Level |
|---|---|---|---|---|---|---|---|
| 59 | 87 | 45.45 | 3 | 3 | 33 | 6 | Potential |
| 1846 | 75 | 6.00 | 3 | 2 | 32 | 5 | Seleepers |
| 4380 | 92 | 37.95 | 2 | 3 | 23 | 5 | Seleepers |
| object | int64 | float64 | int32 | int32 | int32 | int64 | object |
and my (crudely drawn) heatmap i want. For example, here is each pixel being a client and each column/row being their rfv:
Does anyone knows how or if can i do this?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|