Pandas : read csv with embeded commas

Question

I am trying to read a csv file with rows in the format :

A,B,"C,D",E

I want to have as an output :

   A   B  C,D   E

I used

df = pd.read_csv('/path/to/file_name',sep=",")

But it doesn't give the desired output. Any idea how to solve this ?

Gwang-Jin Kim · Accepted Answer · 2020-12-06 18:19:53Z

1

df = pd.read_csv('/path/to/file_name',sep=",",quotechar='"')

Specify the quotechar argument to ", then it will interprete everything between double quotes as part of a string (including the , character in the string).

answered Dec 6, 2020 at 18:19

Gwang-Jin Kim

11.1k20 silver badges39 bronze badges

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

2 Comments

Snowfire Over a year ago

I tried that but it still gives me all the row content in first column then the rest of columns are filled with NaN

Gwang-Jin Kim Over a year ago

Then you have to look at the file you want to read-in carefully. Is there a first row which is commented out?

Collectives™ on Stack Overflow

Pandas : read csv with embeded commas

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related