pandas

to number

column edit

df.columns = ['prdcode', 'category', 'prdname', 'brand']
# drop row 0-2
df.drop(df.index[:3], inplace=True) # row

# drop column
df.drop('column_name', 1)
df.drop('column_name', axis=1, inplace=True)
df2 = df[['prdcode', 'category', 'prdname', 'brand']]
df2.head()

column type change

df[['ZIP_NO']] = df[['ZIP_NO']].astype(str)

read sheet

xls = pd.ExcelFile('docs/20170525.xlsx')
df1 = xls.parse('Sheet 1')
df2 = xls.parse('Sheet 2')

Tutorial

What Else?