Python IF Statement Support

Question

I have a column with dates called "Click Date". Basically, I'm trying to write an IF statement to return IF there is a date or not in the column. IF click date contains any information, then "1" else "0".

Click Date Column example in Python/Pandas

Somehow I understood your question as "Is there any date in the whole column?". If the question is indeed that, then: `(~df["click_dt"].isna()).sum() > 0` — Maria K, Jul 18 '23 at 14:08
Welcome to Stack Overflow! Check out [ask] for tips like how to write a good title. — wjandrea, Jul 20 '23 at 15:56

score 1 · Answer 1 · answered Jul 18 '23 at 14:05

1

Take a look at the notna() method from pandas here.

In your case it should look something like this, where the boolean values are saved in a new column called valid_dates.

import pandas as pd
df['valid_dates'] = pd.notna(df['click_dates'])

answered Jul 18 '23 at 14:05

HSM

21
3

score 0 · Answer 2 · edited Jul 20 '23 at 15:52

0

If you are using numpy, you can return 0 or 1 depending if there's a date in a specific column with the following code:

import numpy as np
df["new_col"]=np.where(df["click_date"].isnull(), 0, 1)

edited Jul 20 '23 at 15:52

Broken_Window

2,037
3
21
47

answered Jul 18 '23 at 13:53

TaxpayersMoney

669
1
8
26

I think that's equivalent to `df["click_date"].isnull().astype('int')` – wjandrea Jul 20 '23 at 16:23

Python IF Statement Support

2 Answers2