整理CSCD和CSD双检期刊

本文主要是介绍整理CSCD和CSD双检期刊，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

整理CSCD和CSD双检期刊

运行结果

源代码：

import xlrd
import xlwt
import time#open the .xls file
# xlsname="CSD.xls"
# book = xlrd.open_workbook(xlsname)#build a dictionary of the names->sheets of the book
# sd={}
# for s in book.sheets():# sd[s.name]=s#obtain Sheet "Foglio 1" from sheet names dictionary
# sheet=sd["Foglio 1"]#CSD.xls文件读取
csd_xls = "CSD.xls"
book_csd = xlrd.open_workbook(csd_xls)
table_csd = book_csd.sheets()[0]#CSCD.xls文件读取
cscd_xls = "CSCD.xls"
book_cscd = xlrd.open_workbook(cscd_xls)
table_cscd = book_cscd.sheets()[0]#excel行数
print("CSD行数:", table_csd.nrows)
print("CSCD行数:", table_cscd.nrows)#输出excel文本框内容
print("CSD_TEXT:", table_csd.cell(1397,2).value)
print("CSCD_TEXT:", table_cscd.cell(888,1).value)if str(table_csd.cell(1397,2).value) == str(table_cscd.cell(888,1).value):print("YOU ARE WIN")print(str(table_csd.cell(1397,2).value))print(str(table_cscd.cell(888,1).value))#写入的文件
f = xlwt.Workbook()
sheet1 = f.add_sheet('CSCD和CSD双检',cell_overwrite_ok=True)
row0 = ["分类", "刊名", "ISSN2017-2018", "ISSN2018-2019", "备注1", "备注2", "2018发文量"]
for i in range(0, len(row0)):sheet1.write(0, i, row0[i])#数据处理
i = 1
j = 2
w = 1for i in range(table_csd.nrows - 1):for j in range(table_cscd.nrows - 1):if str(table_csd.cell(i, 2).value) == str(table_cscd.cell(j, 1).value):try:sheet1.write(w, 0, str(table_csd.cell(i, 0).value))sheet1.write(w, 1, str(table_csd.cell(i, 2).value))sheet1.write(w, 2, str(table_csd.cell(i, 3).value))sheet1.write(w, 3, str(table_cscd.cell(j, 2).value))sheet1.write(w, 4, str(table_csd.cell(i, 4).value))sheet1.write(w, 5, str(table_cscd.cell(j, 3).value))sheet1.write(w, 6, str(table_cscd.cell(j, 4).value))w = w + 1print(w)except:print("ERROR")time.sleep(1)else:passf.save("CSCD_and_CSD.xls")
#

CSD.xls文件存放格式

CSCD.xls文件存放格式

生成文件的格式

这篇关于整理CSCD和CSD双检期刊的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---