Pandas学习笔记07_多重索引

1、加载数据

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

2、多重索引

position.groupby(['city', 'education']).mean()

# .avg 转换成series，才可以针对性的查询
position.groupby(['city', 'education']).mean().avg['成都']['本科']

# 借助loc
position.groupby(['city', 'education']).mean().loc['成都']

position.groupby(['city', 'education']).mean().loc['成都', '本科']