Import csv
csvData = [['Student, 'Age'], [Dhanush', '17'], ['Kalyani', '18'], ['Ram', '15']]
with open('c:\\pyprg\\ch13\\Pupil.csv', 'w') as CF:
writer = csv.writer(CF) # CF is the file object
writer.writerows(csvData) # csvData is the List name
CF.close( )

(i) Creating A New Normal CSV File
(ii) Modifying An Existing File
(iii) Writing on a CSV File with Quotes
(iv) Writing on a CSV File with Custom Delimiters
(v) Writing on a CSV File with Lineterminator
(vi) Writing on a CSV File with Quotechars
(vii) Writing CSV File Into A Dictionary
(viii) Getting Data At Runtime And Writing In a File

(i) CSV file - data with default delimiter comma (,)
(ii) CSV file - data with Space at the beginning
(ill) CSV file - data with quotes
(iv) CSV file - data with quotes

#importing csv
import csv
#opening the csv file which is in different location with read mode
with open('c:\\pyprg\\ sample1.csv', 'r') as F:
#other way to open the file is f= ('c:\\pyprg\\ sample1.csv', 'r')
reader = csv.reader(F)
# printing each line of the Data row by row
print(row)
F.close ( )

To create a CSV file using Microsoft Excel, launch Excel and then open the file you want to save in CSV format. For example. below is the data contained in our sample Excel worksheet:

Once the data is entered in the worksheet, select File ⟶ Save As option, and for the "Save as type option" select CSV (Comma delimited) or type the file name along with extension .csv.