x-axis values are not ordered when plotting graphs with pandas

Question

I want to plot multiple graphs using python... but I get some issues with x-axis values that are not ordered in a correct way.

I used this code:

df=pd.read_csv('C:/Userscsv_grouped.csv',sep=';')
for col in df.columns:
    if col != 'JOUR(PSDATE)' and col != 'GNODEB':
        plt.style.use('seaborn')
        pivoted_df=df.pivot(index='JOUR(PSDATE)',columns='GNODEB', values='RACH_MSG2_SR')
        fig, ax = plt.subplots()
        pivoted_df.plot(ax=ax, kind='line', legend=True)

        ax.set_xlabel('JOUR(PSDATE)')
        ax.set_ylabel(col)
        ax.set_title(f'Evolution of {col} by GNODEB')
        plt.legend(title='GNODEB', bbox_to_anchor=(1.05, 1), loc='upper left')
        plt.show()
        break

Here is the result I get: enter image description here

Related/Duplicate

rochard4u
– rochard4u

2023-06-25 20:34:35 +00:00
Commented Jun 25, 2023 at 20:34 — rochard4u
– rochard4u, Commented Jun 25, 2023 at 20:34

Maria K · Accepted Answer · 2023-06-25 20:38:32Z

0

Right now your index is of type string - pandas doesn't know that it should be interpreted as dates. Try explicit conversion with pd.to_datetime:

df=pd.read_csv('C:/Userscsv_grouped.csv',sep=';')
for col in df.columns:
    if col != 'JOUR(PSDATE)' and col != 'GNODEB':
        plt.style.use('seaborn')
        pivoted_df=df.pivot(index='JOUR(PSDATE)',columns='GNODEB', values='RACH_MSG2_SR')
        fig, ax = plt.subplots()
        pivoted_df.index = pd.to_datetime(pivoted_df.index, format="DD/MM/YYYY")
        pivoted_df.plot(ax=ax, kind='line', legend=True)

        ax.set_xlabel('JOUR(PSDATE)')
        ax.set_ylabel(col)
        ax.set_title(f'Evolution of {col} by GNODEB')
        plt.legend(title='GNODEB', bbox_to_anchor=(1.05, 1), loc='upper left')
        plt.show()
        break

answered Jun 25, 2023 at 20:38

Maria K

2,7103 gold badges12 silver badges24 bronze badges

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

1 Comment

Rach Over a year ago

Hello Maria ...... I tried your solution and firstly get an errour of time data '01/02/2023' does not match format 'DD/MM/YYYY' then tried this format : format='%d/%m/%Y' and it worked . Thank You alooooot

Collectives™ on Stack Overflow

x-axis values are not ordered when plotting graphs with pandas

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related