Pandas Read Excel: how to access a given cell by column and row numbers
<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>