python读excel两种方式

来源：互联网发布：网络买卖合同律师365 编辑：程序博客网时间：2024/06/06 01:55

xlrd模块读excel

import xlrddata = xlrd.open_workbook("window regulator.xlsx") #打开exceltable = data.sheet_by_name("Sheet2")#读sheetnrows = table.nrows #获得行数result = []for i in range(1,nrows):  #    rows  = table.row_values(i) #行的数据放在数组里    sku = rows[0]    keyword = str(rows[1]).split("-")[1] + " "+ str(rows[2]).replace("|"," ") + " window regulator"    kind = rows[3]    result.append([sku, keyword,kind])print(result)

pandas模块读excel

import pandas as pdimport numpyimport csvimport xlrd#读入skudf = pd.read_excel("window regulator.xlsx",sheetname="Sheet2")  #读excelskus = df["sku"].valuesfor sku in skus :    df1 = pd.read_csv("sku\\feedback_"+str(sku)+".csv",encoding="utf-8")    df1 = df1[(df1.price < 60) & (df1.price >10)]    df1.to_csv("sku\\feedback_"+str(sku)+".csv",encoding="utf-8",index = False)  #写入到csv

阅读全文

0 0