The function pandas.pivot_table can be used to create spreadsheet-style pivot tables. It takes a number of arguments data: A DataFrame object values: a column or a list of columns to aggregate index: a column, Grouper, array which has the same
import numpy as np import pandas as pd 认识 A pivot table is a data summarization tool(数据汇总工具) frequently found in spreadsheet programs and other data analysis software(广泛应用于数据分析中). It aggregates a table of data by one or more keys, arranging the data
Pandas is a great lib to process BIg Data. 1) pandas.pivot_table(data,values=None,columns=None,aggfunc=func) func can be any function in python 2) pandas.merge(left,right,hpw='inner') combine left with right based on the inner columns. 3) pandas.read