write csv file with double quotes for particular column not working
More generally, if you need to save your CSV file with every column within double quotes
with open('Data/with_quotes.csv', 'wt') as fr:
csv_writer = csv.writer(fr, quoting=csv.QUOTE_ALL)
with open('without_quotes.csv', 'rt') as f:
csv_reader = csv.reader(f, skipinitialspace=True, doublequote=False)
for row in csv_reader:
csv_writer.writerow(row)
Probably you need to play with parameters quoting and escapechar.
For example, modified code
csvReader = csv.reader(iInputFile)
writer = csv.writer(open('one_1.csv', 'wb'), delimiter=',', lineterminator='\r\n', quoting=csv.QUOTE_NONE, escapechar='\\')
for row in csvReader:
rawRow = []
rawRow.append('31-7-2014') #Appending Date
rawRow.append(row[0]) #Appending data
rawRow.append('\"'+'test'+'\"')
writer.writerow(rawRow)
will produce output like that:
31-7-2014,'col1',\"test\"
try with this one
f_writ = open('one_4.csv', 'wb')
csvReader = csv.reader(iInputFile)
writer = csv.writer(f_writ, delimiter=',',
lineterminator='\r\n',
quotechar = "'"
)
for row in csvReader:
writer.writerow(['31-7-2014',row[0],'\"text\"'])
f_writ.close()
also i find very useful this link http://pymotw.com/2/csv/, there are a lot of exemples