CUSTOMDATA not annotating correct information

📊 Plotly Python
1

Hi all,

I am trying to use customdata to display more information as a text template on my treemap. Unfortunately, the text being displayed does not match my data. Below is an example using a simplified dataset:

Code for treemap:

image
image2007×542 69.5 KB

Treemap:
image

Data:

3
3886×310 13 KB

In testing, I find that the year displays properly if added as another layer to the treemap, however I do not wish to display my data in this manner:

Updated code:

4
41872×488 198 KB

Updated map:
5

I have updated my plotly and python. Any ideas as to what I am doing incorrectly?

2

Hi @BBNR welcome to the forums.

Did you check for duplicates in your df? This sometimes leads to something similar.

3

Hi @AIMPED

Thanks for the reply, this issue has really been stumping me.

I tested it with a remove duplicates line but faced the same issue. In a subsequent test, I changed the ‘Year’ column to have values 0 → len(df) and noticed that the annotations appear to be linked to the wrong pathing. For example, here is my updated code:

image
image1991×711 83.6 KB

(Note the altered year value post sorting: df[‘Year’] = (range(0, len(df))))

Which produces the following values:

image
image543×1650 85.3 KB

However, my treemap looks like this:

image
image3135×755 89.2 KB

Which is akin to the opposite pathing I have (TO 49ers instead of the desired FROM 49ers):

image
image544×1631 91.9 KB

My original data has another layer, so doing something like flipping the From/To in the mapping won’t work. Any ideas?

Thank you again for all the help!

4

Just wanted to bump this, as I am still dealing with the issue. I can now confirm that swapping the from/to does showcase the correct information in the sample data, however I could not work this out in the main data that includes 3 layers instead of 2.

Am I missing something about the fundamentals of treemaps? Why are my text annotations incorrect?