How do I solve this CSV reader problem in python?

Question

I'm trying to read a CSV file into python and I looked at different tutorials for it.

Input:

import csv

with open('test.csv', 'r') as csvdatei:
    csv_reader=csv.reader('test.csv')    
    for line in csv_reader:
        print(line)

Output:

['t']
['e']
['s']
['t']
['.']
['c']
['s']
['v']

Why does this not work? Why does it give me the split up file name as output?

I use python 3.7.3 on Spyder.

csv.reader(csvdatei) perhaps? docs.python.org/3/library/csv.html — DS_London
– DS_London, Commented Jun 7, 2021 at 14:18

quamrana · Accepted Answer · 2021-06-07 14:15:11Z

1

I think you meant to give csv the contents of the file and not the filename:

import csv

with open('test.csv', 'r') as csvdatei:
    csv_reader = csv.reader(csvdatei)    
    for line in csv_reader:
        print(line)

answered Jun 7, 2021 at 14:15

quamrana

39.5k13 gold badges57 silver badges77 bronze badges

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

1 Answer 1