Quiz: Reshaping, Pivot Tables, Aggregations
Quiz yourself on reshaping, pivot tables, and aggregations.
1
Look at the given DataFrame df
:
name age rank week
0 Alice 12 3 44
1 Bob 8 4 44
2 Carl 10 5 45
3 Carl 10 2 45
4 Bob 8 5 45
We want to create a pivot table. What will be the output of following command?
pd.pivot_table(
data = df,
values = rank,
index = 'name',
columns = 'week',
aggfunc = 'sum',
margins = True,
margins_name = 'Total'
)
A)
week 44 45 Total
name
Alice 3 NaN NaN
Bob 4 5 9
Carl NaN 7 NaN
Total NaN NaN NaN
B)
week 44 45 Total
name
Alice 3 NaN 3
Bob 4 5 9
Carl NaN 7 7
Total 7 12 19
C)
week 44 45 Total
name
Alice 3 NaN 3
Bob 4 5 9
Carl NaN 7 7
D)
week 44 45
name
Alice 3 NaN
Bob 4 5
Carl NaN 7
Total 7 12
Question 1 of 50 attempted
Get hands-on with 1400+ tech skills courses.