python如何实现excel的“透视”功能?
--调整“groupby的聚合结果剔除了空值,因此更类似于excel“透视”的功能”的说法:
#载入包与数据
import numpy as np
import seaborn as sns
tips = sns.load_dataset("tips")
#方法一:pivot_table+dropna()+reset_index()
a=tips.pivot_table(index=['time','day','sex','smoker'],values=['total_bill','tip'],aggfunc=np.sum).dropna()
a.reset_index(inplace=True)
a.shape
a
#方法二:groupby+dropna()+reset_index()
b=tips.groupby(['time','day','sex','smoker'])['total_bill','tip'].sum().dropna()
b.reset_index(inplace=True)
b.shape
b
learning: