TypeError: unsupported operand type(s) for -: 'str' and 'str' when subtracting `datetime64[ns]` about rfm

[andreidore]

The problem is here:

code

for col in df.columns:
            if col != self.customer_id:
                df[col] = df[col].astype(str).apply(lambda x: x.strip()[:-2] if '.0' in x else x.strip())
            if 'date' in col.lower():
                df[col] = pd.to_datetime(df[col])

All of the columns that are not customer_id and do not contain "date" is transformed into a string

Only the columns that contain "date" are transformed to DateTime.

Your column that store date is called "timestamp"