Bar plot x axis is messy using pandas python

Question

Bar plot x axis is getting very messy , I have also rotated the angle but it is still very messy any help would be appreciated.

this is the code

ax=yearresult.plot(kind='bar',x='BBB',y='AAA')
ax.set_xticklabels(ax.get_xticklabels(), rotation=90)
ax.legend(["AAA", "BBB"]);
plt.tight_layout()
plt.show()

You simply cannot plot 100 categories in a bar chart. Try getting the top 10. — Erfan
– Erfan, Commented Mar 30, 2020 at 12:00
I'm pretty sure, that you should think about representing the data in a different way, if you really need everything to be seen — user8408080
– user8408080, Commented Mar 30, 2020 at 13:35

mohammed oqayli · Accepted Answer · 2020-03-30 14:02:17Z

0

you cannot plot 100 categories in a bar chart it will not be clear. Try getting the top 15 like this:

 top_15 = df.AA.value_counts().iloc[:15]
 sns.countplot(x = "AA", data = df, order=top_15.index);

and no need for legend in that case

answered Mar 30, 2020 at 14:02

mohammed oqayli

311 bronze badge

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

Collectives™ on Stack Overflow

Bar plot x axis is messy using pandas python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related