Python Pandas program to find the index of a column from the DataFrame

by

In this python pandas program, we will find the index of a column from the DataFrame using the pandas library.

Steps to solve the program
  1. Import pandas library as pd.
  2. Create a dataframe using pd.DataFrame().
  3. Find the index of the age column in the dataframe using df.columns.get_loc(‘Age’).
  4. Print the output.
				
					import pandas as pd
import numpy as np
d = {'Sr.no.':[1,2,3,4],'Name':['Alex','John','Peter','Klaus'],'Age':[30,27,29,33],'Salary':[50000,65000,58000,66000]}
df = pd.DataFrame(d)
print(df)
index = df.columns.get_loc('Age')
print("Index no of age column: ",index)

Output :

				
					0   Sr.no.   Name  Age  Salary
0       1   Alex   30   50000
1       2   John   27   65000
2       3  Peter   29   58000
3       4  Klaus   33   66000
Index no of age column:  2
Previous

convert a list of lists into a Dataframe

Next

select all columns except one column in a DataFrame

Leave a Comment