Adding Boolean column in pandas dataframe for Date_1 rows > Date_2 rows

Question

I have a forecast date column and a completed date column in a pandas dataframe. I want to add a column that shows if the completed date was greater than the forecast date, i.e. late/not late.

Beginner, so I've got this bit

Late_Not_Late = np.where(df["Forecast_Date"] > df("Completed_Date"], True, False)

Am struggling with the other lines I need.

You can just use `df["Late_Not_Late"] = df["Forecast_Date"] > df("Completed_Date"]`. — bb1, Dec 22 '21 at 15:22

score 0 · Answer 1 · edited Dec 22 '21 at 15:24

0

Try

df['Late_Not_Late'] = np.where(df["Forecast_Date"] > df["Completed_Date"],True,False)

edited Dec 22 '21 at 15:24

azro

47,041
7
30
65

answered Dec 22 '21 at 15:22

Anuj Sahay

1
1

score 0 · Answer 2 · edited Dec 22 '21 at 15:24

0

I think all you need is

df['Late_not_late'] = df.Forecast_Date > df.Completed_Date

edited Dec 22 '21 at 15:24

azro

47,041
7
30
65

answered Dec 22 '21 at 15:23

JoeCondron

7,936
2
24
27

Adding Boolean column in pandas dataframe for Date_1 rows > Date_2 rows

2 Answers2