数据库来源
EI
https://www.elsevier.com/solutions/engineering-village/content/compendex
https://st.xauat.edu.cn/info/1019/3679.htm
查单个期刊
https://mjl.clarivate.com/home?PC=K
数据库导出
受保护的数据库导出
file = 'CPXSourceList012022.xlsx';
fileout = 'ei.xlsx';
sheet = 'SERIALS';
[a,b,c] = xlsread(file,sheet);
xlswrite(fileout,c);
N = size(c,1);
for k = 3:N
if(~isnan(c{k,1}))
disp(c{k,1});
end
end
批量判断期刊索引
papers.csv 第一列为自己的期刊,第二列为SCIE,第三列为EI。全选,把&全部换成and。
# -*- coding: utf-8 -*-
import pandas as pd
import numpy as np
file = 'papers.csv'
d = pd.read_csv(file,header=None)
ei = set(d[2].str.upper())
scie = set(d[1].str.upper())
pp = set(d[0].str.upper())
try:
pp.remove(np.nan)
except:
print('no nan')
try:
ei.remove(np.nan)
except:
print('no nan')
try:
scie.remove(np.nan)
except:
print('no nan')
numRows = len(pp)+1
numCols = 3
da = pd.DataFrame(index=range(numRows),columns=range(numCols))
h=('title', 'scie','ei')
da.iloc[0]=h
m=0
for p1 in pp:
m=m+1
p = p1
da.iloc[m,0] = p
if(~pd.isna(p)):
if(p in scie):
da.iloc[m,1] = 1
print('SCIE: ' + p)
else:
da.iloc[m,1] = 0
p=p1
if(~pd.isna(p)):
if(p in ei):
da.iloc[m,2] = 1
print('EI: ' + p)
else:
da.iloc[m,2] = 0
print('--output--')
try:
da.to_csv('out.csv',index=0,header=0,encoding='UTF-8-sig')
print('out.csv saved')
except:
print('writing file error')
输出的结果
ISTP (CPCI)查询
https://www.webofscience.com/wos/woscc/basic-search
如需完整工程源码,请发送邮件到
SemiconductorPhysics@protonmail.com,标题加 CSDN, 说明身份和使用原因。谢谢!