How do I print the total number of records from a csv file in python?

Question

I have a csv and I need to be able to print the total number of records how is this done? I have tried using sum statements and count but nothing seems to be working

please provide your code snippets, just asking question won't help. — Nothing
– Nothing, Commented Mar 21, 2018 at 3:51

Nothing · Accepted Answer · 2018-03-21 03:50:54Z

1

Try this:

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

answered Mar 21, 2018 at 3:50

Nothing

5223 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

adono · Accepted Answer · 2018-03-21 03:51:19Z

0

Did you use pandas to import the csv file?

If so, here are some quick and easy options for obtaining the record count:

df = pandas.read_csv(filename)

len(df)
df.shape[0]
df.index

Otherwise, an alternative solution if you used csv.reader(filename.csv) is:
row_count = sum(1 for line in open(filename))

(this solution was originally suggested here)

answered Mar 21, 2018 at 3:51

adono

186 bronze badges

1 Comment

rohan Over a year ago

thanks fam this one worked..such a simple code I feel silly

Collectives™ on Stack Overflow

How do I print the total number of records from a csv file in python?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related