<p>可以将<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.core.groupby.GroupBy.transform.html" rel="nofollow noreferrer">^{<cd1>}</a>用于长度与<code>df</code>相同的<code>means</code>,与<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.gt.html" rel="nofollow noreferrer">^{<cd4>}</a>和上次使用<a href="http://pandas.pydata.org/pandas-docs/stable/indexing.html#boolean-indexing" rel="nofollow noreferrer">^{<cd5>}</a>进行比较:</p>
<pre><code>means = df.groupby(['Land Code','Style'])['Assessment_per_living'].transform('mean')
print (means)
0 99.796916
1 99.796916
2 99.796916
3 70.723039
4 70.723039
5 69.458255
6 69.458255
7 64.330805
8 64.330805
9 64.330805
10 54.350872
11 54.350872
12 54.350872
13 77.051350
14 77.051350
15 77.051350
16 77.051350
17 90.889237
18 90.889237
19 90.889237
Name: Assessment_per_living, dtype: float64
</code></pre>
<hr/>
<pre><code>mask = df['Assessment_per_living'].gt(means)
df = df[mask]
print (df)
Style Land Code Assessment_per_living
2 Cape 1010 109.222000
4 Colonial 1010 77.270968
5 Cape 1011 80.856481
8 Colonial 1011 67.856000
9 Colonial 1011 79.564000
11 Ranch 1011 57.810434
13 Colonial 1012 107.820248
14 Colonial 1012 84.827050
17 Ranch 1012 109.641711
</code></pre>
<p>如果只需要前2列,则为唯一对添加<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.loc.html" rel="nofollow noreferrer">^{<cd6>}</a>和<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.drop_duplicates.html" rel="nofollow noreferrer">^{<cd7>}</a>:</p>
<pre><code>mask = df['Assessment_per_living'].gt(means)
df = df.loc[mask, ['Style','Land Code']].drop_duplicates()
print (df)
Style Land Code
2 Cape 1010
4 Colonial 1010
5 Cape 1011
8 Colonial 1011
11 Ranch 1011
13 Colonial 1012
17 Ranch 1012
</code></pre>