[已解决]两列相除的问题，求大师帮忙，谢谢

isdkz

您好！首先，我需要您先导入Pandas库。接着，我们可以使用pd.to_numeric()函数将这两列转换为数字，然后相除以创建新列"AB"。以下是您需要的代码：

1. import pandas as pd
   
2. 
   
3. data =[["2345","A","2022-12-20","2.1016","-0.72","-0.77"],["004243","C","2022-12-15","2.0891","","-0.77"],
   
4. ["519212","B","2022-12-10","","1.9733","-0.77","-3.29"],["162411","E","2022-12-9","0.7071","-1.64","-1.46"],
   
5. ["007844","FC","2022-11-19","0.6967",None,"-1.46"],["163208","G","2022-11-10","1.0440","-0.40","-0.40"]]
   
6. columns = ["编号","名称","日期","AA","BB","C","数值88"]
   
7. df2 = pd.DataFrame(data, columns=columns)
   
8. print(df2)
   
9. 
   
10. # 将'AA'和'BB'两列转换为数字类型，并将无法转换的值替换为NaN
    
11. df2['AA'] = pd.to_numeric(df2['AA'], errors='coerce')
    
12. df2['BB'] = pd.to_numeric(df2['BB'], errors='coerce')
    
13. 
    
14. # 计算新列'AB'
    
15. df2['AB'] = df2['AA'] / df2['BB']
    
16. print(df2)
    

复制代码

运行上述代码后，您将得到包含新列"AB"的DataFrame。"AB"列的值为"AA"列除以"BB"列的值，非数字的值将转换为NaN。