Hi I have a csv file that looks like the following.
"AB" ; "AA" ; "BA" ; "HI"
"CD" ; "BB" ; "BC" ; "JK"
"EF" ; "CC" ; "CE" ; "LM"
"GH" ; "DD" ; "DG" ; "MN"
How can I get the following code to strip off all the double quotes from every column in a csv file as for now it strips only the first column. Thanks
import csv
f = open("wakhawakha.csv", 'rt')
try:
for row in csv.reader(f, delimiter=' ', skipinitialspace=True):
print('|'.join(row))
finally:
f.close()
解决方案
Open it and read the string first.
import csv
with open("wakhawakha.csv", 'rt') as f:
data = f.read()
new_data = data.replace('"', '')
for row in csv.reader(new_data.splitlines(), delimiter=' ', skipinitialspace=True):
print ('|'.join(row))