How to get the Column Index from Column Name in Pandas

We can get the column location, i.e. the column index of a Pandas data frame by column name using the columns.get_loc method. For example.

import pandas as pd

df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C' : [7, 8, 9]})

df

Let’s get the location of column ‘B’.

df.columns.get_loc('B')

1