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.