擅长:python、mysql、java
<p>可以使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.nlargest.html" rel="nofollow noreferrer">^{<cd1>}</a>表示<strong>顶n</strong>,使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.quantile.html" rel="nofollow noreferrer">^{<cd2>}</a>表示<strong>顶m%</strong>,如下所示:</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
from io import StringIO
fastmoving = pd.read_csv(StringIO("""
dist unique id
1 0.406677 4.0 4.997434e+09
2 0.406677 4.0 4.452593e+09
5 0.406677 4.0 4.188395e+09
1 0.434386 4.0 8.288070e+09
4 0.434386 4.0 3.274609e+09"""), sep="\s+")
n = 3
m = 50
top_n_dist = fastmoving.nlargest(n, ["dist"])
top_m_precent_id_in_top_n_dist = top_n_dist[top_n_dist['id']>top_n_dist['id'].quantile(m/100)]
print(top_m_precent_id_in_top_n_dist)
</code></pre>