loan_data['mths_since_earliest_cr_line_date'] = round(pd.to_numeric(pd.to_datetime('2017-12-01')-loan_data['earliest_cr_line_date']) / np.timedelta64('1', 'M')) Error: func 'true_divide' cannot use operands with types dtype('int64') and dtype('<m8[ns]')

Hey Nishant, I believe the "pd.to_numeric()" function is the problem here, since it transforms the datetype variables into integers before dividing by another datatype variable afterwards (np.timedelta64(‘1’, ‘M’)). I suggest you add the division inside the to_numeric() and see if that solves it. loan_data['mths_since_earliest_cr_line_date'] = round(pd.to_numeric((pd.to_datetime('2017-12-01') - loan_data['earliest_cr_line_date']) / np.timedelta64('1', 'M'))) Best, 365 Vik

back

Follow this topic

nishant gaurav

Last answered:

October 23, 2020

Posted on:

October 17, 2020

Can't able to divide two data types.How to convert it into single data type

1 answers ( 0 marked as helpful)

Viktor Mehandzhiyski

Posted on:

October 23, 2020

Submit an answer

Content