Count the number of rows and columns of Pandas dataframe Improve Improve Like Article Like Save Share Report In this article, we’ll see how we can get the count of the total number of rows and columns in a Pandas DataFrame. There are different methods by which we can do this. Let’s see all these methods with the help of examples. Example 1: We can use the dataframe.shape to get the count of rows and columns. dataframe.shape[0] and dataframe.shape[1] gives count of rows and columns respectively. # importing the module import pandas as pd # creating a DataFrame dict = {'Name' : ['Martha', 'Tim', 'Rob', 'Georgia'], 'Marks' : [87, 91, 97, 95]} df = pd.DataFrame(dict) # displaying the DataFrame display(df) # fetching the number of rows and columns rows = df.shape[0] cols = df.shape[1] # displaying the number of rows and columns print("Rows: " + str(rows)) print("Columns: " + str(cols)) Output : Example 2 : We can use the len() method to get the count of rows and columns. dataframe.axes[0] represents rows and dataframe.axes[1] represents columns. So, dataframe.axes[0] and dataframe.axes[1] gives the count of rows and columns respectively. # importing the module import pandas as pd # creating a DataFrame dict = {'Name':['Martha', 'Tim', 'Rob', 'Georgia'], 'Marks':[87, 91, 97, 95]} df = pd.DataFrame(dict) # displaying the DataFrame display(df) # fetching the number of rows and columns rows = len(df.axes[0]) cols = len(df.axes[1]) # displaying the number of rows and columns print("Rows: " + str(rows)) print("Columns: " + str(cols)) Output : Example 3 : Similar to the example 2, dataframe.index represents rows and dataframe.columns represents columns. So, len(dataframe.index) and len(dataframe.columns) gives count of rows and columns respectively. # importing the module import pandas as pd # creating a DataFrame dict = {'Name':['Martha', 'Tim', 'Rob', 'Georgia'], 'Marks':[87, 91, 97, 95]} df = pd.DataFrame(dict) # displaying the DataFrame display(df) # fetching the number of rows and columns rows = len(df.index) cols = len(df.columns) # displaying the number of rows and columns print("Rows: " + str(rows)) print("Columns: " + str(cols)) Output : Last Updated : 01 Aug, 2020 Like Article Save Article Previous Program to access different columns of a multidimensional Numpy array Next Python - Column Mapped Tuples to dictionary items Share your thoughts in the comments Add Your Comment Please Login to comment... Similar Reads Count the number of rows and columns of a Pandas dataframe Get the number of rows and number of columns in Pandas Dataframe Find maximum values & position in columns and rows of a Dataframe in Pandas Iterating over rows and columns in Pandas DataFrame Pandas DataFrame transpose() Method: Swap Rows and Columns Drop rows from Pandas dataframe with missing values or NaN in columns Apply a function to single or selected columns or rows in Pandas Dataframe Sort rows or columns in Pandas Dataframe based on values Get minimum values in rows or columns with their index position in Pandas-Dataframe Pandas filter a dataframe by the sum of rows or columns Like P parasmadan15 Follow Article Tags : Python Practice Tags : python