Python Tutorial

In this tutorial, we'll look at how to determine how many rows and columns are in a DataFrame. There are several ways we may accomplish this. Let's examine each of these approaches using examples.

Quick Methods for Counting Rows in a Pandas DataFrame

See the samples below if you need to know how many rows there are in a given Pandas DataFrame quickly.

Code

rows = df.count()[0]
rows = len(df.index)
rows = df.shape[0]
rows = len(df.axes[0])

columns = df[df.columns[0]].count()
columns = len(df.columns)
columns = df.shape[1]
columns = len(df.axes[1])

Dataframe.shape()

We can use dataframe.shape to calculate the number of dataframe rows and columns. The row and column of the dataframe counts are provided by dataframe.shape[0] and dataframe.shape[1], respectively.

Code

# Python program to count the rows and columns of the dataframe using the .shape() method

# Importing the required module
import pandas as pd
  
# Creating a dictionary
dict_ = {'row_1' : ['A', 'B', 'C', 'D'],
         'row_2' : [1, 2, 3, 4],
         'row_2' : [6, 7, 8, 9]}

# Creating the Dataframe
dframe = pd.DataFrame(dict_)
  
# Getting the number of Dataframe's rows and columns
rows = dframe.shape[0]
cols = dframe.shape[1]
  
# Printing the number of Dataframe's rows and columns
print("Rows: ", rows)
print("Columns: ", cols)

Output

  row_1  row_2
0     A      6
1     B      7
2     C      8
3     D      9
Rows:  4
Columns:  2

Dataframe.len()

The len() function can determine the number of the Dataframe's rows and columns. Rows and columns are represented by dataframe.axes[0] and dataframe.axes[1]. As a result, dataframe.axes[0] and dataframe.axes[1] provide the number of rows and columns, respectively.

Code

# Python program to count the rows and columns of the dataframe using the len() method

# Importing the required module
import pandas as pd
  
# Creating a dictionary
dict_ = {'row_1' : ['A', 'B', 'C', 'D'],
         'row_2' : [1, 2, 3, 4],
         'row_2' : [6, 7, 8, 9]}

# Creating the Dataframe
dframe = pd.DataFrame(dict_)
  
# Getting the number of Dataframe's rows and columns
rows = len(dframe.axes[0])
cols = len(dframe.axes[1])
  
# Printing the number of Dataframe's rows and columns
print("Rows: ", rows)
print("Columns: ", cols)

Output

Rows:  4
Columns:  2

Dataframe.index() and Dataframe.columns()

Dataframe.index provides rows, and dataframe.columns provides columns, much like in Example 2. Len() functions, len(dataframe.index), and len(dataframe.columns) correspondingly return the number of the Dataframe's rows and columns. RangeIndex(start = 0, stop = 7, step = 1) is returned by df.index and can be used with len() to obtain the count. Len(df) is another option, although it runs less quickly than len(df.index) since it requires one fewer function call. These return the count more quickly than df.shape[0].

Code

# Python program to count the rows and columns of the dataframe using len() and .index() method

# Importing the required module
import pandas as pd
  
# Creating a dictionary
dict_ = {'row_1' : ['A', 'B', 'C', 'D'],
         'row_2' : [1, 2, 3, 4],
         'row_2' : [6, 7, 8, 9]}

# Creating the Dataframe
dframe = pd.DataFrame(dict_)
  
  
# Getting the number of Dataframe's rows and columns
rows = len(dframe.index)
cols = len(dframe.columns)
  
# Printing the number of Dataframe's rows and columns
print("Rows: ", rows)
print("Columns: ", cols)

Output

Rows:  4
Columns:  2

Dataframe.count()

Given its performance, this strategy is not advised; yet, we must still discuss it because it is one of the ways to determine the number of rows in a DataFrame. When determining the count, we should note that this excludes data from columns containing None or Nan.

Code

# Python program to count the rows and columns of the dataframe using the .count() method

# Importing the required module
import pandas as pd
  
# Creating a dictionary
dict_ = {'row_1' : ['A', 'B', 'C', 'D'],
         'row_2' : [1, 2, 3, 4],
         'row_2' : [6, 7, 8, 9]}

# Creating the Dataframe
dframe = pd.DataFrame(dict_)
  
# Getting the number of Dataframe's rows and columns
rows = dframe.count()[0]
columns = dframe[dframe.columns[0]].count()
  
# Printing the number of Dataframe's rows and columns
print("Rows: ", rows)
print("Columns: ", cols)

Output

Rows:  4
Columns:  2

You have studied using DataFrame to find or obtain the count of rows (merely row count) in a DataFrame from this tutorial. You learned how to obtain the form of the DataFrame from len(DataFrame.index), len(DataFrame.axes[0]), DataFrame.count(), and others.

Next TopicPython Coding Platform

← prev next →