Format X-axis in pandas and matplotlib

Question

As you know by checking image below, X-axis contains hour, minute, second

I want to remove hour, minute, second in X-axis

How can I solve this problem?

df = pd.read_csv('./new_df2_count_per_date_{0}.csv'.format(str_day))
    df['Total_date'] = pd.to_datetime(df['Total_date'])
    df = df.set_index('Total_date')
    ax = df.plot.bar()
    ax.xaxis.set_major_formatter(mdates.DateFormatter('%Y-%m-%d'))
    plt.xlabel("Date")
    plt.ylabel("Count")
    plt.show()

enter image description here

jezrael · Accepted Answer · 2020-08-14 05:01:21Z

1

You can change index values in pandas side by convert datetimes to strigs in format YYYY-MM-DD:

ax = df.plot.bar()
ax.xaxis.set_major_formatter(mdates.DateFormatter('%Y-%m-%d'))

to:

ax = df.set_index(df.index.strftime('%Y-%m-%d')).plot.bar()

answered Aug 14, 2020 at 5:01

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Format X-axis in pandas and matplotlib

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related