Python: Get Columns of max values each row of an pandas dataframe

What is the best way in python to get the column number of the max values of each row in a pandas dataframe-matrix (without the index column). E.g. if I would have

The output should be the vector:

 [1, 1, 3, ..., 2]

>Solution :

Use idxmax:

In [949]: cols = df.iloc[:, 1:].idxmax(1).tolist()

In [950]: cols
Out[950]: ['Company 1', 'Company 1', 'Company 3']

If you want column index:

In [951]: [df.columns.get_loc(i) for i in cols]
Out[951]: [1, 1, 3]