I seem to have a problem when updating my Dataframe table using this
Table.update(other)
'Table' and 'other' have the exact same column labels. it used to work just fine, but now it started showing this for example:
2021-04-12T00:00:00.000000000 <class 'numpy.datetime64'>
1618185600000000000 <class 'int'>
the first result is taken from "other" and after update, it becomes int as seen above.
These are the results of Table.dtypes:
ID object
Column1 object
Column2 object
Column3 object
Column4 object
Column5 object
Column6 object
Column7 object
dtype: object
And the results of other.dtypes
ID object
Column1 float64
Column2 datetime64[ns]
Column3 datetime64[ns]
Column4 float64
Column5 datetime64[ns]
Column6 datetime64[ns]
Column7 object
dtype: object