How do I identify the blank fields in the csv file in python?

Question

I have a csv file with 5 columns:

1, 2312, "A", , 20
2, 8383, "B", "UK", 
3, 3883, , , 45

where the columns represent id, customerId, customerName, customerAddress and customerAge. I want to put 0 at the place where the age is blank and '' where the other string type attributes are blank. But I can't identify the blank field in python. I have tried doing some things like:

len(row[4]) == 0
row[4] == ''
row[4] == None
repr(row[4]) == ''

but it didn't work. What am I doing wrong?

If possible, you should put your code up here

Kien Truong
– Kien Truong

2012-09-07 15:51:06 +00:00
Commented Sep 7, 2012 at 15:51 — Kien Truong
– Kien Truong, Commented Sep 7, 2012 at 15:51

Jonathan Vanasco · Accepted Answer · 2015-12-08 17:33:13Z

3

you want to use not

0, None, False , '' are all not True

if not row[4]:

you could also do

bool(row[4])

which will return False for all the above mentioned values

edited Dec 8, 2015 at 17:33

answered Sep 7, 2012 at 14:50

Jonathan Vanasco

15.8k11 gold badges53 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I identify the blank fields in the csv file in python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related