尝试使用 python 在 csv 文件中查找空白列

Question

import csv
f = open('E:pythontestip_data.csv')
csv_f = csv.reader(f)
for row in csv_f:
    row_count = sum(1 for row in csv_f) + 1
print row_count     

现在我正在尝试查找有空格的列并对其进行计数。

Answer 1

以下情况如何：

import csv
dict_count = {}
count = 0
with open ("E:pythontestip_data.csv", 'r') as f:
 reader = csv.DictReader(f)
 data = list(reader)
 fields = reader.fieldnames
for field in range(len(fields)):
 for k,v in data[field].items():
  if v is "":
   dict_count[k] = str(count + 1)
for k,v in dict_count.items():
 print k,v