pandas pivot table index as column code example

Example 1: pivot table pandas

# Tips is the Dataframe:
# Suppose we want to compute a table of group means, we can
# use the Pivot_Table Method:

# The Pivot Table automatically computes the mean

tips.pivot_table(index=['day', 'smoker'])

# The index represents the column names that you want to form groups

Example 2: pivot table pandas

df.pivot_table(index = [df.iloc[:,meet_friends], df.iloc[:,friendsgiving]])