Filtering with multiple conditions
Budget alone can still return unsuitable homes - a cheap studio won't work for a family needing multiple bedrooms. Tighten the match by adding a second condition: listings must also have at least as many bedrooms as the request requires.
polars is loaded as pl, and the DataFrames hotels and requests are available for you.
Deze oefening maakt deel uit van de cursus
Data Transformation with Polars
Oefeninstructies
- Match
hotelstorequestswherepriceis at or belowmax_priceANDbedroomsis at or abovemin_bedrooms. - Print a few rows to verify the tighter matches.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
# Match on budget and bedroom requirements
matches = hotels.join_where(
____,
pl.col("price") <= pl.col("____"),
pl.col("bedrooms") >= pl.col("____")
)
# Print a few rows
print(matches.____())