w3resource

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

Python module: Exercise-2 with Solution

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:

Flowchart: Count the number of lines in a given CSV file.

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.

What is the difficulty level of this exercise?

Test your Python skills with w3resource's quiz



Python: Tips of the Day

For-else construct useful when searched for something and find it:

# For example assume that I need to search through a list and process each item until a flag item is found and 
# then stop processing. If the flag item is missing then an exception needs to be raised.

for i in mylist:
    if i == theflag:
        break
    process(i)
else:
    raise ValueError("List argument missing terminal flag.")