Mouse-over in DataFrame plot shows wrong dates

[Poquaruse]

In a new IPython Notebook session:

import pandas as pd
import numpy as np
%matplotlib
dt_rng = pd.date_range(start='2014-01-01', end='2014-01-31', freq='1min')
df = pd.DataFrame(np.random.randn(len(dt_rng)), index=dt_rng)
ax = df.plot()

The DataFrame is plotted correctly. However, a mouse-over shows wrong dates starting in the year 1970. The axis-labelling is correct.

Editing the format_coord function shows something interesting:

ax.format_coord = lambda x,y: "{} {}".format(x,y)

231422240.[....] and so on. This float value obviously isn't parsed correctly. Any ideas?

Thanks for making pandas so great and best regards!

[Poquaruse]

INSTALLED VERSIONS

commit: None
python: 3.4.1.final.0
python-bits: 64
OS: Windows
OS-release: 8
machine: AMD64
processor: Intel64 Family 6 Model 15 Stepping 13, GenuineIntel
byteorder: little
LC_ALL: None
LANG: None

pandas: 0.13.1
Cython: 0.20.1
numpy: 1.8.1
scipy: 0.14.0
statsmodels: None
IPython: 2.1.0
sphinx: 1.2.2
patsy: 0.2.1
scikits.timeseries: None
dateutil: 2.1
pytz: 2014.3
bottleneck: None
tables: 3.1.1
numexpr: 2.3.1
matplotlib: 1.3.1
openpyxl: 2.0.2
xlrd: 0.9.3
xlwt: None
xlsxwriter: 0.5.5
sqlalchemy: 0.9.4
lxml: 3.3.5
bs4: 4.3.1
html5lib: None
bq: None
apiclient: None

[jorisvandenbossche]

I think this is a duplicate of #6623 and #5453, which is fixed in 0.14 (in PR #7007). Are you able to upgrade? But thanks for the report!

[Poquaruse]

It is! Thanks for the heads up and the very fast answer. :-) I haven't tried upgrading, but

ax.format_coord = lambda x,y: "t = {} y = {}".format(pd.Period(ordinal=int(x), freq=df.index.freq),y)

as seen in the bug fix does work for me...