我正在尝试拆分一列中存在的数据并将其存储到一个新列中
**Inputdata.csv**
Braund, Mr. Owen Harris ,1
Heikkinen, Miss. Laina ,0
Allen, Mr. William Henry ,0
**Expecting_output.csv**
Braund,Owen Harris ,1,Mr
Heikkinen,Laina ,0,Miss
Allen,William Henry ,0,Mr
我已经尝试并获得了查找和替换功能,但无法对查找进行编码并将其存储到新列中
import csv
print(dir(csv))
filename = "H:\\FairDealCustomerData.csv"
csvout = "H:\\FairDealCustomerDataOUT.csv"
with open(filename,"r",newline='') as file:
file = ''.join([i for i in file]).replace("Mr.", "")
file = ''.join([i for i in file]).replace("Miss.", "")
file = ''.join([i for i in file]).replace("Mrs.", "")
with open(csvout,"w",newline='') as outfile:
outfile.writelines(file)
outfile.close()
Inputdata.csv
Braund, Mr. Owen Harris ,1
Heikkinen, Miss. Laina ,0
Allen, Mr. William Henry ,0
Expecting_output.csv
Braund,Owen Harris ,1,Mr
Heikkinen,Laina ,0,Miss
Allen,William Henry ,0,Mr
试试这个,输出和你期望的一样。
import csv
filename = "H:\\FairDealCustomerData.csv"
csvout = "H:\\FairDealCustomerDataOUT.csv"
with open(filename, 'r', newline='') as read_file:
readCSV = csv.reader(read_file, delimiter=',')
with open(csvout, 'w', newline='') as write_file:
writer = csv.writer(write_file)
for row in readCSV:
writer.writerow([row[0], row[1].split('.')[1].strip() + ' ', row[2], row[1].split('.')[0].strip()])
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句