TypeError:使用math.ceil时无法将序列转换为<class'float'>

Question

我有如下数据：

    order_number    ship_distance   delivery_fee    utilization remaining_multiplier_type
     R000001943        3.818           11.25            LOW            DISCOUNT
     R000002604        5.993           7.00             NaN            NaN
     R000005277        2.942           7.00             NaN            NaN
     R000006010        8.289           9.50             NaN            NaN
     R000010127        3.233           6.00             NaN            BASE

我尝试使用数学和numpy对ship_distance列中的值进行四舍五入

使用data = math.ceil(data[ship_distance']我得到了错误TypeError: cannot convert the series to <class 'float'> 当使用data = np.ceil(data['ship_distance'])时，我没有得到期望的结果

预期结果：

 order_number   ship_distance   delivery_fee    utilization   remaining_multiplier_type 
  R000001943          4            11.25             LOW           DISCOUNT                  
  R000002604          6            7.00              NaN           NaN                       
  R000005277          3            7.00              NaN           NaN                       
  R000006010          9            9.50              NaN           NaN                       
  R000010127          4            6.00              NaN           BASE                      

Answer 1

使用numpy：

np.ceil(df["ship_distance"]).astype("int64")

Answer 2

# np.ceil(data['ship_distance'])
data['ship_distance'] = data['ship_distance'].apply(lambda X: int(math.ceil(X)))

print(data)