Dealing with csv delimiter, which occurrence in rows

Question

I have a csv file like (Excel Review):

Display only as text:

How to handle the commas in the column B, if I want to read this data as csv in Python?

def import_csv():
    with open('file.csv', encoding="ISO-8859-1") as csvfile:

            reader = csv.DictReader(csvfile,delimiter=",")

            for row in reader:
                faelle.append(row)

In this case, If I take as delimiter the "," then the column B will be splited in more columns and this will be not fit for the data.

How can I now read the csv with the delimter "," and keep the column B as one in a pythonic way? So without an intervention/manipulation in the CSV.

In theory, it was declared under this post: Dealing with commas in a CSV file

You need to quote column B with doublequotes and try reading the file again. — yesemsanthoshkumar, Nov 07 '17 at 14:26
A csv file is a **text** file, so please show the actual content and not the way Excell (or any other spreadsheet) displays it. — Serge Ballesta, Nov 07 '17 at 14:39
@SergeBallesta you are right, I have added only the content without excel. Thank you — madik_atma, Nov 07 '17 at 14:46

score 0 · Answer 1 · answered Nov 07 '17 at 14:48

0

After reading the actual file, the answer is evident: use the delimiter from the file, that is a semicolon (;):

...
reader = csv.DictReader(csvfile,delimiter=";")
...

answered Nov 07 '17 at 14:48

Serge Ballesta

136,215
10
111
230

score 0 · Answer 2 · answered Nov 07 '17 at 14:48

0

Looks like your delimiter is ';' not ',' Try passing that to your reader.

answered Nov 07 '17 at 14:48

Dries De Rydt

768
4
17

score 0 · Answer 3 · answered Nov 07 '17 at 14:53

0

Try this:

import csv   
file=open("filename.csv", "r")
reader = csv.reader(file)
reader.next() #if you want to skip the first row
for line in reader:
    faelle.append(line)`enter code here`

answered Nov 07 '17 at 14:53

Syed Muzamil

85
4

Dealing with csv delimiter, which occurrence in rows

3 Answers3