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.
This exercise is part of the course
Reshaping Data with pandas
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Drop the fifth row to delete all repeated rows
fifa_no_rep = fifa_players.____(____, ____)
# Print fifa_pivot
print(fifa_no_rep)