Specifying conditional expressions with pandas dataframes

Question

I'd like to figure out how I can create a column in my dataframe based on a multiple check condition.

When I use a single conditional check this seems to work fine.

df['1/1/2017'] = np.where(df["Term 1 Start Date"] <= '1/1/2017'), 'True', 'False')

However when I introduce a second option to check upon this fails telling me that ValueError: The truth value of a Series is ambiguous.

df['1/1/2017'] = np.where(
    (df["Term 1 Start Date"] <= '1/1/2017' and df["Term 1 End Date"] > '1/1/2017'), 'True', 'False')

It should be noted that not all lines are filled in. The dates contain dates as you would expect. What can I do to have this new column populate based on two criteria?

current dataframe

Desired result

check the link stackoverflow.com/questions/21415661/…

BENY
– BENY

2017-08-24 22:22:16 +00:00
Commented Aug 24, 2017 at 22:22 — BENY
– BENY, Commented Aug 24, 2017 at 22:22

cs95 · Accepted Answer · 2017-08-24 22:07:46Z

3

You'll need the bitwise operator & instead of and. You'll also need extra sets of parentheses to handle precedence.

df['1/1/2017'] = np.where(((df["Term 1 Start Date"] <= '1/1/2017')\ 
                           & (df["Term 1 End Date"] > '1/1/2017'),\
                     'True', 'False'))

Reason being, and doesn't play nice with dataframes, but the bitwise operators &, | and ~ are all overloaded for use in conditionals.

answered Aug 24, 2017 at 22:07

cs95

406k106 gold badges744 silver badges797 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Specifying conditional expressions with pandas dataframes

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related