Preserving all listings
Sometimes reference data is incomplete, but you still need every listing for reporting. You want to keep all rows from hotels even when there's no matching benchmark - missing values should appear as null.
polars is loaded as pl, and the DataFrames hotels and type_benchmarks are available for you.
Questo esercizio fa parte del corso
Data Transformation with Polars
Istruzioni dell'esercizio
- Join
hotelswithtype_benchmarksontypeandbeach, keeping all rows fromhotels. - Print a few rows to see the result.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# Keep all rows from hotels
with_targets = hotels.____(____, on=["type", "beach"], how="____")
# Print a few rows
print(with_targets.____())