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.

Deze oefening maakt deel uit van de cursus

Data Transformation with Polars

Cursus bekijken

Oefeninstructies

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

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

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

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

Code bewerken en uitvoeren