title: Pandas Read Excel: how to access a given cell by column and row numbers
body: <p>Using the Pandas module and the read_excel function, could I give each column I read in from an excel file a number assignment as a column header, so instead of using <code>g_int_c=str(df1['Unnamed: 1'][6])</code> to refer to a piece of the data in the excel file, I could use <code>g_int_c=str(df1[1][6])</code>?</p>
  
  <p>Example code is below:</p>
  
  <pre><code>import pandas as pd
  
  with pd.ExcelFile(inputFile,
                        sheetname=['pnl1 Data ','pnl2 Data','pnl3 Data','pnl4 Data']) as xlsx:
          df1 = pd.read_excel(xlsx, 'pnl1 Data ',skiprows=9, parse_cols="B:H", keep_default_na='FALSE', na_values=['NULL'])#assign column headers
          df2 = pd.read_excel(xlsx, 'pnl2 Data', skiprows=9, parse_cols="B:H", keep_default_na='FALSE', na_values=['NULL'])
          df3 = pd.read_excel(xlsx, 'pnl3 Data', skiprows=9, parse_cols="B:H", keep_default_na='FALSE', na_values=['NULL'])
          df4 = pd.read_excel(xlsx, 'pnl4 Data', skiprows=9, parse_cols="B:H", keep_default_na='FALSE', na_values=['NULL'])
  </code></pre>