python遍历csv文件匹配_python – 循环遍历一个csv文件的行,以在另一个csv文件中查找相应的数据...

如果您没有重复的DTime值,这应该工作：

import csv

file1reader = csv.reader(open("file1.csv"), delimiter=",")

file2reader = csv.reader(open("file2.csv"), delimiter=",")

header1 = file1reader.next() #header

header2 = file2reader.next() #header

for Code, DTime in file1reader:

for id_, D, Sym, DateTime, Bid, Ask in file2reader:

if DateTime.startswith(DTime): # found it

print DateTime, Bid, Ask # output data

break # break and continue where we left next time

编辑

import csv

from datetime import datetime

file1reader = csv.reader(open("file1.csv"), delimiter=",")

file2reader = csv.reader(open("file2.csv"), delimiter=",")

header1 = file1reader.next() #header

header2 = file2reader.next() #header

for Cod