pandas qcut error:duplicate bins

当遇到pandas qcut的'ValueError: Bin edges must be unique'错误时,可以尝试降低分位数或者使用DataFrame.rank()方法进行数据排名。此外,可以使用自定义的分位数范围,例如[0, .50, .75, 1.]。pandas.cut和pandas.qcut的区别在于:cut根据值本身均匀划分bins,而qcut确保每个bin内的记录数量相等。" 127092780,15043614,C++中cin、cin.getline()与getline()的区别解析,"['C++', '开发语言', '输入输出']

fix unique bin error:

  1. duplicates='drop'

  2. decrease quantiles

  3. Rank your data with DataFrame.rank(method=‘first’). The ranking assigns a unique value to each element in the dataframe (the rank) while keeping the order of the elements (except for identical values, which will be ranked in order they appear in the array, see method=‘first’)
    Example:
    pd.qcut(df, nbins) <-- this generates “ValueError: Bin edges must be unique”
    Then use this instead:
    pd.qcut(df.rank(method='first'), nbins)

  4. Specify a custom quantiles range, e.g. [0, .50, .75, 1.] to get unequal number of items per quantile

  5. Use pandas.cut that chooses the bins to be evenly spaced according to the values themselves, while pandas.qcut chooses the bins so that you have the same number of records in each bin

Difference between qcut and cut
qcut: 保证每组数量平均
cut: 按照组内values来分,组内不一定平均

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值