thanks for your reply
the first column is just the index i.e. row 4528
so the '2.00804E+17' must be visualized as str.
hope this helps for further investigation.
Best
4528 2.00804E+17
4529 2.00804E+17
4530 2.00804E+17
4531 2.00805E+17
Name: Payment Transaction ID, Length: 4532, dtype: object
Strangely that by asking the dtypes of the colums it is showing the correct data type ??!!
Payment Transaction ID string
MwSt float64
Zahlungsart object
Gesamt Versandkosten (inkl. MwSt.) float64
Sollkonto int32
Habenkonto int64
the first column is just the index i.e. row 4528
so the '2.00804E+17' must be visualized as str.
hope this helps for further investigation.
Best
4528 2.00804E+17
4529 2.00804E+17
4530 2.00804E+17
4531 2.00805E+17
Name: Payment Transaction ID, Length: 4532, dtype: object
Strangely that by asking the dtypes of the colums it is showing the correct data type ??!!
Payment Transaction ID string
MwSt float64
Zahlungsart object
Gesamt Versandkosten (inkl. MwSt.) float64
Sollkonto int32
Habenkonto int64