How to get rid of row numbers, pd.read_excel?
<p>I am a complete beginner with Python. I am working on a assignment and I can't seem to figure out how to get rid of the <em>row numbers</em> from my excel spreadsheet, while using <code>import pandas</code>. </p>

<p>This is what I get when I run the code:</p>

<pre><code>0   $20,000,000 $159,000,000  
1    $9,900,000  $35,600,000  
2   $35,000,000  $45,000,000  
3    $9,900,000  $35,600,000  
4   $12,000,000   $9,400,000 
</code></pre>

<p>But instead I just want:</p>

<pre><code>$20,000,000  $159,000,000  
$9,900,000   $35,600,000  
$35,000,000  $45,000,000  
$9,900,000   $35,600,000  
$12,000,000  $9,400,000 
</code></pre>

<p>This is inside of my main block for formatting:</p>

<pre><code>if __name__ == "__main__":
    file_name = "movie_theme.xlsx"    

    # Formatting numbers (e.g. $1,000,000)
    pd.options.display.float_format = '${:,.0f}'.format

    # Reading Excel file
    df = pd.read_excel(file_name, convert_float = False)
</code></pre>

<p>Any suggestions on how to go about doing this?</p>

<p>You can try </p>

<pre><code>df = df.set_index('Salary')
</code></pre>

<p>where <code>Salary</code> is the column name you want to be the index.</p>

<p>The row number is called the index.</p>

python excel pandas