You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Saving DataFrame's to HDF format is broken for the new timezone aware datetime64[ns] datatype.
See the following example:
importpandasaspdimportnumpyasnpfromdatetimeimportdatetimeprint"pandas version", pd.__version__df1=pd.DataFrame(data=np.random.randn(5,3), index=pd.DatetimeIndex(start=datetime.now(),freq='S',periods=5))
df1=df1.reset_index() #Create a column of type datetime64[ns] (timezone naiive)printdf1.info()
df1.to_hdf('df.hdf', 'data_frame') #WORKS!!!df2=pd.DataFrame(data=np.random.randn(5,3), index=pd.DatetimeIndex(start=datetime.now(),freq='S',periods=5, tz='Australia/Sydney'))
df2=df2.reset_index() #Create a column of type datetime64[ns, Australia/Sydney] (timezone AWARE)printdf2.info()
df2.to_hdf('df.hdf', 'data_frame') #BREAKS IN pandas 17.0!!!
The text was updated successfully, but these errors were encountered:
Saving DataFrame's to HDF format is broken for the new timezone aware datetime64[ns] datatype.
See the following example:
The text was updated successfully, but these errors were encountered: