To write the CSV file with custom quote characters, by registering new dialects using csv. register_dialect( ) class of csv module.
Example:
import csv
csvData = [['SNO",Items'], ['1",Pen'], ['2",Book'], ['3"Pencil']]
csv.register_dialect('myDialect',delimiter = '|',
quotechar = '"', quoting=csv.QUOTE_ALL)
with open('c:\\pyprg\\ch13\\quote.csv', 'w') as csvFile:
writer = csv.writer(csvFile, dialect='myDialect')
writer. writerows( csvData)
print("writing completed")
csvFile.close( )

import csv
csv.register_dialect('myDialect',delimiter = '|',skipinitialspace= True)
filename = 'c:\\pyprg\\ch13\\sample8.csv'
with open(filename, 'r') as csvfile:
reader = csv.DictReader(csvfile, dialect='myDialect')
for row in reader:
print(diet(row))
csvfile.close ( )

# sort a selected column given by user leaving the header column
import csv
# other way of declaring the filename
inFile= 'c:\\pyprg\\sample6.csv'
# opening the csv file which is in the same location of this
python file
F=open(inFile', 'r')
# reading the File with the help of csv.reader()
reader = csv.reader(F)
# skipping the first row(heading)
next(reader)
# declaring a list
arrayValue = [ ]
a = int(input ("Enter the column number 1 to 3:-"))
# sorting a particular column-cost
for row in reader:
arrayValue.append(row[a])
arrayValue.sort ( )
for row in arrayValue:
print (row)
F.close ( )

Import csv
#opening the csv file which is in different location with read mode
f=open("c:\\pyprg\\ch13ample5.csv",'r')
#reading the File with the help of csv.reader( )
readFile=csv.reader(f)
#printing the selected column
for col in readFile:
print col[0],col[3]
f.close ( )
Sample5.csv File in Excel

import csv
csv.register_dialect('myDialect', delimiter = ',',skipinitialspace = True)
F=open('c:\\pyprg\\sample2.csv','r')
reader = csv.reader(F, dialect='myDialect')
for row in reader:
print(row)
F.close ( )