Unnesting production_country
Back to the movie dataset from the streaming startup. This time, focus on production_country: each row holds two nested fields, a country code and a country name. Unnest the struct so those fields become regular top-level columns.
This exercise is part of the course
Scaling and Optimizing Data Pipelines with Polars
Exercise instructions
- Unnest the
production_countrystruct column so its fields become regular columns.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Flatten the struct into columns
result = movies.____("production_country").select(
"movie_title", "code", "name"
).head(8)
print(result)