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
import csv reader = csv.reader(open("employees.csv")) no_lines= len(list(reader)) print(no_lines)
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)).
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
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.")
- New Content published on w3resource:
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework