How to get csv rows as array with Python csv?

Question

I have an csv file that looks like

a
b
c
d
e

and a code that looks like

import csv
def func():
    with open('zumatchende.csv', mode='r') as csv_datei:
        csv_datei=csv.DictReader(csv_datei, delimiter=";", dialect="excel")
        for row in csv_datei:
            print(row)



func()

i would have expected an output like

['a']
['b']
['c']
['d']
['e']

but i get

{'a':'b'}
{'a':'c'}
{'a':'d'}
{'a':'e'}

i used this often times before and i always got the row back as an array with each element of the row as one element of the array. I dont understand why this is now formated in another data type and even puts together 2 lines into one. How can i fix this? Or what am I doing wrong? The code that i used in other places which works fine looks the same, exept the file name.

see here: stackoverflow.com/a/3387212/499721

bavaza
– bavaza

2022-09-20 12:25:46 +00:00
Commented Sep 20, 2022 at 12:25 — bavaza
– bavaza, Commented Sep 20, 2022 at 12:25

Scott Hunter · Accepted Answer · 2022-09-20 12:15:31Z

1

If you don't specify fieldnames when you create the DictReader, it gets the field names from the first row.

answered Sep 20, 2022 at 12:15

Scott Hunter

50k12 gold badges64 silver badges107 bronze badges

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

Comments

datawiz · Accepted Answer · 2022-09-20 12:20:02Z

1

You are trying to fetch the dictionary and printing the dictionary. Try to fetch the value instead of complete dictionary by using following code: print(list(row['a'])

answered Sep 20, 2022 at 12:20

datawiz

544 bronze badges

Comments

bavaza · Accepted Answer · 2022-09-20 12:33:47Z

1

Short answer:

with open('zumatchende.csv') as f:
    cf = csv.reader(f)
    row = [e[0] for e in cf]        
    
row

Out[14]: ['a', 'b', 'c', 'd']

Long answer:

Per the docs, DictReader outputs a dictionary whose keys are given by the optional fieldnames parameter. If fieldnames is omitted, the values in the first row of file f will be used as the fieldnames.

See a similar question here.

answered Sep 20, 2022 at 12:33

bavaza

11.1k11 gold badges78 silver badges109 bronze badges

1 Comment

Erik Over a year ago

But i used this tool before and without mentioning the fieldnames. It always gave me just an array with the values from each row. Is it possible to get it like this again? since this list does not have any fieldnames

Collectives™ on Stack Overflow

How to get csv rows as array with Python csv?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related