skiprows function adding extra column in pandas
I am new to python. I am trying to read excel files and merge into master excel.

I want to skip first 3 rows in my excel which contains heading and just take rest of rows.

i am using skiprows=3 in pd.read_excel() method, it is skipping first 3 rows but the problem is, it is including one extra column with name 2 in my excel.

if i mention skiprows=2 then that extra column (2) is not coming. but empty row in excel is getting added with "Unnamed". if i mention skiprows=3 it is not adding "Unamed" row but adding extra column with name 2.

can someone please help me out in this. below is my code.

```
import os
import pandas as pd

if os.path.isfile('total_sales.xlsx'):
    os.remove('total_sales.xlsx')

cwd = os.path.abspath('')
files = os.listdir(cwd)

df = pd.DataFrame() #create an empty dataframe df for storing the data for master spreadsheet
cols = [0,1,2,3,4,6,7,8,9,10,11]
for file in files:
    if file.endswith('.xlsx'):
        df=df.append(pd.read_excel(file,skiprows=3,usecols=cols))


print(cwd)
print(df.head())
print(df.shape)

df.to_excel('total_sales.xlsx')


```

please find below master excel with output.

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/Y3MNB.png