Dribbling the pivot method
It's time to keep working with the fifa_players
dataset. After you explored the dataset, you realized the dataset contains player scores on different movements: shooting, dribbling, and passing. There are attacking scores as well as overall scores.
The goal of the project is to analyze the scores to create an optimized team, so you decide to explore which score is better. But the current data is in a long format. You'll need to to pivot your DataFrame in different ways to discover a pattern.
The fifa_players
dataset is available for you. Make sure to examine it in the console!
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.
# Pivot fifa_players to get overall scores indexed by name and identified by movement
fifa_overall = fifa_players.____(____=____, ____=____, ____=____)
# Print fifa_overall
print(fifa_overall)