我有两个.csv文件,我在其中一个文件(文件a)中查找数据,并将其与另一个文件(文件b)相匹配,一旦我在b中找到合适的行,我就想写入相应行中的特定单元格。另外,我需要迭代这个过程,这样我可能会对文件b中的每一行进行多次写入。在
我可以写一个csv文件,然后一遍又一遍地读吗?在def match(name, group, cnum):
for data in masterfile_list:
if (name in data[0]):
if (group in data[4]):
if (cnum == "112"):
data[7] = cnum
elif (cnum == "111"):
data[8] = cnum
elif (cnum == "110"):
data[9] = cnum
elif (cnum == "109"):
data[10] = cnum
elif (cnum == "108"):
data[11] = cnum
elif (cnum == "107"):
data[12] = cnum
elif (cnum == "106"):
data[13] = cnum
elif (cnum == "105"):
data[14] = cnum
elif (cnum == "104"):
data[15] = cnum
elif (cnum == "103"):
data[16] = cnum
elif (cnum == "102"):
data[17] = cnum
elif (cnum == "101"):
data[18] = cnum
我最好写/替换匹配的行。在