Row count in a csv file Row count in a csv file python python

Row count in a csv file


with open(adresse,"r") as f:    reader = csv.reader(f,delimiter = ",")    data = list(reader)    row_count = len(data)

You are trying to read the file twice, when the file pointer has already reached the end of file after saving the data list.


First you have to open the file with open

input_file = open("nameOfFile.csv","r+")

Then use the csv.reader for open the csv

reader_file = csv.reader(input_file)

At the last, you can take the number of row with the instruction 'len'

value = len(list(reader_file))

The total code is this:

input_file = open("nameOfFile.csv","r+")reader_file = csv.reader(input_file)value = len(list(reader_file))

Remember that if you want to reuse the csv file, you have to make a input_file.fseek(0), because when you use a list for the reader_file, it reads all file, and the pointer in the file change its position


If you are working with python3 and have pandas library installed you can go with

import pandas as pdresults = pd.read_csv('f.csv')print(len(results))