怎么用python算单价和总价成什么比例_python – 从两列计算和创建百分比列

我认为你需要将字符串列转换为float或int,因为它们的类型是字符串(但看起来像数字)：

Apple_farm['Good_apples'] = Apple_farm['Good_apples'].astype(float)

Apple_farm['Total_apples'] = Apple_farm['Total_apples'].astype(float)

Apple_farm['Good_apples'] = Apple_farm['Good_apples'].astype(int)

Apple_farm['Total_apples'] = Apple_farm['Total_apples'].astype(int)

样品：

import pandas as pd

Good_apples = ["10", "20", "3", "7", "9"]

Total_apples = ["20", "80", "30", "70", "90"]

d = {"Good_apples": Good_apples, "Total_apples": Total_apples}

Apple_farm = pd.DataFrame(d)

print Apple_farm

Good_apples Total_apples

0 10 20

1 20 80

2 3 30

3 7 70

4 9 90