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

Exercise

Offensive or defensive player?

You're not convinced with your previous exploration - you've discovered patterns in the attacking and overall scores in fifa_players. You would like to compare both scores, so you would like to see both in the same DataFrame.

To do this, you'll need a way to pivot more than one column. You remember you can achieve this goal in two different ways: you could pivot the DataFrame using the list with the two columns, or you could extend the .pivot() method to all the columns present in the dataset.

The fifa_players dataset is available for you. Make sure to examine it in the console!

Instructions 1/2

undefined XP
  • 1

    Pivot fifa_players to get overall and attacking scores indexed by name, and identified by movement in the columns.

  • 2

    Use the .pivot() method on fifa_players to get all the scores indexed by name,and identified by movement in the columns.