DataFrame的层次化索引访问及汇总运算

pip install pandas

Looking in indexes: https://pypi.tuna.tsinghua.edu.cn/simple/Note: you may need to restart the kernel to use updated packages.


WARNING: You are using pip version 20.0.2; however, version 20.1.1 is available.
You should consider upgrading via the 'c:\users\zcc\appdata\local\programs\python\python37\python.exe -m pip install --upgrade pip' command.



Requirement already satisfied: pandas in c:\users\zcc\appdata\local\programs\python\python37\lib\site-packages (1.0.3)
Requirement already satisfied: python-dateutil>=2.6.1 in c:\users\zcc\appdata\local\programs\python\python37\lib\site-packages (from pandas) (2.8.1)
Requirement already satisfied: numpy>=1.13.3 in c:\users\zcc\appdata\local\programs\python\python37\lib\site-packages (from pandas) (1.18.2)
Requirement already satisfied: pytz>=2017.2 in c:\users\zcc\appdata\local\programs\python\python37\lib\site-packages (from pandas) (2019.3)
Requirement already satisfied: six>=1.5 in c:\users\zcc\appdata\local\programs\python\python37\lib\site-packages (from python-dateutil>=2.6.1->pandas) (1.14.0)

import pandas as pd
from pandas import Series,DataFrame

import numpy as np
data = DataFrame(np.random.randn(6,3),index = [['a','a','b','b','c','c'],[1,2,1,2,1,2]],columns = [[