pandas matplotlib labels bars as percentage

Question

I currently made a bar chart using a dataframe that labels the bars with their values, which outputs this:

ax = df.plot.bar()
for container in ax.containers:
    ax.bar_label(container)

I would like to format the values as percentages. How can I do this without radically modifying the code that I used to generate the graph?

blackraven · Accepted Answer · 2022-09-15T06:42:37.600

2

Perhaps you could convert the column into percentage values before plotting the chart.
Using this df as example:

df = pd.DataFrame({'lab':['A', 'B', 'C'], 'val':[10, 30, 20]})
ax = df.plot.bar(x='lab', y='val', rot=0)
for container in ax.containers:
    ax.bar_label(container)

print(df)
  lab  val
0   A   10
1   B   30
2   C   20

import pandas as pd
import matplotlib.pyplot as plt
import matplotlib.ticker as mtick

#convert to percentage labels
df = pd.DataFrame({'lab':['A', 'B', 'C'], 'val':[10, 30, 20]})
df['val'] = df['val'].apply(lambda x: (x/df['val'].sum())*100)
labels = df['val'].round(1).astype('str') + '%'
ax = df.plot.bar(x='lab', y='val', rot=0)
for container in ax.containers:
    ax.bar_label(container, labels=labels)
    ax.yaxis.set_major_formatter(mtick.PercentFormatter())    #from @Quinten

edited Sep 15 '22 at 06:42

answered Sep 10 '22 at 20:17

blackraven

5,284
7
19
45

in your screenshot, the labels aren't formatted as percentages – Nicholas Hansen-Feruch Sep 10 '22 at 22:02
I've added the percentage labels to the chart, is this what you're looking for? – blackraven Sep 11 '22 at 02:23
1

That looks correct! I messed with my code so I'm not able to test it now but it looks like it should work, thanks! – Nicholas Hansen-Feruch Sep 11 '22 at 23:17

score 2 · Answer 2 · answered Sep 11 '22 at 08:43

If you want to have percentages as labels for your y-axis, you could use mtick.PercentFormatter() from matplotlib.ticker like this (data from @perpetualstudent):

import pandas as pd
import matplotlib.ticker as mtick

df = pd.DataFrame({'lab':['A', 'B', 'C'], 'val':[10, 30, 20]})
ax = df.plot.bar(x='lab', y='val', rot=0)
for container in ax.containers:
    ax.bar_label(container)
    ax.yaxis.set_major_formatter(mtick.PercentFormatter())

Output:

pandas matplotlib labels bars as percentage

2 Answers2

Linked