🎥 Challenge Chat: Testperf.csv

Helping Tanzania, United Republic of

Internships

Challenge completed over 3 years ago

Skills you will learn

Prediction

Job Opportunity

356 joined

54 active

Start

Mar 15, 22

Apr 16, 22

Reveal

Apr 16, 22

Electronics and Precision Agriculture Lab

Testperf.csv

Data · 22 Mar 2022, 07:29 · 4

The dates in this file have problems. Please rectify

Discussion 4 answers

University of dar es salaam

Which date column has a problem, and what is the problem about?

Upvotes 0

Electronics and Precision Agriculture Lab

No date type on approvedate and creationdate.

Upvotes 0

University of dar es salaam

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

train[approvedate] = pd.to_datetime(train[approvedate], errors='ignore') # fill the original input for bad data

I hope this will work

Upvotes 0

Did anyone come right with the date type on date columns (approvedate and creationdate)? it is incorrect in the file.

Upvotes 0

Join the largest network for
data scientists and AI builders