I have a Pandas dataframe as following:
number Art 10000 Comics 235 Crafts 293 Dance 824 How can I plot a histogram that sort by values?
Demonstration:
* * * * * * * * * * * * * * * * * ------------- x labels = Art/ Dance/ Crafts/ Comics I have tried pandas.DataFrame.hist, but not sure how to select proper arguments.
1 Answer
You can just sort your dataframe first and then create the plot using your dataframes plot method
Test data (I set category as the index as thats what it looks like you have for your actual data):
import pandas as pd df = pd.DataFrame({'category': ['Art', 'Comics', 'Crafts', 'Dance'], 'number': [10000, 235, 293, 824]}) df.set_index('category', inplace=True) number category Art 10000 Comics 235 Crafts 293 Dance 824 Then sort by number using df.sort_values() and call df.plot():
df.sort_values('number', inplace=True) df.plot(y='number', kind='bar', legend=False) 
