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!
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 and attacking scores indexed by name and identified by movement
fifa_over_attack = fifa_players.____(____=____,
____=____,
____=[____, ____])
# Print fifa_over_attack
print(fifa_over_attack)