Loan Default Prediction Challenge
Helping Tanzania, United Republic of
Internships
Completed (over 4 years ago)
Prediction
Job Opportunity
404 joined
54 active
Start
15 Mar 22
Close
16 Apr 22
Reveal
16 Apr 22
Testperf.csv
Data · 22 Mar 2022, 07:29 · 4
The dates in this file have problems. Please rectify
Which date column has a problem, and what is the problem about?
No date type on approvedate and creationdate.
Yes, but after importing the files, you have to change approvedate and creationdate columns to date datatype
train[approvedate] = pd.to_datetime(train[approvedate], errors='coerce') # fill NaN for bad data
OR
train[approvedate] = pd.to_datetime(train[approvedate], errors='ignore') # fill the original input for bad data
I hope this will work
Did anyone come right with the date type on date columns (approvedate and creationdate)? it is incorrect in the file.