Python pandas, where condition on dataframe before defining the df

Question

Is there a way to apply a where condition on the dataframe before defining it?An example:

fills_df = pd.Dataframe(api.get_fills()).where(fills_df.orderId==orderId).dropna(subset=['orderId])

How I currently write it:

fills_df=pd.DataFrame(api.get_fills())
fills_df = fills_df.where(fills_df.orderId==orderId).dropna(subset=['orderId'])

Thank you in advance!

jezrael · Accepted Answer · 2020-09-28 11:03:40Z

2

Use lambda with x instead variable name of DataFrame:

fills_df = pd.Dataframe(api.get_fills()).where(lambda x: x.orderId==orderId).dropna(subset=['orderId])

answered Sep 28, 2020 at 11:03

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Answer 1