Remove all occurrences of double quotes from text (python csv)

Question

I have a text file that I obtained by converting a dataframe using csv module in Python as follows:

df.to_csv(r'listfinal.txt', header=None, index=None, sep=' ', mode='a')

The text file has double quotes around many entries, i.e,

Circles "Post Malone"
"You Know You Like It" "DJ Snake"
"Future Nostalgia" "Dua Lipa"

I wish to remove all such double quotes from anywhere on this file. What do I change in the initial conversion df.to_csv?

@jezrael I do not have the double quotes in the dataframe itself. But they are generated when I convert it to a text file using df.to_csv I think you misinterpreted the question — AmanArora, Mar 23 '20 at 12:06
If you remove quotes, how do you distinguish the separators ` ` and the normal spaces ` ` within a cell? — Quang Hoang, Mar 23 '20 at 12:26

score 0 · Answer 1 · answered Mar 23 '20 at 12:25

0

Have you tried:

df.to_csv(r'listfinal.txt', header=None, index=None, sep=' ', mode='a', quoting=csv.QUOTE_NONE)

you could also use csv.QUOTE_MINIMAL instead

answered Mar 23 '20 at 12:25

Gorlomi

1 Answers1