Pandas - Is it possible to read_csv with no quotechar?
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()
.
Jkdc's answer is correct, but I find it more readable to actually use the csv.QUOTE* instance as mentioned in the documentation. It wasn't clear to me which csv it meant at first, so I didn't know how to import that. Here's a code sample:
import pandas as pdimport csvdf1 = pd.read_csv('input_file.csv', quoting=csv.QUOTE_NONE)