I have a timezone aware TimeSeries in pandas 0.10.1. I want to export to Excel, but the timezone prevents the date from being recognized as a date in Excel.
In [40]: resultado
Out[40]:
fecha_hora
2013-04-11 13:00:00+02:00 31475.568
2013-04-11 14:00:00+02:00 37263.072
2013-04-11 15:00:00+02:00 35979.434
2013-04-11 16:00:00+02:00 35132.890
2013-04-11 17:00:00+02:00 36356.584
If I strip the tzinfo with .tz_convert(None)
, the date gets converted to UTC:
In [41]: resultado.tz_convert(None)
Out[41]:
fecha_hora
2013-04-11 11:00:00 31475.568
2013-04-11 12:00:00 37263.072
2013-04-11 13:00:00 35979.434
2013-04-11 14:00:00 35132.890
2013-04-11 15:00:00 36356.584
Is there a TimeSeries method to apply .replace(tzinfo=None)
to each date in the index?
Alternativelly, is there a way to properly export time-aware TimeSeries to Excel?