Finding Blank Columns in CSV
Jaydip Chakrabarty
chalao.adda at gmail.com
Mon Oct 5 09:29:03 EDT 2015
Hello,
I have a csv file like this.
Name,Surname,Age,Sex
abc,def,,M
,ghi,,F
jkl,mno,,
pqr,,,F
I want to find out the blank columns, that is, fields where all the
values are blank. Here is my python code.
fn = "tmp1.csv"
fin = open(fn, 'rb')
rdr = csv.DictReader(fin, delimiter=',')
data = list(rdr)
flds = rdr.fieldnames
fin.close()
mt = []
flag = 0
for i in range(len(flds)):
for row in data:
if len(row[flds[i]]):
flag = 0
break
else:
flag = 1
if flag:
mt.append(flds[i])
flag = 0
print mt
I need to know if there is better way to code this.
Thanks.
More information about the Python-list
mailing list