How to plot bars from pandas value_counts

Question

I have used the pandas value_counts function to provide counts of unique values:

CountStatus = pd.value_counts(df['scstatus'].values, sort=True)

Output:
200    133809
304      7217
404      2176
302       740
500       159
403         4
301         1
dtype: int64

I now want to plot these values using matplotlib i.e plt.barh(CountStatus), however I keep getting the error: ValueError: incompatible sizes: argument 'width' must be length 7 or scalar.

I'm guessing this may have something to do with the left hand column being an index column. Is there a way around this to obtain a horizontal bar chart? Do I need to convert it or specify something else in the function?

Trenton McKinney · Accepted Answer · 2023-07-08 17:39:18Z

29

Update

pandas.Series.value_counts is a Series method
- Use normalize=True to get the relative frequencies, and multiply by 100 , .mul(100), for percent, if needed.
Plot with pandas.Series.plot with kind='bar' or kind='barh'

import seaborn as sns

# test data, loads a pandas dataframe
df = sns.load_dataset('planets')

# display(df.head(3))
            method  number  orbital_period  mass  distance  year
0  Radial Velocity       1         269.300  7.10     77.40  2006
1  Radial Velocity       1         874.774  2.21     56.95  2008
2  Radial Velocity       1         763.000  2.60     19.84  2011

# plot value_counts of Series
ax = df.method.value_counts().plot(kind='barh')
ax.set_xscale('log')

Original Answer

I think you can use barh:

CountStatus.plot.barh()

Sample:

CountStatus = pd.value_counts(df['scstatus'].values, sort=True)
print CountStatus
AAC    8
AA     7
ABB    4
dtype: int64

CountStatus.plot.barh()

edited Jul 8, 2023 at 17:39

Trenton McKinney

63.2k41 gold badges170 silver badges213 bronze badges

answered Apr 21, 2016 at 7:22

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

How to plot bars from pandas value_counts

1 Answer 1

Update

Original Answer

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Update

Original Answer

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related