擅长:python、mysql、java
<p>如何创建一个新列,使用掩码来了解列的值
然后使用groupby?第一部分仍然有点荒谬,但是获得平均值的groupby更像python</p>
<pre><code>df2['qbgroup'] = ''
df2.loc[((df2['sample']=='A') | (df2['sample']=='B') | (df2['sample']=='C')), 'qbgroup'] = 'qb1'
df2.loc[((df2['sample']=='D') | (df2['sample']=='E') | (df2['sample']=='F')), 'qbgroup'] = 'qb2'
foo = df2.groupby(df2['qbgroup']).mean()
</code></pre>