擅长:python、mysql、java
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.quantile.html" rel="noreferrer">^{<cd1>}</a>方法:</p>
<pre><code>In [48]: cols = list('abc')
In [49]: df = DataFrame(randn(10, len(cols)), columns=cols)
In [50]: df.a.quantile(0.95)
Out[50]: 1.5776961953820687
</code></pre>
<p>要筛选出<code>df</code>行,其中<code>df.a</code>大于或等于第95个百分点do:</p>
<pre><code>In [72]: df[df.a < df.a.quantile(.95)]
Out[72]:
a b c
0 -1.044 -0.247 -1.149
2 0.395 0.591 0.764
3 -0.564 -2.059 0.232
4 -0.707 -0.736 -1.345
5 0.978 -0.099 0.521
6 -0.974 0.272 -0.649
7 1.228 0.619 -0.849
8 -0.170 0.458 -0.515
9 1.465 1.019 0.966
</code></pre>