How to Read CSV File in Python Example

In this article, I'll show you how to read CSV files in Python. Using Python, we can easily read CSV files line by line with the help of the csv module. This is useful when you need to work with data stored in a structured format, like spreadsheets or databases. Let’s explore how to read and process CSV files step by step.

CSV files (Comma Separated Values) are simple text files where data is stored in a table format, making them a popular choice for data exchange. Python’s csv module provides built-in methods to handle these files efficiently. By the end of this article, you'll know how to read data from CSV files and use it in your Python programs.

How to Read CSV Files in Python

In this example, we will take one demo.csv file with ID, Name, and Email fields. Then, we will use open() and reader() functions to read CSV file data.

main.py

from csv import reader
  
# open demo.csv file in read mode
with open('demo.csv', 'r') as readObj:
  
    # pass the file object to reader() to get the reader object
    csvReader = reader(readObj)
  
    # Iterate over each row in the csv using reader object
    for row in csvReader:
        # row variable is a list that represents a row in csv
        print(row)

main.py

from csv import reader
    
# skip first line from demo.csv
with open('demo.csv', 'r') as readObj:
  
    csvReader = reader(readObj)
    header = next(csvReader)
  
    # Check file as empty
    if header != None:
        # Iterate over each row after the header in the csv
        for row in csvReader:
            # row variable is a list that represents a row in csv
            print(row)

main.py

from csv import DictReader
  
# open demo.csv file in read mode
with open('demo.csv', 'r') as readObj:
  
    # Pass the file object to DictReader() to get the DictReader object
    csvDictReader = DictReader(readObj)
  
    # get over each line as a ordered dictionary
    for row in csvDictReader:
        # row variable is a dictionary that represents a row in csv
        print(row)

You might also like:

• Read Also: Laravel 11 Create Seeder with CSV File
• Read Also: How To Check Image Blur Or Not Using Python
• Read Also: How To Run Python Script In Laravel 9
• Read Also: Mail: Laravel 11 Send Email using Queue