python读取csv文件修改

Question

如下有一个excel文件，在python中读取文件。
得到一列 Profitability, % =（Cost - Paid）*100 / Cost 的百分比结果
最后输出一个新excel 里面包含 ‘TransactionID’，‘Date’，‘Count’，‘Bad testimonial’，‘Profitability’

---

TransactionID Date Count Cost Delivery Bad testimonial Paid
1 2020-Aug-21 8:53:03 67 6325 0 0 2605
2 2019-Sep-3 11:53:03 90 8307 1 1 8553
3 2019-Oct-15 4:31:02 59 9819 0 1 9995
4 2019-Aug-26 4:14:00 14 5351 1 1 12603
5 2020-Aug-27 1:21:03 14 7779 1 0 5625
6 2020-Aug-19 16:41:01 51 6595 1 1 9191
7 2019-Aug-26 18:49:04 9 6764 1 1 13167
8 2020-Aug-23 13:34:03 45 6381 0 0 6251

Answer 1

import pandas as pd
csvobj=pd.read_csv('1.csv')
Profitability=[]
Cost=list(csvobj["Cost"])
Paid=list(csvobj["Paid"])
for i in range(len(Cost)):
    Profitability.append(f"{(Cost[i]-Paid[i])*100/Cost[i]}%")
csvobj.loc[:,'Profitability']=Profitability
csvobj.to_csv('2.csv')

有帮助请点一下右上角的采纳,谢谢