In [45]: df = DataFrame({"pear": [1,2,3], "apple": [2,3,4], "orange": [3,4,5]})  In [46]: df.columns Out[46]: Index([apple, orange, pear], dtype=object)  In [47]: df.columns.get_loc("pear") Out[47]: 2 

Read more of this post