导入测试数据neighborhoods.csv
观察数据,行索引是包含3列的多重索引;列索引是包含两列的多重索引。
使用read_csv()方法读取数据
import pandas as pd
neighborhoods = pd.read_csv('neighborhoods.csv',index_col=[0,1,2], header=[0,1])
选取列
# 列的第一级索引可以直接选取
neighborhoods['Culture']
# 列的第二级索引不能直接选取,需要把它之前等级的数据填写完成
# 如 neighborhoods['Museums'] 会报错
neighborhoods[('Culture','Museums')]
选取多列
# 选取多列,以下写法等效
# 建议使用写法2,可读性好
# 写法1:
neighborhoods[[('Culture','Museums'),('Services','Police')]]
# 写法2:
selected = [('Culture','Museums'),('Services','Police')]
neighborhoods[selected]
使用loc选取行
# 使用loc选取行
neighborhoods.loc['MO']