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.
Questo esercizio fa parte del corso
Data Transformation with Polars
Istruzioni dell'esercizio
- Match
hotelstorequestswherepriceis at or belowmax_priceANDbedroomsis at or abovemin_bedrooms. - Print a few rows to verify the tighter matches.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# 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.____())