# Find the total number of baby names associated with each sex for each year in the data
babynames.groupby(["Year", "Sex"])[["Count"]].agg(sum).head(6)
# The 'Pivot_table' method is used to generate a Pandas pivot table
import numpy as np
babynames.pivot_table(index = "Year", columns = "Sex", values = "Count", aggfunc = np.sum).head(5)
# This includes multiple values in the index or columns of our pivot tables
babynames_pivot = babynames.pivot_table(
index="Year",
columns="Sex",
values=["Count", "Name"],
aggfunc=max,
)
babynames_pivot.head(6)
