I have the following pandas dataframe at hand:
key created
0 DLAND-1957 2024-05-23 12:59:25+02:00
1 DLAND-1956 2024-05-22 13:53:09+02:00
2 DLAND-1955 2024-05-22 11:49:31+02:00
3 DLAND-1954 2024-05-22 11:48:48+02:00
there are some more columns but that does not seem to be relevant here. As you can see, the column “created” is a “timestamp”:
type(list(df.iloc[0])[1])
pandas._libs.tslibs.timestamps.Timestamp
However, when calling df.dtypes it reports type “object”:
print(df.dtypes)
key object
created object
...
Foregive me for taking the “dummy user” perspective here but python/pandas/numpy all seem to have a confusing wild jungle of potential types of representing a simple thing: a timestamp. Might it be that pandas does not understand it’s own datatype pandas._libs.tslibs.timestamps.Timestamp as timestamp?