Home/ Questions/Q 1192
Next
In Process
Meet
  • 2
Pundit
Asked: 2023-07-01T10:07:44+00:00 In:

How can I remove double quotes from each line of the csv file with pandas?

  • 2

I have a csv file containing data with double quotes.

“ABC,111”
“DEF,222”

 I want to display each data in a separate line removing the double quotes.

ABC,111
DEF,222

How can I remove double quotes from each line of the csv file with pandas?

Data Engineeringpandas
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. Professional
    This answer was edited.

    Try to implement this code and check if it works:

    df = (
    pd.read_csv("file.csv", header=None, quoting=3) # QUOTE_NONE
        .replace('"', "", regex=True).iloc[:, :-1]
         # .set_axis(["col1", ...]) # optional
)

     

    Output:print(df)

       0   1    2   3
0 ABC 111  NaN NaN
1 DEF 222  NaN NaN
    • 1