当前位置：首页 > news >正文

搜索替换 csv 文件中的文本

news 来源：原创 2024/5/19 6:14:05

【问题】

I just started with Python 3.4.2 and trying to find and replace text in csv file.

In Details,Input.csvfile contain below line:

0,0,0,13,.\New\_Path-1.1.12\Impl\Appli\Library\Module_RM\Code\src\Exception.cpp
0,0,0,98,.\Old_Path-1.1.12\Impl\Appli\Library\Prof_bus\Code\src\Wrapper.cpp
0,0,0,26,.\New_Path-1.1.12\Impl\Support\Custom\Vital\Code\src\Interface.cpp
0,0,0,114,.\Old_Path-1.1.12\Impl\Support\Custom\Cust\Code\src\Config.cpp

I maintained my strings to be searched in other file namedlist.csv

Module_RM
Prof_bus
Vital
Cust

Now I need to go through each line ofInput.csvand replace the last column with the matched string.

So my end result should be like this:

0,0,0,13,Module_RM
0,0,0,98,Prof_bus
0,0,0,26,Vital
0,0,0,114,Cust

I read the input files first line as a list. So text which i need to replace came inline[4]. I am reading each module name in thelist.csvfile and checking if there is any match of text inline[4]. I am not able to make thatifconditiontrue. Please let me know if it is not a proper search.

import csv
import re
with open("D:\\My_Python\\New_Python_Test\\Input.csv") as source, open("D:\\My\_Python\\\New_Python_Test\\List.csv") as module_names, open("D:\\My_Python\\New_Python_Test\\Final_File.csv","w",newline="") as result:
reader=csv.reader(source)
module=csv.reader(module_names)
writer=csv.writer(result)
#lines=source.readlines()
for line in reader:
for mod in module_names:
 if any(\[mod in s for s in line\]):
 line.replace(reader\[4\],mod)
 print ("YES")
 writer.writerow("OUT")
 print (mod)
module_names.seek(0)
lines=reader

Please guide me to complete this task.

Thanks for your support!

楼主自己解答了：

import csv
with open("D:\\My_Python\\New_Python_Test\\Input.csv") as source, open("D:\\My_Python\\New_Python_Test\\List.csv") as module_names, open("D:\\My_Python\\New_Python_Test\\Final_File.csv","w",newline="") as result:
 reader=csv.reader(source)
 module=csv.reader(module_names)
 writer=csv.writer(result)
 flag=False
 for row in reader:
 i=row[4]
 for s in module_names:
 k=s.strip()
 if i.find(k)!=-1 and flag==False:
 row[4]=k
 writer.writerow(row)
 flag=True
 module_names.seek(0)
 flag=False

【回答】

文本的结构化计算用集算器做会更独立些，不用写循环，SPL 脚本如下：