python忽略空单元格_Python忽略len（）中的空单元格csv.DictRead

所以我决定将dict的值加载到list，然后count len()。基于此，使用适当的if语句来完成工作。在with open (baseline, 'r') as baselineF:

readBaseline=csv.DictReader(baselineF,delimiter=',', quotechar='"')

for rowb in readBaseline:

with open (tested, 'r') as testedF:

readTested=csv.DictReader(testedF, delimiter=',', quotechar='"')

for rowt in readTested:

if rowt['key'] == rowb['key']:

for value in rowb.values():

list1.append(value)

cleaned1 = [x for x in list1 if x != None]

list1=[]

for value in rowt.values():

list2.append(value)

cleaned2 = [x for x in list2 if x != None]

list1=[]

#rowb baseline

#rowt tested

#Rows are the same len

if len(cleaned1)==len(cleaned2):

writerSameOracle.writerow(rowb)

writerSameHPCC.writerow(rowt)

print ('Rows are the same)

break