read a csv file in python

To read a CSV (Comma-Separated Values) file in Python, you can use the built-in csv module.

First, import the csv module:


main.py
import csv
11 chars
2 lines

Open the CSV file using open() function with 'r' (read) mode:


main.py
with open('file.csv', 'r') as file:
    csv_reader = csv.reader(file)
70 chars
3 lines

Read the contents of the CSV file line by line using a for loop:


main.py
with open('file.csv', 'r') as file:
    csv_reader = csv.reader(file)
    
    for line in csv_reader:
        print(line)
123 chars
6 lines

This will print each line of the CSV file as a list of values.

If your CSV file has a header row, you can use the next() function to skip it:


main.py
with open('file.csv', 'r') as file:
    csv_reader = csv.reader(file)
    
    # Skip header row
    next(csv_reader)
    
    for line in csv_reader:
        print(line)
171 chars
9 lines

To read a CSV file with a different delimiter character (e.g. tab), you can pass it as an argument to the csv.reader() function:


main.py
with open('file.tsv', 'r') as file:
    csv_reader = csv.reader(file, delimiter='\t')
    
    for line in csv_reader:
        print(line)
139 chars
6 lines

This will read a TSV (Tab-Separated Values) file instead of a CSV file.

similar python code snippets

find the last modified date of a csv file in python

find the creation date of a csv file in python

find the name of a csv file in python

find the last accessed date of a csv file in python

copy a csv file in python

read a csv file in python

read json from a file in python

read csv from a file and convert it to json in python

open a file in python

convert json to csv in python

related categories