A list is a data structure in Python that is a mutable, or changeable, ordered sequence of elements.

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.

If an exception occurs when you are performing some operation with the file, the code exits without closing the file. The best way to do this is using the "with" statement. This ensures that the file is closed when the block inside with is exited.

Python has a garbage collector to clean up unreferenced objects but, the user must not rely on it to close the file.

Read 'r', write 'w' or append 'a'.

File name or the complete path name can be represented either with in " " or in ' ' in the open command.

Python, a file operation takes place in the following order
Step 1: Open a file
Step 2 : Perform Read or write operation
Step 3 : Close the file

(i) Comma separated values
(ii) Carriage Return line feed

If the fields of data in your CSV file contain commas, you can protect them by enclosing those data fields in double-quotes ("). The commas that are part of your data will then be kept separate from the commas which delimit the fields themselves.

CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Since they're plain text, they're easier to import into a spreadsheet or another storage database, regardless of the specific software

A CSV is known as flat file because files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft Excel or OpenOfficeCalc