Change X axis labeling using Pandas/matplotlib in Python

Question

I am plotting some columns of a csv using Pandas/Matplotlib. The index column is the time in seconds (which has very high number).
For example:

401287629.8
401287630.8
401287631.7
401287632.8
401287633.8
401287634.8

I need this to be printed as my xticklabel when i plot. But it is changing the number format as shown below:

fig

plt.figure()
ax = dfPlot.plot()
legend = ax.legend(loc='center left', bbox_to_anchor=(1,0.5))
labels = ax.get_xticklabels()
for label in labels:
    label.set_rotation(45)
    label.set_fontsize(10)

I couldn't find a way for the xticklabel to print the exact value rather than shortened version of it.

possible duplicate of How to remove relative shift in matplotlib axis — tacaswell
– tacaswell, Commented Sep 24, 2013 at 23:17

Community · Accepted Answer · 2017-05-23 12:07:02Z

2

This is essentially the same problem as How to remove relative shift in matplotlib axis

The solution is to tell the formatter to not use an offset

ax.get_xaxis().get_major_formatter().set_useOffset(False)

Also related:

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Sep 24, 2013 at 23:20

tacaswell

88.2k23 gold badges222 silver badges203 bronze badges

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

Comments

amunnelly · Accepted Answer · 2017-11-08 22:08:40Z

0

If it's not rude of me to point out, you're asking for a great deal of precision from a single chart. Your sample data shows a six-second difference over two times that are both over twelve and a half-years long.

You have to cut your cloth to your measure on this one. If you want to keep the years, you can't keep the seconds. If you want to keep the seconds, you can't have the years.

answered Nov 8, 2017 at 22:08

amunnelly

1,21614 silver badges22 bronze badges

Collectives™ on Stack Overflow

Change X axis labeling using Pandas/matplotlib in Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related