python excel表操作（两个excel合并为）

source_dir = ['../digitTest.csv','../digitTrain.csv']
target_dir = '../trainLabel.xlsx'

c_dir = ['../digitTest.xlsx','../digitTrain.xlsx']


#转化文件格式 csv-excel
for i in source_dir:
    r_csv = pd.read_csv(i,encoding='utf-8')
for j in c_dir:
    r_csv.to_excel(j,sheet_name='data')

#读取数据
data = []
for i in c_dir:
    wb = xlrd.open_workbook(i)
    for sheet in wb.sheets():
        for rownum in range(sheet.nrows):
            data.append(sheet.row_values(rownum))     
    #写入数据
    workbook = xlsxwriter.Workbook(target_dir)
    worksheet = workbook.add_worksheet()
    for i in range(len(data)):
        for j in range(len(data[i])):
            worksheet.write(i,j,data[i][j])
    #关闭文件流
    workbook.close()