Indexing Pandas data frames: integer rows, named columns

It’s a late answer, but @unutbu’s comment is still valid and a great solution to this problem.

To index a DataFrame with integer rows and named columns (labeled columns):

df.loc[df.index[#], 'NAME'] where # is a valid integer index and NAME is the name of the column.