Python strptime missing some milliseconds when running script in different computer

Question

I am formatting pandas dataframe timestamp column to unix timestamp as follows

from datetime import datetime

df["col_in_unix"] = df["example_col"].\
                        apply(lambda x: datetime.strptime(x, '%Y-%m-%d %H:%M:%S.%f').timestamp())

And when running this on my computer I get from a timestamp

datetime.strptime("2020-12-09 13:27:48.172793", '%Y-%m-%d %H:%M:%S.%f').timestamp()

1607513268.172793

but when I run the code in different windows pc I sometimes get answer

1607513268.17

And this happens to all timestamps in the dataframe column, what gives? I have also made .exe file from the script with Pyinstaller and still the same problem

To make sure this is not a formatting issue, pease set decimal places to print explicitly, e.g. `print( f"{v:.6f}" )` with v being your value. — FObersteiner, Dec 17 '20 at 06:27
After I printed the value as @MrFuppes suggested, I noticed that the source of the timestamps sometimes had dropped resolution in milliseconds — eemilk, Dec 18 '20 at 06:02

score 1 · Accepted Answer · answered Dec 17 '20 at 06:09

1

I am wondering if this is not related to either:

Differences in system time resolution due to different hardware / drivers, etc.
precision setting for pandas and/or the dataframe
Similar issue described for Windows 32b vs. 64b in C# (you are likely to observe a similar problem between 32b and 64b versions of Python).
Some other factor

answered Dec 17 '20 at 06:09

sophros

14,672
11
46
75

1

Thanks for the input, it was unrelated issue to my script. Apparently where I fetch the data had problems and is now fixed :) – eemilk Dec 18 '20 at 06:00
Do you mean different "disk speeds" so that the data reading took different times? – sophros Dec 18 '20 at 06:12

Python strptime missing some milliseconds when running script in different computer

1 Answers1