📋 csv Module

Last Updated: 22th August 2025


The csv module is used for working with comma-separated values (CSV) files. It allows you to read and write data in CSV format.

List of Functions:

  • csv.reader(file,Optional): Returns a reader object that can be used to iterate over the rows in the CSV file.

    Optional- delimiter= ',', quotechar='"', quoting=csv.QUOTE_MINIMAL,quoting=csv.QUOTE_ALL

import csv
with open('data.csv', 'r') as file:
    reader = csv.reader(file) # Optional- delimiter= ',', quotechar='"', quoting=csv.QUOTE_MINIMAL,quoting=csv.QUOTE_ALL
    for row in reader:
        print(row)
  • csv.writer(file,Optional): Returns a writer object that can be used to write data to the CSV file.

    Optional- quotechar='"', quoting=csv.QUOTE_MINIMAL,quoting=csv.QUOTE_ALL

import csv
with open("students_out.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow(["name", "age", "course"])
    writer.writerow(["Ravi", 23, "ML"])
    writer.writerow(["Anita", 24, "DS"])
  • csv.DictWriter(file, fieldnames): Returns a writer object that can be used to write data to the CSV file as a dictionary.
import csv
with open("students_dict.csv", "w", newline="") as f:
    fieldnames = ["name", "age", "course"]
    writer = csv.DictWriter(f, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerow({"name": "Raj", "age": 25, "course": "NLP"})
    writer.writerow({"name": "Kiran", "age": 26, "course": "DL"})
  • csv.DictReader(file): Returns a reader object that can be used to iterate over the rows in the CSV file as a dictionary.
import csv
with open("students.csv", "r") as f:
    reader = csv.DictReader(f)
    for row in reader:
        print(row)