How to annotate pandas bar graph with values from two dictionaries displayed on one graph?

Question

My Code:

import numpy as np
import matplotlib.pyplot as plt
import pandas as pd

ME_Requests = {'John Doe': 105, 'Amanda Doe': 64, 'Maria Doe': 48, 'Dimitrii Doe': 44}
non_ME_Requests = {'John Doe': 47, 'Amanda Doe': 27, 'Maria Doe': 26,}

df = pd.DataFrame({'ME_Request':ME_Requests,
          'non_ME_request':non_ME_Requests})
          

axes = df.plot.bar( title='My Barplots',subplots = True, sharex=True, sharey=True)
for ax in axes:
    for p in ax.patches:
        ax.annotate(str(round(p.get_height(),2)), (p.get_x(), p.get_height()))

plt.gcf().autofmt_xdate()
plt.show()

It returns two separate bar graphs (blue and orange) with annotations. However, I'm aiming to have both (blue and orange) showing on the same graph. Also, not sure why orange graph has numbers displayed in different format example: 0.0 instead of 0.

Could someone help me with this please? Thank you in advance!

subplots = False works but throws an iterable error ... that's where I'd start. — DarrenRhodes
– DarrenRhodes, Commented Sep 4, 2020 at 8:02
I think you need to iterate over the DataFrame rather than the axes. (In fact, should you be iterating? When you can vectorise?) — DarrenRhodes
– DarrenRhodes, Commented Sep 4, 2020 at 8:08
Try this solution matplotlib.org/3.1.1/gallery/lines_bars_and_markers/… — DarrenRhodes
– DarrenRhodes, Commented Sep 4, 2020 at 8:23

Diziet Asahi · Accepted Answer · 2020-09-04 08:01:29Z

3

You are passing subplots=True to the plotting function, which is why it is creating two subplots instead of putting both sets of bars on the same axes.

If you use subplots=False, then the function only returns one axes and not an array, so you need to remove the for-loop

ax = df.plot.bar( title='My Barplots',subplots = False, sharex=True, sharey=True)
for p in ax.patches:
    ax.annotate('{:.0f}'.format(p.get_height()), (p.get_x(), p.get_height()))

answered Sep 4, 2020 at 8:01

Diziet Asahi

41k8 gold badges67 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

How to annotate pandas bar graph with values from two dictionaries displayed on one graph?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related