DataFrame.shape size ndim to get number of rows columns elements and dimensions of the DataFrame

Getting the rows , columns, elements and dimensions of the DataFrame.

import pandas as pd 
my_dict={'NAME':['Ravi','Raju','Alex','Ron','King','Jack'],
         'ID':[1,2,3,4,5,6],
         'MATH':[80,40,70,70,70,30],
         'ENGLISH':[80,70,40,50,60,30]}
df = pd.DataFrame(data=my_dict)
print(df.shape)

Output

(6, 4)

As we are getting one tuple as output so we can display the elements to show number of rows ( first elemetn ) and columns ( second element )

print("Number of rows : ",df.shape[0])
print("Number of columns : ",df.shape[1])

Output

   Number of rows :  6
Number of columns :  4

size

We will get total number of elements by using size. Here the output is 24.

print(df.size) # 24

In above code check that the size returns the same value as returned by multiplication of elements returned by shape ( size = rows x columns )

Dimensions

We can read the dimension of the DataFrame.

print(df.ndim) # 2
print(df['NAME'].ndim) # 1

Using Excel file

Create DataFrame from Excel file by using read_excel() and then get the shape , size and dimensions.

import pandas as pd 
df = pd.read_excel('D:\student.xlsx')

Using CSV file

Reading from csv file to create DataFrame

import pandas as pd 
df= pd.read_csv('D:\\my_data\\student.csv') # DataFrame from csv file data

Display the shape, size and ndim

print(df.shape) #  (35,5) ( rows, columns)
print("Number of rows : ",df.shape[0])
print("Number of columns : ",df.shape[1])
print(df.size) #  175
print(df.ndim) # 2
print(df['name'].ndim) # 1

Sample student DataFrame
Pandas tail() head() read_csv() read_excel() to_excel()

Numpy arrays Python & MySQL Python- Tutorials

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

DataFrame.shape , size , ndim

size

Dimensions

Using Excel file

Using CSV file

Subhendu Mohapatra