python遍历csv文件的每一行_Python迭代两个CSV文件中的每一行并比较时间戳值

我有以下两个CSV文件：

CSV文件1：Range1,2018-05-17 01:50:17+0000,2018-05-17 02:00:17+0000

Range2,2018-05-17 01:50:17+0000,2018-05-17 04:00:17+0000

Range3,2018-05-17 01:50:17+0000,2018-05-17 08:00:17+0000

CSV文件2：

^{pr2}$

我想遍历File1中的每个范围，并确定哪个时间戳在要比较的范围内。E、 g.我的Python脚本的输出将显示：

输出：TimeStamp1 falls within Range1

TimeStamp1, TimeStamp2 falls within Range2

TimeStamp1, TimeStamp2, TimeStamp3 falls within Range3

我开始写类似这样的东西，但是在获取输出和if语句时遇到了一些问题：最初在File1中迭代File2中的所有行，然后在File1中的下一行重复File2中的所有行。提前谢谢你。在import csv

with open('File1', 'rb') as range, open('File2', 'rb') as timeStamp:

range_reader = csv.reader(range, quotechar='"')

timeStamp_reader = csv.reader(timeStamp, quotechar='"')

for range_row in range_reader:

print range_row[2]

print range_row[3]

for timeStamp_row in timeStamp_reader:

print timeStamp_row[2]

if range_row[2] <= timeStamp_row[2] and range_row[3] >= timeStamp_row[2]

print " %s falls within %s "% (timeStamp_row[1], range_row[1])