Pandas学习笔记12

1、加载数据

import pandas as pd import numpy as np position = pd.read_csv('position.csv', encoding='gbk') company = pd.read_csv('company.csv', encoding='gbk')

2、数据透视表

position.pivot_table(index='city', columns='workYear', values='avg')

数据透视表，多重索引

# 数据透视表，多重索引 position.pivot_table(index=['city', 'education'], columns='workYear', values=['max', 'avg'], aggfunc=np.mean, margins=True) # position.pivot_table(index=['city', 'education'], columns='workYear', values=['max', 'avg'], aggfunc=np.mean, margins=True).loc['上海']

针对avg列求平均，读对max列计数

# 针对avg列求平均，读对max列计数 position.pivot_table(index='city', columns='workYear', values=['avg', 'max'], aggfunc={'avg': np.mean, 'max': len})