the latest version of pd.Timestamp issue on transforming timestamp

[foolcage]

In [1]: import pandas as pd

In [2]: pd.Timestamp.fromtimestamp(1535097720.0).timestamp()
Out[2]: 1535126520.0

the input is:1535097720.0 and the output is:1535126520.0

It seems pd.Timestamp use the local time zone to format the time and then treat it as UTC+0,but it's wrong.

in version 0.21.0, it works:

In [56]: pd.Timestamp.fromtimestamp(1535097720.0).timestamp()
Out[56]: 1535097720.0

[hanke0]

It's like pandas will automatic set timezone to your local timezone. In my location, this behave like:

In [5]: pd.Timestamp.fromtimestamp(0).timestamp()
Out[5]: 28800.0

28800 = 8 * 60 * 60, which means UTC+8. So you should do:

In [8]: pd.Timestamp.utcfromtimestamp(0).timestamp()
Out[8]: 0.0

Hoo, it works!

[foolcage]

@Ko-Han I think this is confused,timestamp should not related with timezone.

It is just:

the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC) Thursday, 1 January 1970

So we could compare the timestamp in different timezone.

And I think the behavior is right in 0.21.0

[jbrockmendel]

Duplicate of #22450.