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.
Diese Übung ist Teil des Kurses
Data Transformation with Polars
Anleitung zur Übung
- Join
hotelswithtype_benchmarksontypeandbeach, keeping all rows fromhotels. - Print a few rows to see the result.
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
# Keep all rows from hotels
with_targets = hotels.____(____, on=["type", "beach"], how="____")
# Print a few rows
print(with_targets.____())