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.

This exercise is part of the course

Data Transformation with Polars

View Course

Exercise instructions

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

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

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

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

Edit and Run Code