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.
Latihan ini adalah bagian dari kursus
Data Transformation with Polars
Petunjuk latihan
- Join
hotelswithtype_benchmarksontypeandbeach, keeping all rows fromhotels. - Print a few rows to see the result.
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
# Keep all rows from hotels
with_targets = hotels.____(____, on=["type", "beach"], how="____")
# Print a few rows
print(with_targets.____())