A Line Terminator is a string used to terminate lines produced by writer. The default value is \r or \n. We can write csv file with a line terminator in Python by registering new dialects using csv. register_dialect ( ) class of csv module.

Making some changes in the data of the existing file or adding more data is called modification.

DictReader ( ) gives OrderedDict by default in its output. An OrderedDict is a dictionary subclass which saves the order in which its contents are added. To remove the OrderedDict use dict ( ).

The function dict ( ) is used to print the data in dictionary format without order

(i) DictReader works by reading the first line of the CSV and using each comma separated value in this line as a dictionary key.
(ii) The columns in each subsequent row then behave like dictionary values and can be accessed with the appropriate key.

A dialect is a class of csv module which helps to define parameters for reading and writing CSV. It allows to create, store, and re-use various formatting parameters for data.

(i) The whitespaces can be removed, by registering new dialects using csv.register_ dialect ( ) class of csv module.
(ii) A dialect describes the format of the csv file that is to be read, In dialects the parameter "skipinitialspace" is used for removing whitespaces after the delimiter.

(i) To read the contents of CSV file with the help of csv.reader() method. The reader function is designed to take each line of the file and make a list of all columns.
(ii) Then, you just choose the column you want the variable data for. Using this method one can read data from csv files of different formats like quotes (" "), pipe (|) and comma (,).

Closing a file will free up the resources that were tied with the file and is done using Python close ( ) method.

To sort by more than one column you can use itemgetter with multiple indices:
operator.itemgetter 
Example:
sortedlist = sorted (data, key = operator. itemgetter(1))

The row heading is get sorted, to avoid the first row should be skipped. This is can be done by using the command "next( )".

The default is reading in text mode. In this mode, while reading from the file the data would be in the format of strings.

A CSV file is a human readable text file where each line has a number of fields, separated by commas or some other delimiter.