In [63]: # Question 5 athletes =athletes .select( "Team" , "Year" , "Medal" , "Sport" , "Age") athletes .where( "Medal" ,are .not_equal_to( "nan" )) .select( "Team", "Year" ). pivot( "Team" , " Nomay 8 United States 60 40 20 920 1940 1960 1900 2000 Year