循环浏览一个csv文件的行以在另一个csv文件中查找对应的数据

循环浏览一个csv文件的行以在另一个csv文件中查找对应的数据

如果没有重复的

DTime

值，这应该可以工作：

import csvfile1reader = csv.reader(open("file1.csv"), delimiter=",")file2reader = csv.reader(open("file2.csv"), delimiter=",")header1 = file1reader.next() #headerheader2 = file2reader.next() #headerfor 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 csvfrom datetime import datetimefile1reader = csv.reader(open("file1.csv"), delimiter=",")file2reader = csv.reader(open("file2.csv"), delimiter=",")header1 = file1reader.next() #headerheader2 = file2reader.next() #headerfor Code, DTime in file1reader:    DTime = datetime.strptime(DTime, "%Y-%m-%d %H:%M")    for id_, D, Sym, DateTime, Bid, Ask in file2reader:        DateTime = datetime.strptime(DateTime, "%Y-%m-%d %H:%M:%S")        if DateTime>=DTime: # found it print DateTime, Bid, Ask   # output data break# break and continue where we left next time