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['成都', '本科']