9

I created a chart in matplotlib using python and the x-axis is the days of the week (Mon-Sun). When the data was plotted though, the x-axis is not arranged Mon-Sun.

Is there way I can re-order the x-axis to have it be formatted this way?

or is there a way I can re-order the dataset? It is a csv file that is being read using the panda dataframe

Example Data: (lives in csv: './data/Days_Summary.csv')

Day         Value

 Monday      56        
 Tuesday     23    
 Wednesday   34     
 Thursday     56     
  Friday      58     
 Saturday     70      
  Sunday      43

Code:

import matplotlib.pyplot as plt
import numpy as np
import pandas as pd
df=pd.read_csv('./data/Days_Summary.csv')
days_values=df.groupby(['day'])['day'].count().plot(kind='bar')
plt.xlabel('Day')
plt.ylabel('Values')
plt.show()
andrew_reece
  • 20,390
  • 3
  • 33
  • 58
user8659376
  • 369
  • 4
  • 8
  • 19

2 Answers2

13

Use .loc to set the day order:

field = "Day"
day_order = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"]
ax = df.set_index(field).loc[day_order].plot(kind="bar", legend=False)
ax.set_ylabel("Value")

plot

Note: Using groupby() and count() will not give you the values in the Value field, but will instead count the number of rows in each group. In this case, you'll just get a count of 1 for each day. Hence this answer assumes that you actually want to plot the values in Value for each day.

andrew_reece
  • 20,390
  • 3
  • 33
  • 58
3

For application on Seaborn. You can do this using count plot https://seaborn.pydata.org/generated/seaborn.countplot.html

day_order = ["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"]
sns.countplot(x = "Day", data = df, order = day_order)
Dharman
  • 30,962
  • 25
  • 85
  • 135
AKP
  • 89
  • 1
  • 1
  • 14