python-3.x - 如何计算熊猫列中非空元素的数量？

Question

如何获取熊猫列中非空元素的总数？

print(len(newDF.Paid_Off_In_Days).where(newDF.Paid_Off_In_Days != ''))

数据类型是int 我得到错误：

AttributeError：“int”对象没有属性“where”

  Paid_Off_In_Days        Credit_Amount
     1                       150
     15                      500
                             80
     18                      90
                             1200
     29                      600
     

标签： python-3.xpandas

Answer 1

如果空意味着空字符串比较掩码并sum用于计True数值：

print((newDF.Paid_Off_In_Days != '').sum())

如果空意味着缺失值，请使用Series.count：

print (newDF)
   Paid_Off_In_Days  col
0               1.0    a
1              15.0    s
2               NaN    d
3              18.0  NaN
4               NaN    f
5              29.0  NaN

print(newDF.Paid_Off_In_Days.count())
4