How to get the row count of a Pandas DataFrame?

Question

How to get the row count of a Pandas DataFrame?

I'm trying to get the number of rows of dataframe df with Pandas, and here is my code.

Method 1:



total_rows = df.count

print total_rows + 1

Method 2:



total_rows = df['First_columnn_label'].count

print total_rows + 1

Both the code snippets give me this error:

TypeError: unsupported operand type(s) for +: 'instancemethod' and 'int'

What is wrong here?

dataframe python pandas

4 years ago by aashaykumar

2 Answers

Login / Signup to Answer the Question.

Login Signup

**kshitijrana14** · Answer 1 · 2021-05-04T12:40:18

Suppose df is your dataframe then:

count_row = df.shape[0]  # Gives number of rows

count_col = df.shape[1]  # Gives number of columns

Or, more succinctly,

r, c = df.shape

**sandhya6gczb** · Answer 2 · 2021-05-19T12:14:51

sandhya6gczb

For the data frame df use any of the following to get row counts.



len(df.index)

 df.shape[0 ]

 df[df.columns[0]].count()

4 years ago

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

How to get the row count of a Pandas DataFrame?

2 Answers

Login / Signup to Answer the Question.