Error when reading csv with merged cells

Question

I have a txt file that I open in Excel that has merged cells (see image).

.

These cause an error message when reading the file:

CParserError: Error tokenizing data. C error: Expected 1 fields in line 1883, saw 2

At the moment I'm manually taking them out in Excel. I'm sure there could be a way to taken these out when reading a file but I can't find anything on SO. I'm not sure if I'm using the right terminology though.

Using Excel may also be an option. I just wanted to see if there was a method using Python.

You cannot merge cells in .csv technically. It is really a text file. — Ṃųỻịgǻňạcểơửṩ, May 19 '18 at 07:34
What you're displaying is not a csv file, it's a capture of some excel screen. CSV is a text file format. — bruno desthuilliers, May 19 '18 at 08:39

score 0 · Accepted Answer · answered May 19 '18 at 07:33

0

If you just want to skip the headers, you might look at this SO answer which suggests the following:

data = pd.read_csv('file1.csv', error_bad_lines=False)

answered May 19 '18 at 07:33

Richard Inglis

5,888
2
33
37

Error when reading csv with merged cells

1 Answers1