1. Learn
    2. /
  2. Courses
    3. /
  3. Reshaping Data with pandas

Exercise

The tallest and the heaviest

You will continue your exploration of characteristics of players in fifa_players belonging to two teams: FC Barcelona and Real Madrid. As your last task, you are interested in exploring the maximum height and weight separated by teams and nationality. You will also compare two years, 2000 and 2010.

You have two columns that you want to set as an index, so you will need to use pivot_table().

The fifa_players dataset is available for you. It contains data about the club, nationality, height, weight, and year of the players playing for each team.

Instructions 1/3

undefined XP
    1
    2
    3
  • Use a pivot table to get all the values in the year column of the fifa_players DataFrame, setting nationality and club as index.