CSV reader not getting column values

Question

db_path = "./db_file.csv"
db_read = open(db_path, "r") 
for row in db_read:
    g_tag = (row)[1]

My code is not accessing the second column as expected. Instead it is returning the second character of the 0th column. Don't get whats going on.

can you provide the first few lines of your csv file as an example to work with? — Kelvin
– Kelvin, Commented Dec 16, 2016 at 21:33
Give your csv data, there might be somehting worng with data. — NPatel
– NPatel, Commented Dec 16, 2016 at 21:41

Kelvin · Accepted Answer · 2016-12-16 21:35:17Z

1

Salah is right, although I'd advise against parsing a csv file directly:

In [63]: with open('output.csv', 'r') as f:
    ...:     reader = csv.reader(f)
    ...:     for row in reader:
    ...:         print row
    ...:
['latitude', 'local_time', 'longitude', 'time']
['51.2997804', '20:01:14:334 11 08 2015 +0100 GMT+01:00', '1.070336', '1439319674334']
['51.2997889', '20:01:34:428 11 08 2015 +0100 GMT+01:00', '1.0703332', '1439319694428']
['51.2997794', '20:01:54:638 11 08 2015 +0100 GMT+01:00', '1.0703123', '1439319714638']

answered Dec 16, 2016 at 21:35

Kelvin

1,3672 gold badges13 silver badges23 bronze badges

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

Comments

salah · Accepted Answer · 2016-12-16 21:34:19Z

0

you need to use the csv module to parse csv files intuitively, otherwise you can just use row.split(',') to get values

answered Dec 16, 2016 at 21:34

salah

5044 silver badges9 bronze badges

Comments

ohbrobig · Accepted Answer · 2016-12-16 21:42:49Z

0

Forgot to do this:

        db_read = open(db_path, 'r')
        db_reader = csv.reader(db_read)

answered Dec 16, 2016 at 21:42

ohbrobig

1,0063 gold badges14 silver badges40 bronze badges

1 Comment

Kelvin Over a year ago

If you are looking to follow best practice, I would very much encourage you to use a context manager (with open('your.csv', 'r') as file: ) this will close the file object for you, its a good habit to get in.

Collectives™ on Stack Overflow

CSV reader not getting column values

3 Answers 3

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Related