Pandas annotate dataframe hist

Question

df = { 'id' : pd.Series([1,1,1,1,2,2,2,2,3,3,4,4,4])}

num_id = df['id'].value_counts().hist(bins=2)

I an get a nice histogram with the count of number of ids that fall into each bin.

Question is, how do i add annotations to each bar to show the count? It could be in the middle with white text.

I know there is an ax parameter that we can specify in hist() but i am not sure how.

ax.text is what you need. You can tie the x and y coordinates to the bin edges hist returns... — Kartik
– Kartik, Commented Oct 16, 2016 at 6:17

Kartik · Accepted Answer · 2016-10-16 06:36:37Z

4

Here you are (with the import statements, just in case):

import pandas as pd
import matplotlib.pyplot as plt

df = pd.DataFrame({ 'id' : [1,1,1,1,2,2,2,2,3,3,4,4,4]})

fig, ax = plt.subplots()
freq, bins, _ = ax.hist(df['id'].value_counts(), 2, facecolor='skyblue')
ax.grid(True)
for i, n in enumerate(freq):
    ax.text(bins[i]+0.5, 2, n)
ax.set_xlabel('Bins')
ax.set_ylabel('Freq')
plt.show()

answered Oct 16, 2016 at 6:36

Kartik

8,73345 silver badges78 bronze badges

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

Collectives™ on Stack Overflow

Pandas annotate dataframe hist

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