Resolved: Practice Exam 1- Q3- Can you please provide formula to exact dates before subtracting??

I tried some ineffective code solution but gave back error:

date1info = str( pd.read_csv('Lending-company-mod-exam.csv', index_col = 'LoanID', skiprows = 6))

I noticed i highlighted by mistake row 1 and 3 cell, while its 1 and 4 in the exercise. Sorry for the mistake. But logic remains the same in  the solution.

Hi Panagiotis!

Thanks for reaching out!

Could please you clarify your exact intention? Are you aiming to construct a new DataFrame that only includes rows associated with the two specific dates you mentioned?

Looking forward to your answer.

Best,

Ivan

Yes sir. Thanks for the rephrasing.

Thanks teacher. To be precise what worked for us here was turn the row into the proper format:

 df = pd.DataFrame(data)

df['StartDate'] = pd.to_datetime(df['StartDate'], format="%d/%m/%Y")

Then select the specific rows:

selected_rows = df.iloc[[0, 3], 5] which will pick the 6th value (the dates), from rows 1 and 4. 

and finally store the values in two variables and calculate their difference:

date_1=  selected_rows[1]

print(date_1)

date_2 = selected_rows[4]

print(date_2)

and:

dif_days = date_1 - date_2

print(dif_days)

which gives us the 633 days.

Only reason i wanted to try this verbose overcomplicated solution was not to trouble with your and my precious time, but experiment with if it was possible for the user to not explicitely type the dates himself, but rather cold extract them from the table to avoid mistakes. i hope the scope of this exploration makes a bit sense.