How to display X axis from Pandas Dataframe Object to Matplotlib barchart

user_8989378 0
Viewed 245

I have created a pandas dataframe object from a CSV file being read into a dataframe. The csv is very short and includes the following data:

Group Title, Hosts ,Soccer 5, Soccer 4, Soccer 3 , Soccer 2, Soccer 1, Soccer X ,Soccer Y, Soccer Total

Units,11,1,3,4,4,5,

[1 rows x 8 columns]

I have successfully displayed the data on a bar chart however I want the x axis to be labelled for each group title (Hosts, Socker 5, Socker 4 and so on) and plotted in alignment with the data

Please see a picture of my current graph below to get a better understanding

As you can see the X axis isn't labelled

I know I can do this manually but I want it to be read from the CSV file i.e the dataframe object. I have tried different methods to do this such as trying to add the following code

dataframe.plot.bar(dataframe['Group Title'], title="Soccer", ylabel="Quantity", xlabel="Devices")

My full code is below

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



dataframe = pd.read_csv('C:\Scripts\custom.csv', delimiter=",")

print(dataframe)

dataframe.plot()

#plt.rcParams['figure.figsize'] = (15,8)
matplotlib.style.use('ggplot')

dataframe.plot.bar(title="Devices", ylabel="Quantity", xlabel="Devices")


#Show Graphs
plt.show()

Any help or guidance will be appreciated. Thank you

pandas dataframe matplotlib graph python
1 Answers

You can use seaborn's barplot:

import seaborn as sns
import matplotlib.pyplot as plt
sns.barplot(data=df)
plt.xticks(rotation=45)

seaborn barplot

Alternatively, with pandas only:

df.set_index('Group Title').T.plot.bar()

pandas barplot

user_163434640
Related