In this program, we are going to read a selected column given by the user. "Sample 6.csv".
Input

Since the row heading is also get sorted, to avoid that the first row should be skipped. This is can be done by using the command "next( )". The list is sorted and displayed.
Program:
# 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
array value = [ ]
a = int(input ("Enter the column number 1 to 3:-"))
# sorting a particular column-cost
for row in reader:
array value.append(row[ a])
array value.sort ( )
for row in array value:
print (row)
F.close ( )
Output:
Enter column number  1 to 3:- 2
50
12
10

To read a csv file and the contents of the file will be stored as a list. The syntax for storing in the list is list=[ ]
list.append (element)
For example:
All the row values of "sample.csv' file is stored in a list
Program:
import csv
#other way of declaring the filename
infile = 'c:\\pyprg\\sample.csv'
f = open (infile, 'r')
reader = csv.reader (F)
#declaring array
array value = [ ]
#displaying the content of the list for row in reader:
array Value.append (row)
print (row)
F. close( )
Sample.csv opened in MS-Excel

Output:
['Topic 1'. 'Topic 2', 'Topic 3']
['One', 'two', 'three']
['Example 1', 'Exarnple 2', 'Example 3' ]

1) Create a CSV file using Microsoft Excel, launch Excel
2) Open the file,
3) Save in CSV format.
For example:
The data is contained in our sample Excel worksheet:

1. Once the data is entered in the worksheet, select File ⟶ Save As option, and for the "Save as type option", select CSV or type the file name along with extension.csv. saving excel file as CSV.
2. After we save the file, we are free to open it up in a text editor to view it or to edit it manually. Its contents will resemble the following:

import csv
with open ('c\\pyprg\\ch13\\ dynamicfile.csv', 'w') as f:
w = csv.writer(f)
ans= 'y'
while (ans=='y'):
name=input("Name?:")
date=input("Date of birth:")
Place=input ("Place:")
w.writerow([name, date, place])
ans=input("Do you want to enter more y/n?:")
F=open('c:\\pyprg\\ch13\\dynamicfile.csv",r')
reader=csv.reader(F)
for row in reader:
print (row)
F.close()

import csv
csv.register_dialect('myDialect', delimiter = '|', quoting=csv.QUOTE_ALL)
with open('c:\\pyprg\\ch13\\ grade.csv', 'w') as csvfile:
fieldnames = ['Name', 'Grade']
writer = csv.DictWriter(csvfile,
fieldnames=fieldnames. dialect ="myDialect")
writer.writeheader()
writer.writerows([{'Grade': 'B', 'Name': Anu'},
{'Grade': 'A', 'Name': 'Beena',},
{Grade': 'C', 'Name': 'Tarun'}])
print("writing completed")

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
Data = [['Fruit', 'Quantity'], ['Apple', '5'], ['Banana', '7']' ['Mango: '8']]
csv.register_dialect('mydialect; delimiter = '|', lineterminator = '\n')
with open('c:\\pyprg\\ch3\\line.csv', 'w') as f:
writer = csv.writer(f, dialect='myDialect')
writer.writerows(Data)
f.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 ( )

To sort by more than one column you can use itemgetter with multiple indices: operator. itemgetter (1,2).

The following program do the task mentioned above using operator.itemgetter(col_no)
Example:
# Program to sort the entire row by using a specified column.
# declaring multiple header files
import csv, operator
#One more way to read the file
data = csv.reader(open('c:\\PYPRG\ \sample8.csv'))
next(data) #(to omit the header)
#using operator module for sorting multiple columns
sortedlist = sorted (data, key=operator.
itemgetter(1) # 1 specifies we want to sort
# according to second column for row in sortedlist:
print(row)
Output:
['Mouse', '20']
['Keyboard', '48']
['Monitor', '52']

# 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
# other way of declaring the filename
inFile= 'c:\\pyprg\\sample.csv'
F=open (inFile,' r')
reader = csv.reader(F)
# declaring array
arrayValue = [ ]
# displaying the content of the list for row in reader:
arrayValue.append(row)
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 = '|')
with open ('c:\\pyprg\\sample4.csv', 'r') as f:
reader = csv,reader(f, dialect='myDialect')
for row in reader:
print(row)
f.close( )

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 ( )

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( )