[toc]
Overview
Problem Statement: Given a Pandas Dataframe, how to get the row count of the data frame?
Example: In the following example, we have a dataframe that has 5 rows in it. Thus, the question here is how do we get the number of rows in the dataframe? (Output expected is 5 in this case)
import pandas as pd
df = pd.DataFrame({
'col1': [10, 20, 30, 40, 50],
'col2': ['a', 'b', 'c', 'd', 'e'],
'col3': [True, False, True, None, False],
})
# Some way to print the number of rows which in this case is 5Note: Pandas DataFrame is a 2 Dimensional data structure that is immutable and heterogeneous. This data structure has labelled axes rows and columns. A dataframe comprises three parts: data, rows, and columns.
In the above example the data frame used is as follows:
0 10 a True 1 20 b False 2 30 c True 3 40 d None 4 50 e False
Read more about Pandas Dataframes here: How to Create a DataFrame in Pandas?
Now that we have an idea about Pandas Dataframe and we also have a clear picture of the problem given, let’s dive into the different ways to get the row count of a Pandas DataFrame.
Method 1: Using len() or len(df.index)
?️Approach: A very simple approach to find the number of rows in the given dataframe is to use the len() method.
Python’s built-in function len() returns the length of the given string, array, list, tuple, dictionary, or any other iterable. The type of the return value is an integer that represents the number of elements in this iterable.
Solution:
import pandas as pd
df = pd.DataFrame({
'col1': [10, 20, 30, 40, 50],
'col2': ['a', 'b', 'c', 'd', 'e'],
'col3': [True, False, True, None, False],
})
# Printing the dataframe
print(df)
l = len(df)
# Printing the number of rows
print("\nCount of Rows in Dataframe: ", l)Output:
col1 col2 col3
0 10 a True
1 20 b False
2 30 c True
3 40 d None
4 50 e False
Count of Rows in Dataframe: 5?️Approach: Instead of using len(), you can use a quicker approach with the help of len(df.index). While df.index gives the count of rows in the dataframe, df.columns returns the number of columns in the dataframe.
Solution:
import pandas as pd
df = pd.DataFrame({
'col1': [10, 20, 30, 40, 50],
'col2': ['a', 'b', 'c', 'd', 'e'],
'col3': [True, False, True, None, False],
})
print(df)
print()
print("Number of Rows: ", len(df.index))
print("Number of Columns: ", len(df.columns))Output:
col1 col2 col3
0 10 a True
1 20 b False
2 30 c True
3 40 d None
4 50 e False
Number of Rows: 5
Number of Columns: 3Method 2: Using Dataframe Shape
?️Approach: Another workaround to find the number of rows in the given dataframe is to use pandas.DataFrame.shape that will return a tuple. This tuple represents the dimensions of the Pandas DataFrame.
⦿ The first element of the tuple, i.e., df.shape[0] gets the number of rows while,
⦿ the second element of the tuple, i.e., df.shape[1] gets the number of columns.
Solution:
import pandas as pd
df = pd.DataFrame({
'col1': [10, 20, 30, 40, 50],
'col2': ['a', 'b', 'c', 'd', 'e'],
'col3': [True, False, True, None, False],
})
print(df)
print()
print("Number of Rows: ", df.shape[0])
print("Number of Columns: ", df.shape[1])Output:
col1 col2 col3
0 10 a True
1 20 b False
2 30 c True
3 40 d None
4 50 e False
Number of Rows: 5
Number of Columns: 3Method 3: Using DataFrame Axes Length
?️Approach: The idea here is to track the range of a particular axis of the dataframe. Every DataFrame object consists of two axes: “axis 0” which represents the rows and “axis 1″which represents the columns. Now, the DataFrame.axes method is used to return the row and column axis labels.
⦿ df.axes[0] is used to retrieve range of the rows of the Dataframe from the tuple whereas,
⦿ df.axes[1] is used to retrieve the range of columns of the Dataframe.
Thus, you have to use the len() method after finding the row and column range using the axes() method to get the count of the number of rows.
Let’s have a look at the following solution:
import pandas as pd
df = pd.DataFrame({
'col1': [10, 20, 30, 40, 50],
'col2': ['a', 'b', 'c', 'd', 'e'],
'col3': [True, False, True, None, False],
})
print(df)
print()
print("Count of rows: ", len(df.axes[0]))
print("Count of columns: ", len(df.axes[1]))Output:
col1 col2 col3
0 10 a True
1 20 b False
2 30 c True
3 40 d None
4 50 e False
Count of rows: 5
Count of columns: 3Method 4: Using DataFrame Count Method
The df.count() method can be used to find the count of the number of rows in the Dataframe.
Example:
import pandas as pd
df = pd.DataFrame({
'col1': [10, 20, 30, 40, 50],
'col2': ['a', 'b', 'c', 'd', 'e'],
'col3': [True, False, True, None, False],
})
print(df)
print()
print("Count of rows: ", df.count()[0])Output:
col1 col2 col3
0 10 a True
1 20 b False
2 30 c True
3 40 d None
4 50 e False
Count of rows: 5Caution: The Dataframe Count method ignores the None and Nan values in the columns and rows. If the row contains None values, then that row will be ignored while calculating the number of rows.
Example:
import pandas as pd
df = pd.DataFrame({
'col1':[10, 20, None, 40, 50],
'col2': ['a', 'b', 'c', 'd', 'e'],
'col3': [True, False, True, None, False],
})
print("Count of rows: ", df.count()[0])
# Count of rows: 4Method 5: Using dataframe.info
Another effective method that helps us to get the number of rows in a dataframe is df.info. This method fetches a wide range of information about a DataFrame that includes the index dtype and columns, non-null values and memory usage.
Thus, you can use the df.info to get the number of rows in the dataframe. It also returns the Nan and None values included in a row.
Note: The df.info method is comparatively slower than other methods discussed as it retains various other information including the number of rows.
Solution:
import pandas as pd
df = pd.DataFrame({
'col1': [10, 20, 30, 40, 50],
'col2': ['a', 'b', 'c', 'd', 'e'],
'col3': [True, False, True, None, False],
})
df.info()Output:
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 5 entries, 0 to 4
Data columns (total 3 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 col1 5 non-null int64
1 col2 5 non-null object
2 col3 4 non-null object
dtypes: int64(1), object(2)
memory usage: 248.0+ bytesConclusion
In this tutorial, we learned about numerous methods to get the row count of a pandas DataFrame. Please stay tuned and subscribe for more such tips and tricks.
Learn Pandas the Fun Way by Solving Code Puzzles
If you want to boost your Pandas skills, consider checking out my puzzle-based learning book Coffee Break Pandas (Amazon Link).
It contains 74 hand-crafted Pandas puzzles including explanations. By solving each puzzle, you’ll get a score representing your skill level in Pandas. Can you become a Pandas Grandmaster?
Coffee Break Pandas offers a fun-based approach to data science mastery—and a truly gamified learning experience.