Python: Count the number of lines in a given CSV file

Last update on April 02 2025 12:31:38 (UTC/GMT +8 hours)

2. CSV Line Counter

Write a Python program to count the number of lines in a given CSV file. Use csv.reader

Sample Solution:

Python Code:

import csv
reader = csv.reader(open("employees.csv"))
no_lines= len(list(reader))
print(no_lines)

Sample Output:

52

Step1 - Open the CSV file using the open("employees.csv").
Step2 - Create a CSV reader by calling the function csv.reader(reader) as the result of the previous step.
Step3 - Get a list representation of the CSV file by calling list(reader) of the previous step.
Step4 - Count the number of lines in the CSV file with len(list(reader)).

Flowchart:

For more Practice: Solve these Related Problems:

• Write a Python program to read a CSV file with csv.reader and count the total number of rows, printing the final count.
• Write a Python function that reads a CSV file, skips any blank lines, and returns the number of non-empty rows.
• Write a Python script to open a CSV file using csv.reader, count the data rows (excluding headers), and print the count.
• Write a Python program to count the number of lines in a CSV file and also print the header separately using csv.reader.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Python program to read and display the content of a given CSV file.
Next: Write a Python program to parse a given CSV string and get the list of lists of string values.