import pandas as pd orders = pd.DataFrame( { "order_id": [1041, 1042, 1043, 1044, 1045, 1046], "region": ["EMEA", "APAC", "AMER", "EMEA", "APAC", "AMER"], "quantity": [4, 12, 8, 15, 18, 11], "status": ["open", "open", "open", "paid", "open", "open"], } ) eligible_regions = ["EMEA", "APAC"] priority_mask = ( orders["region"].isin(eligible_regions) & (orders["quantity"] >= 10) & (orders["status"] == "open") ) priority_orders = orders.loc[ priority_mask, ["order_id", "region", "quantity", "status"], ] assert priority_orders.index.tolist() == [1, 4] assert priority_orders["region"].isin(eligible_regions).all() assert priority_orders["quantity"].ge(10).all() assert priority_orders["status"].eq("open").all() print(priority_orders.to_string())