Comma in numbers causing problem reading csv

Question

Upon calling a csv file I am getting the following error

ParserError: Error tokenizing data. C error: Expected 1 fields in line 12, saw 2

I opened my csv file and then went to the line and saw that the error is coming because one of the numbers is with decimals but separated by a cooma.

That entire column of my csv file has whole numbers but also decimals numbers that look like the following .

385433,4

Not sure how I can resolve this error when reading the csv file using pandas

@Sayandip Dutta, for some reason I am getting the same error — E199504
– E199504, Commented Feb 25, 2020 at 16:05
Show a few actual lines of the CSV file (change sensitive data if needed). — Mark Tolonen
– Mark Tolonen, Commented Feb 25, 2020 at 17:25
@Mark Tolonen, my lines are separated by ; and the if I remove that line the next error comes exactly at the other lines that has a decimal number seperated by a comma example 154,65 — E199504
– E199504, Commented Feb 26, 2020 at 9:05

Mark Tolonen · Accepted Answer · 2020-02-26 15:49:02Z

2

It sounds like you have European-formatted CSV. Since you haven't provided a real sample of your CSV as requested, I will guess. If this doesn't solve your issue, edit your question to provide an actual sample:

Given test.csv:

c1;c2;c3
1,2;3,4;5,6
3,4;5,6;7,8

Then:

import pandas as pd
data = pd.read_csv('test.csv',decimal=',',delimiter=';')
print(data)

Produces:

    c1   c2   c3
0  1.2  3.4  5.6
1  3.4  5.6  7.8

answered Feb 26, 2020 at 15:49

Mark Tolonen

181k26 gold badges183 silver badges279 bronze badges

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

Collectives™ on Stack Overflow

Comma in numbers causing problem reading csv

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related