190401-利用Pandas从大数据Excel文件中解析分列表Sheet的表单

Load Excel Spreadsheet As pandas Dataframe

Pandas: Looking up the list of sheets in an excel file

import pandas as pd

# 载入数据
dframe = pd.ExcelFile('your_data.xls')

# 读取Sheet名称
sn = dframe.sheet_names

# 解析Sheet值,如果没有表头则设置`header=None`，否则忽略设置
df = dframe.parse(sn[0],header=None)