Pandas - Is it possible to read_csv with no quotechar?

python pandas quotes
killajoule picture killajoule · Feb 2, 2015 · Viewed 14.4k times · Source

I am trying to read a csv file that has single instances of " in certain lines, ex:

car,"plane,jet
jet,ski,"hat

When I use pandas read_csv to read this file, it recognizes " as a quote character and does not correctly read in lines such as the one above. I would like to not have any quote character at all when I use read_csv.

I tried setting quotechar=None and quotechar='' but both spits out an error since quotechar has to be a string of length 1. Is it possible to not have a quotechar at all when using read_csv?

Thanks!

Answer

MrAlexBailey picture MrAlexBailey · Feb 2, 2015

From the Pandas Documentation

quoting : int or csv.QUOTE_* instance, default None Control field quoting behavior per csv.QUOTE_* constants. Use one of QUOTE_MINIMAL (0), QUOTE_ALL (1), QUOTE_NONNUMERIC (2) or QUOTE_NONE (3). Default (None) results in QUOTE_MINIMAL behavior.

So you'll want to include quoting=3 as a parameter to your read_csv().

Related questions

How to select rows from a DataFrame based on column values

How can I select rows from a DataFrame based on values in some column in Pandas? In SQL, I would use: SELECT * FROM table WHERE colume_name = some_value I tried to look at Pandas' documentation, but I did not …

Read More
Renaming columns in pandas

I have a DataFrame using pandas and column labels that I need to edit to replace the original column labels. I'd like to change the column names in a DataFrame A where the original column names are: ['$a', '$…

Read More
How to iterate over rows in a DataFrame in Pandas

I have a DataFrame from Pandas: import pandas as pd inp = [{'c1':10, 'c2':100}, {'c1':11,'c2':110}, {'c1':12,'c2':120}] df = pd.DataFrame(inp) print df Output: c1 c2 0 10 100 1 11 110 2 12 120 Now I want to iterate over the rows …

Read More