Python对Excel中具体某几列进行数据预处理

1.利用python读取Excel中.xls文件中所有数据

#encoding=utf-8
import xlrd
import xlwt
from xlwt import *

fileName="test01.xls"
bk=xlrd.open_workbook(fileName)
shxrange=range(bk.nsheets)
try:
    sh=bk.sheet_by_name("Sheet1")
except:
    print ("代码出错")
nrows=sh.nrows #获取行数
book = Workbook(encoding='utf-8')
 
for i in range(1,nrows):
    j = 1
    row_data=sh.row_values(i)
    #col_data=sh.col_values(i)
    print(row_data)

2.利用python处理xlsx中某列数据

# 需要倒入两个包
import pandas as pd
import openpyxl.workbook
import collections

if __name__ == '__main__':
    data = pd.read_excel("./文件名.xlsx")
    # print(list(data))
    colu=['甲', '乙', '丙']
    res=pd.DataFrame(columns=colu)
    for row in data.itertuples():
        col=collections.defaultdict(str)
        for i in range(len(colu)):
            col[colu[i]]=str(row