擅长:python、mysql、java
<p>可以使用groupby,然后使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.mode.html" rel="nofollow noreferrer">pd.Series.mode</a>:</p>
<pre><code>def filt(x):
return x.iat[0] if len(x.mode())>1 else x.mode()
df.groupby(['fName', 'lName'], as_index=False).agg({'smokes': filt, 'eye_color': 'first'})
fName lName smokes eye_color
0 Bob McCain 1 black
1 John Madden 1 green
2 Ryan Diedre 0 brown
</code></pre>
<p><code>pd.Series.mode</code>返回最频繁的值</p>