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