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

Last update on January 06 2025 13:44:24 (UTC/GMT +8 hours)

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:

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.