python pandas 绘图_python – pandas – 多索引绘图

我有一些数据,我使用以下代码操作数据帧：

import pandas as pd

import numpy as np

data = pd.DataFrame([[0,0,0,3,6,5,6,1],[1,1,1,3,4,5,2,0],[2,1,0,3,6,5,6,1],[3,0,0,2,9,4,2,1],[4,0,1,3,4,8,1,1],[5,1,1,3,3,5,9,1],[6,1,0,3,3,5,6,1],[7,0,1,3,4,8,9,1]], columns=["id", "sex", "split", "group0Low", "group0High", "group1Low", "group1High", "trim"])

data

#remove all where trim == 0

trimmed = data[(data.trim == 1)]

trimmed

#create df with columns to be split

columns = ['group0Low', 'group0High', 'group1Low', 'group1High']

to_split = trimmed[columns]

to_split

level_group = np.where(to_split.columns.str.contains('0'), 0, 1)

# output: array([0, 0, 1, 1])

level_low_high = np.where(to_split.columns.str.contains('Low'), 'low', 'high')

# output: array(['low', 'high', 'low', 'high'], dtype='

multi_level_columns = pd.MultiIndex.from_arrays([level_group, level_low_high], names=['group', 'val'])

to_split.columns = multi_level_columns

to_split.stack(level='group')

sex = trimmed['sex']

split = trimmed['split']

horizontalStack = pd.concat([sex, split, to_split], axis=1)

horizontalStack

finalData = horizontalStack.groupby(['split', 'sex', 'group'])

finalData.mean()

我的问题是,如何使用ggplot或seaborn绘制平均数据,以便对于每个“分裂”级别,我得到一个如下所示的图形：

在代码的底部你可以看到我试图分割组因子,所以我可以分隔条,但这导致错误(KeyError：’group’)我认为这与我使用的方式有关多索引