类型错误：使用 math.ceil 时无法将系列转换为<类"浮点数">

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

我正在尝试使用math和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)