Plotting empty data in a plotly graph

Question

I have a situation where I have a series of data, with some values missing in the middle. Like below:

If you see the data, 2 is missing in the series.

I wish to plot a box plot or a violin plot where, I can have a placeholder for the 2 series, which would mean no data is present for it.

Right now I can plot by inserting 2 and substituting NaNs and it gives a plot like below:

Is there a better way to plot without manipulating the data, either by use of texts on X Axis or by just having a placeholder?

mozway · Accepted Answer · 2022-11-28 16:25:35Z

2

You can combine a Categorical and seaborn.boxplot:

import seaborn as sns

df = pd.DataFrame({'X': [1,1,1,1,1,3,3,3,3,3],
                   'Y': [1,2,3,4,5,6,7,8,9,10]
                  })
df['X'] = pd.Categorical(df['X'], categories=[1, 2, 3])

sns.boxplot(data=df, x='X', y='Y')

Output:

annotating the missing categories:

ax = sns.boxplot(data=df, x='X', y='Y')

# positions of the categories in the X-axis
cats = {c: i for i,c in enumerate(df['X'].cat.categories)}
missing = set(df['X'].cat.categories)-set(df['X'])
# {2}

# mid-point of the Y-axis
y_pos = np.mean(ax.get_ylim())

for x in missing:
    ax.annotate('N/A', (cats[x], y_pos), ha='center')

Output:

edited Nov 28, 2022 at 16:25

answered Nov 28, 2022 at 12:09

mozway

267k13 gold badges56 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shyam V Over a year ago

Thanks @mozway. This is helpful. Is there anyway to mark the 2, like no data is available, like a text or label there?

mozway Over a year ago

Not automatically, but you can manually use annotate

Collectives™ on Stack Overflow

Plotting empty data in a plotly graph

1 Answer 1

annotating the missing categories:

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

annotating the missing categories:

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related