Reviewing the moves
Wow! You have now learned about pivot tables. In the last analysis that you did, you encountered a DataFrame that had non-unique index/column pairs. In order to pivot your DataFrame, you wrote code to drop the last row, and then reshaped it.
In this exercise, you will modify the code using pivot tables and compare it with your strategy of using the pivot method.
The fifa_players
dataset is available for you.
This exercise is part of the course
Reshaping Data with pandas
Exercise instructions
- Discard the fifth row of the
fifa_players
DataFrame. - Use
.pivot()
onfifa_players
to get all the scores indexed byname
, and identified bymovement
in the columns. - Use a pivot table to show the mean of all scores by
name
andmovement
, settingname
as index.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Discard the fifth row to delete all repeated rows
fifa_drop = fifa_players.____(____)
# Use pivot method to get all scores by name and movement
fifa_pivot = fifa_drop.____(____)
# Print fifa_pivot
print(fifa_pivot)
# Use pivot table to get all scores by name and movement
fifa_pivot_table = fifa_players.____(index=____,
columns=____,
aggfunc=____)
# Print fifa_pivot_table
print(fifa_pivot_table)