get index column pandas code example
Example 1: find index of pandas column
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
Example 2: finding the index of an item in a pandas df
print(df[df['Name']=='Donna'].index.values)
Example 3: get index number pandas dataframe
df.index[df['BoolCol'] == True].tolist()
Example 4: get column index pandas
df = pd.read_csv('thanksgiving_w_age_income.csv')
gravy = df.columns.get_loc("Do you typically have gravy?")
meet_friends = df.columns.get_loc('Have you ever tried to meet up with hometown friends on Thanksgiving night?')
friendsgiving = df.columns.get_loc('Have you ever attended a "Friendsgiving?"')