如何加入pandas数据帧，以便seaborn boxplot或violinplot可以使用列作为色调？(How to join pandas dataframe so that seaborn boxplot or violinplot can use a column as hue?)

 我有一个包含多列的数据框，我可以轻松地使用seaborn在boxplot（或小提琴图等）中绘制它，如下所示： 
 
data1 = {'p0':[1.,2.,5,0.], 'p1':[2., 1.,1,3], 'p2':[3., 3.,2., 4.]}
df1 = pd.DataFrame.from_dict(data1)
sns.boxplot(data=df1)
 
  
 
 我现在需要的是将这个数据框与另一个数据框合并，这样我就可以在一个箱形图中绘制它们，就像在这里完成的那样： http ： //seaborn.pydata.org/examples/grouped_boxplot.html 
 
 我试过添加一个列并连接。 结果似乎没问题 
 
data1 = {'p0':[1.,2.,5,0.], 'p1':[2., 1.,1,3], 'p2':[3., 3.,2., 4.]}
data2 = {'p0':[3.,1.,5,1.], 'p1':[3., 2.,3,3], 'p2':[1., 2.,2., 5.]}
df1 = pd.DataFrame.from_dict(data1)
df1['method'] = 'A'
df2 = pd.DataFrame.from_dict(data2)
df2['method'] = 'B'
df_all = pd.concat([df1,df2])
sns.boxplot(data=df_all)
 
 这有效，但它将方法A和B中的数据汇总在一起。但是这会失败： 
 
sns.boxplot(data=df_all, hue='method')
 
 因为我需要指定x和y。 如果我将x指定为x=['p0', 'p1', 'p2'] ，则将3列进行平均。 所以我想我可以用不同的方式合并数据帧，这样它的表示就像seaborn一样简单。 

I have a dataframe with multiple columns, and I can easily use seaborn to plot it in a boxplot (or violinplot, etc), like this:
 
data1 = {'p0':[1.,2.,5,0.], 'p1':[2., 1.,1,3], 'p2':[3., 3.,2., 4.]}
df1 = pd.DataFrame.from_dict(data1)
sns.boxplot(data=df1)
 
 
What I now need is to merge this dataframe with another one, so that I can plot them in a single boxplot, just as is done here: http://seaborn.pydata.org/examples/grouped_boxplot.html
 
I have tried adding a column and concatenating. The result seems ok
 
data1 = {'p0':[1.,2.,5,0.], 'p1':[2., 1.,1,3], 'p2':[3., 3.,2., 4.]}
data2 = {'p0':[3.,1.,5,1.], 'p1':[3., 2.,3,3], 'p2':[1., 2.,2., 5.]}
df1 = pd.DataFrame.from_dict(data1)
df1['method'] = 'A'
df2 = pd.DataFrame.from_dict(data2)
df2['method'] = 'B'
df_all = pd.concat([df1,df2])
sns.boxplot(data=df_all)
 
This works, but it plots together data from methods A and B. However this fails:
 
sns.boxplot(data=df_all, hue='method')
 
because I then need to specify x and y. If I specify x as x=['p0', 'p1', 'p2'], them the 3 columns are averaged. So I guess I can merge the dataframes in a different way so that its representation is simple with seaborn.

原文：https://stackoverflow.com/questions/44162416