python3 csv模块_如何在python3.x csv模块功能中将数据拆分为一列并将值存储在新列中...

我正在尝试分割一列中存在的数据并将其存储到一个新的列中。

**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