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

Exercise

Replay that last move!

Amazing! You were able to pivot all columns of fifa_players. You saw that the overall and attacking scores are different and decided to extend your analysis to more players. However, you found an error.

You suspect that there are different scores for the same index and column values. You remember that using the .pivot() method for all the columns does not work in that case.

First, you decide to delete the problematic row so you can reshape the DataFrame afterwards.

The fifa_players dataset is available for you. Make sure you examine the dataset into the console and notice the repeated rows.

Instructions 1/2

undefined XP
  • 1
    • Drop the fifth row of the fifa_players DataFrame.
  • 2
    • Pivot fifa_no_rep to get all the scores indexed by name, and identified by movement in the columns.