Adding max values label to plotly scatter plot

Question

I have been trying all day to add max value annotation to a plotly plot. I figured out how to do it manually but I am more interested in a more automatic solution. I added my code in but omitted anything unrelated.

Is there a way to add a label to the max points of my plotly scatterplot?

P.S. Please be nice this is my first posting here.

The relevant part of the code:

import plotly.express as px
import pandas as pd

m = df['values'].max()

day_order = ['Monday',
             'Tuesday',
             'Wednesday',
             'Thursday',
             'Friday',
             'Saturday',
             'Sunday']

fig = px.scatter(df,
                 x='day-of-week',
                 y ='values',
                 category_orders = {
                     'day-of-week': day_order})

fig.add_annotation(x='Sunday', 
                   y=m,
                   text=m)

Trying all day, but no code to show for your efforts? Please share the attempt that you were most convinced about that it would work, and explain what the problem is. stackoverflow.com/help/how-to-ask — Grismar
– Grismar, Commented Oct 6, 2021 at 23:34
Thanks for the suggestion! I added some code, again my annotation method works but I would like to know if there is a more streamlined solution. — vvv
– vvv, Commented Oct 6, 2021 at 23:54
It is also possible to specify the day of the week and the maximum value on the y-axis. It is also possible to specify the day of the week and the maximum value on the y-axis, but the one shown below specifies the first day of the week when there is more than one maximum value, so that needs to be considered. my_chart.add_annotation(x=df[df['values']==max(df['values'])]['day-of-week'].head(1),y=max(df['values']),text=max(df['values'])) — r-beginners
– r-beginners, Commented Oct 7, 2021 at 0:48
Hi @vvv welcome to SO! You should try to add a sample of your df. It will be great if you can have a look at How to Ask and then try to produce a minimal reproducible example. — rpanai
– rpanai, Commented Oct 7, 2021 at 2:45
I edited your code. If you are using pandas it is better to use df['values'].max() instead of max(df['values']) — rpanai
– rpanai, Commented Oct 7, 2021 at 2:51

rpanai · Accepted Answer · 2021-10-07 03:06:11Z

I generate a data sample for you.

Data

import plotly.express as px
import pandas as pd
import numpy as np

n = 14
df = pd.DataFrame(
    {"date": pd.date_range(
        start=pd.Timestamp.today().date(),
        periods=n),
     "values": np.arange(n)})

# date to day-of-week
df["day-of-week"] = df["date"].dt.day_name()

day_order = ['Monday',
             'Tuesday',
             'Wednesday',
             'Thursday',
             'Friday',
             'Saturday',
             'Sunday']

m = df["values"].max()

Plot

fig = px.scatter(df,
                 x='day-of-week',
                 y ='values',
                 category_orders = {
                     'day-of-week': day_order})

fig.add_annotation(x=df.iloc[df["values"].idxmax()]["day-of-week"], 
                   y=m,
                   text=str(m))

In the last part is important that text is a str

Mohil Patel · Accepted Answer · 2021-10-07 03:37:20Z

1

Used data

Code: find max value and day(s) with max value and add their annotations

max_value = df['values'].max()
max_days = df[df['values'] == max_value]['day-of-week'].values

day_order = ['Monday',
             'Tuesday',
             'Wednesday',
             'Thursday',
             'Friday',
             'Saturday',
             'Sunday']

fig = px.scatter(df,
                 x='day-of-week',
                 y ='values',
                 category_orders = {
                     'day-of-week': day_order})

for day in max_days:
  fig.add_annotation(x=day,
                    y=max_value,
                    text=max_value)

fig.show()

edited Oct 7, 2021 at 3:37

answered Oct 7, 2021 at 3:29

Mohil Patel

5203 silver badges9 bronze badges

1 Comment

vvv Over a year ago

Thanks this is perfect!!

Collectives™ on Stack Overflow

Adding max values label to plotly scatter plot

2 Answers 2

Data

Plot

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Data

Plot

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related