Python处理Excel中的日期数据

统计比第一个病人来的早而且离开的晚的病人数量

from openpyxl import load_workbook
from datetime import datetime


wb1 = load_workbook("C:/Users/zhour/Documents/patient.xlsx")
ws1 = wb1.active

patients=[]
for row in ws1.iter_rows(min_row=1):
    values = [cell.value for cell in row]
    patient={'id':values[0],'arrival':datetime.strptime(values[1],'%m/%d/%Y %H:%M'),'depart':datetime.strptime(values[2],'%m/%d/%Y %H:%M')}
    patients.append(patient)
patient1=patients[0]

count=0
for i in range(1,len(patients)):
    curPatient=patients[i]
    if curPatient['arrival'].__le__(patient1['arrival']) and curPatient['depart'].__ge__(patient1['depart']):
        count=count+1
print(count)