擅长:python、mysql、java
<p>试试这个:</p>
<pre><code>import pandas as pd
x = pd.DataFrame({'Location': ['Chicago','Houston','Los Angeles','Boston','NYC','Seattle'],
'Dir': ['H1','H2','H2','H1','H2','H1'],
'Set': [4,4,4,0,0,0],
'SetCopy': [4,4,4,0,0,0]})
mean = x.groupby(['Set','Dir']).mean()
sd = x.groupby(['Set','Dir']).std()
</code></pre>
<p><strong>根据评论编辑:</strong></p>
<pre><code>import pandas as pd
import numpy as np
import itertools
x = pd.DataFrame({'Location': ['Chicago','Houston','Los Angeles','Boston','NYC','Seattle'],
'Dir': ['H1','H2','H2','H1','H2','H1'],
'Set': [4,4,4,0,0,0],
'H1': [[4,8,10],[8,4,12],[6,9,5],[6,7,9],[0,0,0],[0,0,0]]})
mean = x.groupby(['Set','Dir']).H1.apply(
lambda x: list(x)).apply(
lambda x: np.mean(list(itertools.chain.from_iterable(x))))
sd = x.groupby(['Set','Dir']).H1.apply(
lambda x: list(x)).apply(
lambda x: np.std(list(itertools.chain.from_iterable(x))))
</code></pre>