Filtering dataframe based on multiple conditions using boolean logic

Question

I'm trying to filter a dataframe based on the following conditions, if end_date is Nan OR if the end_date is greater than the current date. How exactly can I do this? I'm using the following code, I am aware the | and & operators are series operators.

end_series = ((~df.end_date.notna()) | (df.end_date > datetime.datetime.utcnow().date()))
new_df = df[(df.column1 > 0)  &  end_series].copy()

YOLO · Accepted Answer · 2020-07-31 19:44:40Z

2

You can do:

current_date = pd.to_datetime("today").date()
new_df = df.query("end_date.isna() or (end_date > @current_date) and column1 > 0")

edited Jul 31, 2020 at 19:44

answered Jul 31, 2020 at 19:30

YOLO

22k5 gold badges25 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Filtering dataframe based on multiple conditions using boolean logic

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related