本文介绍了pandas库中用于数据透视和交叉表分析的两个重要工具：pivot_table和crosstab。pivot_table用于创建灵活的透视表，支持多种聚合函数，可以设置填充缺失值的策略。crosstab则专注于统计分组频率，适用于快速生成交叉表格。文章通过实例详细阐述了这两个函数的使用方法和参数设置。
pandas.pivot_table 透视表##
导入数据
pandas.pivot_table(data, values=None, index=None, columns=None, aggfunc=‘mean’, fill_value=None, margins=False, dropna=True)
参数：
- data : DataFrame
- values : column to aggregate, optional
- index : a column, Grouper, array which has the same length as data, or list of them.
Keys to group by on the pivot table index. If an array is passed, it is being used as the same manner as column values. - columns : a column, Grouper, array which has the same length as data, or list of them.
Keys to group by on the pivot table column. If an array is passed, it is being used as the same manner as column values. - aggfunc : function, default numpy.mean, or list of functions
If
最低0.47元/天 解锁文章
扫一扫
327
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
