Pandas: How to get position of columns?

Question

I need help to get the position of the column or another way to read in the column two step left of the column Spannung.

Exceldata = pd.read_excel(str(Dateien[0]), header=[2])
print Dateien[0]
Spannung = Exceldata.columns[Exceldata.columns.str.contains('Spannung effektiv L1')]
print Spannung

EdChum · Accepted Answer · 2015-11-26T14:57:31.503

11

IIUC you can use .get_loc

So:

pos = Exceldata.columns.get_loc(Spannung[0])

then you can index left:

other_col = Exceldata.columns[pos -2]

Example:

In [169]:
df = pd.DataFrame(columns=['hello','world','python','pandas','Spannung effektiv L1', 'asdas'])
spannung = df.columns[df.columns.str.contains('Spannung')]
spannung

Out[169]:
Index(['Spannung effektiv L1'], dtype='object')

In [178]:
pos = df.columns.get_loc(spannung[0])
df.columns[pos-2]

Out[178]:
'python'

edited Nov 26 '15 at 14:57

answered Nov 26 '15 at 14:46

EdChum

339,461
188
752
538

Because Spannung looks like that – A.Boss Nov 26 '15 at 14:52
Index([u'Spannung effektiv L1 (V)'], dtype='object') – A.Boss Nov 26 '15 at 14:53
Sorry I forgot you get an `IndexArray` you need to index into the `IndexArray` to return a Scalar, see my edit – EdChum Nov 26 '15 at 14:57
Please remember to accept my answer, there will be an empty tick mark at the top left of my answer so the question doesn't remain unanswered – EdChum Nov 26 '15 at 15:00
I just wanted to ask you how it goes. Did you get it? – A.Boss Nov 26 '15 at 15:04

Pandas: How to get position of columns?

1 Answers1

Linked