Pandas 3.1 filter: Selecting rows with a pd.col condition

Pandas 3.1 filter: Selecting rows with a pd.col condition

Starting with Python Pandas 3.1, use “filter” to apply a condition to rows. So:

(
  df
  .loc[ pd.col('passenger_count') > 1 , 'trip_distance']
  .mean()
)

can now be (the much slower):

(
  df
  .filter(cond=pd.col('passenger_count') > 1)
  ['trip_distance']
  .mean()
)