计算数据框列中每个值的百分位数 [英] Calculate percentile for every value in a column of dataframe

问题描述

我正在尝试从DataFrame x计算列a中每个值的百分位数.

I am trying to calculate percentile for every value in column a from a DataFrame x.

是否有更好的方式编写以下代码?

Is there a better way to write the following piece of code?

x["pcta"] = [stats.percentileofscore(x["a"].values, i) 
                                    for i in x["a"].values]

我希望看到更好的性能.

I would like to see better performance.

推荐答案

您似乎想要

It seems like you want Series.rank():

x.loc[:, 'pcta'] = x.rank(pct=True) # will be in decimal form

性能:

import scipy.stats as scs

%timeit [scs.percentileofscore(x["a"].values, i) for i in x["a"].values]
1000 loops, best of 3: 877 µs per loop

%timeit x.rank(pct=True)
10000 loops, best of 3: 107 µs per loop

这篇关于计算数据框列中每个值的百分位数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！