Pandas: Timezones for PeriodIndex

[changhiskhan]

from SO: http://stackoverflow.com/questions/13030402/pandas-plot-function-ignores-timezone-of-timeseries

[changhiskhan]

xref: #2232

[amelio-vazquez-reina]

I am having the same problem here with the latest stable version of Pandas.

[jreback]

these r not supported

[vgoklani]

same issue, what's not supported?

[jreback]

Periods don't support timezone. Plotting needs to convert to a local tz before creating the periods.

[emunsing]

As a workaround, you can remove the timezone info from the DateTimeIndex of the data which you're wishing to plot using .tz_localize(None) which will preserve the values but strip the timezone information. Matplotlib/pyplot will see these naive datetime values and assume that they are UTC, and will happily plot them with working x-axis ticks.

[jreback]

going to close this issue. This add needless complication because Periods can actually fall in more than 1 tz (e.g. on a DST change), when tz's are quite well supported on DTIs / Timestamps and the conversions are pretty straightforward.

[stroobandt]

This StackExchange response leads to this issue.
Any kind of solution to this issue still seems to be appreciated.

[AvverbioPronome]

@stroobandt this is the solution I ended up using, I chose a timezone for the plot, and go with this:

import matplotlib.pytplot as plt, pandas as pd
df = pd.Dataframe(...)
fig, ax = plt.subplots()
df.plot(ax=ax)
import matplotlib.dates as mdates                                                                                   
from pytz import timezone                                                                                           
ax.xaxis.set_major_formatter(mdates.DateFormatter('%d/%m %H:%M', timezone('Europe/Amsterdam'))) 
fig.show()