Cacher is the code snippet organizer for pro developers

# encoding: UTF-8
import os
import xlrd
import xlsxwriter


met = ['VA', 'HDCT', 'SO', 'PCA',	'MR', 'HS', 'GS', 'TD', 'MCA', 'BSCA', 	'SMD', 'MST', 'SPL5', 'SPL4'] # 相同顺序 in  ECSSD_bigdata_3part_10_run_AVE.xls

matrix = [[0] for i in range(0, 2)]


for eachmet in met:
    workbook_ele = xlrd.open_workbook('mean_pr_auc_' + eachmet + '.xls')
    sheet_ele = workbook_ele.sheet_by_name(u'Sheet3')
    pr = sheet_ele.row_values(0)
    matrix[0].append(eachmet)
    matrix[1].append(pr[0])

matrix[0].remove(0)
matrix[1].remove(0)
# 要保存的xls
workbook = xlsxwriter.Workbook('combine_10xls.xlsx')
worksheet = workbook.add_worksheet()

for i in range(0, len(matrix[0])):
    worksheet.write(0, i, matrix[0][i])
    worksheet.write(1, i, matrix[1][i])

workbook.close()