Pivot & Join

Being able to explode and pivot a compound field is great, but you are left with a dataframe of only those pivoted values. To really be valuable you'll need to rejoin it to the original dataset! After joining the datasets we will have a lot of NULL values for the newly created columns since we know the context of how they were created we can safely fill them in with zero as either the new has an attribute or it doesn't.

Pivot the values of ex_garage_list by grouping by the record id NO with groupBy() use the provided code to aggregate constant_val to ignore nulls and take the first value.
Left join piv_df to df using NO as the join condition.
Create the list of columns, zfill_cols, to zero fill by using the columns attribute on piv_df
Zero fill the pivoted dataframes columns, zfill_cols, by using fillna() with a subset.

Exercise

Pivot & Join

Instructions