python pd pandas.cut 出现 NAN的问题

原因


pandas.cut 设置lebel的时候是(0, n] 只包含n不包含0

解决方法

重新设置一个lebel 使其包含特殊的格式

产生问题的例子

源代码

 d2 = pd.cut(DaysList,bins=[0, 1700, 1800, 1900, 2300],labels=[0, 0.25, 0.75, 1], retbins=False, duplicates='drop')

修改后代码

 d2 = pd.cut(DaysList,bins=[0, 1700, 1800, 1900, 2300, 3000],labels=[0, 0.25, 0.5, 0.75, 1], retbins=False, duplicates='drop')

原来打印的数据:

DaysList [193, 1, 1, 1, 1, 2, 1, 1, 0, 1, 1, 1, 3, 1, 5, 1, 1, 1, 1,
1, 1, 1, 0, 0, 1, 1, 91, 1, 1, 44, 21, 1, 1, 13, 1, 3, 1, 1251, 1, 1,
1458, 1, 4, 6, 2, 114, 1, 1, 3, 101, 1, 0, 34, 1, 1, 1, 1, 1, 56, 341,
1, 81, 116, 1, 10, 7, 324, 147, 302, 1, 35, 2030, 43, 347, 99, 1416,
1, 81, 17, 871, 99, 200, 3, 11, 3, 182, 1, 177, 200, 3, 3, 0, 53, 39,
80, 5, 1, 1181, 35, 81, 22, 28, 86, 47, 8, 0, 49, 3, 12, 0, 1352, 78,
3520, 92, 0, 629, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 55, 0, 11, 0, 0, 1687, 0, 0, 1, 0, 1, 1,
2, 1, 1, 0, 1, 10, 1, 3, 0, 1, 5, 1, 1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1,
1, 0, 0, 91, 0, 0, 13, 1, 0, 1, 0, 0, 1, 0, 4, 1458, 6, 2, 0, 0, 0, 0,
101, 0, 1, 1, 0, 1, 0, 0, 56, 34, 0, 0, 1, 0, 1, 0, 7, 302, 99, 147,
1, 0, 1416, 81, 0, 39, 200, 43, 182, 17, 5, 99, 200, 3, 11, 35, 1, 35,
177, 2030, 53, 3, 1, 0, 80, 22, 3, 871, 1181, 0, 81, 1, 3, 0, 8, 86,
49, 0, 0, 12, 0, 0, 78, 92, 0, 629, 0, 3520, 1, 1, 0, 1, 1, 0, 1, 0,
0, 0, 0, 0, 1, 21, 0, 0, 0, 44, 0, 0, 0, 0, 1, 0, 1, 0, 1, 3, 0, 0, 0,
0, 0, 0, 1251, 0, 0, 193, 0, 1, 0, 1, 3, 0, 1, 1, 114, 0, 0, 0, 0, 1,
1, 1, 28, 0, 0, 0, 0, 0, 341, 81, 116, 0, 0, 0, 0, 0, 0, 0, 324, 347,
55, 3, 11, 47, 0, 1687, 1352, 0, 0, 0]

Equifrequency_dispersion d2 [0.0, 0.0, 0.0, 0.0, 0.0, …, 1.0, 1.0,
NaN, NaN, NaN]

修改后打印的数据:

DaysList [193, 1, 1, 1, 1, 2, 1, 1, 4999, 1, 1, 1, 3, 1, 5, 1, 1, 1,
1, 1, 1, 1, 4999, 4999, 1, 1, 91, 1, 1, 44, 21, 1, 1, 13, 1, 3, 1,
1251, 1, 1, 1458, 1, 4, 6, 2, 114, 1, 1, 3, 101, 1, 4999, 34, 1, 1, 1,
1, 1, 56, 341, 1, 81, 116, 1, 10, 7, 324, 147, 302, 1, 35, 2030, 43,
347, 99, 1416, 1, 81, 17, 871, 99, 200, 3, 11, 3, 182, 1, 177, 200, 3,
3, 4999, 53, 39, 80, 5, 1, 1181, 35, 81, 22, 28, 86, 47, 8, 4999, 49,
3, 12, 4999, 1352, 78, 3520, 92, 4999, 629, 4999, 4999, 4999, 4999,
4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999,
4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999,
4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999,
4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999,
4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999,
4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 4999,
4999, 4999, 4999, 55, 4999, 11, 4999, 4999, 1687, 4999, 4999, 1, 4999,
1, 1, 2, 1, 1, 4999, 1, 10, 1, 3, 4999, 1, 5, 1, 1, 4999, 4999, 1, 1,
4999, 4999, 4999, 4999, 4999, 1, 1, 4999, 4999, 91, 4999, 4999, 13, 1,
4999, 1, 4999, 4999, 1, 4999, 4, 1458, 6, 2, 4999, 4999, 4999, 4999,
101, 4999, 1, 1, 4999, 1, 4999, 4999, 56, 34, 4999, 4999, 1, 4999, 1,
4999, 7, 302, 99, 147, 1, 4999, 1416, 81, 4999, 39, 200, 43, 182, 17,
5, 99, 200, 3, 11, 35, 1, 35, 177, 2030, 53, 3, 1, 4999, 80, 22, 3,
871, 1181, 4999, 81, 1, 3, 4999, 8, 86, 49, 4999, 4999, 12, 4999,
4999, 78, 92, 4999, 629, 4999, 3520, 1, 1, 4999, 1, 1, 4999, 1, 4999,
4999, 4999, 4999, 4999, 1, 21, 4999, 4999, 4999, 44, 4999, 4999, 4999,
4999, 1, 4999, 1, 4999, 1, 3, 4999, 4999, 4999, 4999, 4999, 4999,
1251, 4999, 4999, 193, 4999, 1, 4999, 1, 3, 4999, 1, 1, 114, 4999,
4999, 4999, 4999, 1, 1, 1, 28, 4999, 4999, 4999, 4999, 4999, 341, 81,
116, 4999, 4999, 4999, 4999, 4999, 4999, 4999, 324, 347, 55, 3, 11,
47, 4999, 1687, 1352, 4999, 4999, 4999] Equifrequency_dispersion d2
[0.0, 0.0, 0.0, 0.0, 0.0, …, 0.75, 0.75, 1.00, 1.00, 1.00]

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 2
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值