我有以下python代码。我想比较两个csv文件,但是我只想比较第二个csv文件中的两列。你知道吗
如何扩展下面的代码以只针对productsell文件中的'ID'和'Name'列?你知道吗
import ctypes # An included library with Python install.
def Mbox(title, text, style):
return ctypes.windll.user32.MessageBoxW(0, text, title, style)
try:
with open('pipeNew2.csv', 'r') as t1, open('productsOld.csv', 'r') as t2:
fileone = t1.readlines()
filetwo = t2.readlines()
with open('update.csv', 'w') as outFile:
for line in filetwo:
if line not in fileone:
outFile.write(line)
Mbox('Complete', 'Compairson Complete', 0)
except (ValueError,IOError) as err:
Mbox('Error',(str(err)),0)
我试过的只是把所有的文件打印出来,放在同一行
import ctypes # An included library with Python install.
import csv
def Mbox(title, text, style):
return ctypes.windll.user32.MessageBoxW(0, text, title, style)
try:
with open('pipeNew2.csv', 'r') as t1, open('productsOld.csv', 'r') as t2:
fileone = t1.readlines()
filetwo = t2.readlines()
with open('update.csv', 'w') as outFile:
newFile = csv.DictReader(filetwo)
for row in newFile:
if row['id'] not in fileone:
outFile.write(str(row))
Mbox('Complete', 'Compairson Complete', 0)
except (ValueError,IOError) as err:
Mbox('Error',(str(err)),0)
看看csv内置模块。你知道吗
示例:
你知道吗产品销售.csv你知道吗
管道新2.csv
你知道吗更新.csv你知道吗
相关问题 更多 >
编程相关推荐