本文整理自易百教程,原文地址:https://www.yiibai.com/python_data_science/python_processing_xls_data.html
侵删!!
1. 读取只包含单个工作表的excel文件
import pandas as pd
data = pd.read_excel('path/input.xlsx')
# Use the multi-axes indexing funtion
print (data.loc[[1,3,5],['salary','name']]) #读取第1、3、5行的标签为salary、name的数据
2. 读取包含多个工作表的excel文件
import pandas as pd
with pd.ExcelFile('C:/Users/Rasmi/Documents/pydatasci/input.xlsx') as xls: #将包含多个工作表的excel读取为一个文件夹
df1 = pd.read_excel(xls, 'Sheet1') #读取单个工作表
df2 = pd.read_excel(xls, 'Sheet2')
print("****Result Sheet 1****")
print (df1[0:5]['salary']) #读取特定行,特定列
print("")
print("***Result Sheet 2****")
print (df2[0:5]['zipcode'])