Excel相关操作
pip install pandas
pip install xlrd
pip install openpyxl
import pandas as pd
一、文件的读写
data_original = pd.read_excel('test.xlsx')
data = pd.DataFrame(data_original )
data.to_excel("new_test.xlsx")
def readSheetsContent():
excel_data = pd.read_excel('path.xlsx', sheet_name = None)
sheet_list = list(excel_data)
for sheet_name in sheet_list:
data = pd.DataFrame(pd.read_excel('path.xlsx', sheet_name=sheet_name))
print(data)
def generateSheets():
data0 = pd.DataFrame({'a': [1, 2, 3], 'b': [4, 5, 6]})
data1 = pd.DataFrame({'c': [1, 5, 9], 'd': [2, 5, 8]})
writer = pd.ExcelWriter('path.xlsx')
data0.to_excel(writer, sheet_name='名称0')
data1.to_excel(writer, sheet_name='名称1')
writer.save()
writer.close()
二、数据的筛选
data_new = data.loc[(data['grade1'] > 40) & (data['grade2'] > 40) & (data['grade3'] > 40)
& (data['grade4'] > 40) & (data['grade5'] > 40), ['name', 'sex', 'grade1',
'grade2', 'grade3', 'grade4',
'grade5']]
三、重新生成索引
def readSheetsContent():
excel_data = pd.read_excel('path.xlsx', sheet_name = None)
sheet_list = list(excel_data)
for sheet_name in sheet_list:
data = pd.DataFrame(pd.read_excel('path.xlsx', sheet_name=sheet_name))
print(data)