GroupBy机制
分组聚合图示
grouped操作
data
city US JP
tenor 1 3 5 1 3
0 -0.423185 0.107952 0.051819 -3.058473 -0.648571
1 0.011324 -1.096422 -0.605934 -0.049505 -0.440209
2 -0.452174 0.876530 1.895581 0.585658 -1.038866
3 -0.087396 -0.666303 0.917700 -0.560344 -0.550330
grouped = data.groupby(level='tenor')
grouped.groups : 得到分组对应的Index
grouped.groups
{1: MultiIndex(levels=[['JP', 'US'], [1, 3, 5]],
codes=[[1, 0], [0, 0]],
names=['city', 'tenor']),
3: MultiIndex(levels=[['JP', 'US'], [1, 3, 5]],
codes=[[1, 0], [1, 1]],
names=['city', 'tenor']),
5: MultiIndex(levels=[['JP', 'US'], [1, 3, 5]],
codes=[[1], [2]],
names=['city', 'tenor'])}
dict(list(grouped))[1] | grouped.get_group(1)得到某个组的数据块
grouped.get_group(1)
city US JP
tenor 1 1
0 -0.423185 -3.058473
1 0.011324 -0.049505
2 -0.452174 0.585658
3 -0.087396 -0.560344
list(grouped)
[(1, city US JP
tenor 1 1
0 -0.423185 -3.058473
1 0.011324 -0.049505
2 -0.4