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

<Kurs>Data Transformation with Polars</Kurs>

Kurs ansehen

Übungsanweisungen

Join hotels with type_benchmarks on type and beach, keeping all rows from hotels.
Print a few rows to see the result.

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

# Keep all rows from hotels
with_targets = hotels.____(____, on=["type", "beach"], how="____")

# Print a few rows
print(with_targets.____())

Code bearbeiten und ausführen