在处理文献做review时想要搞清楚互相之间的参考关系,并且按照年份整理,并在不同引用文章中,可以有效去重,这里有一种傻瓜方法,使用excel+python程序比较清晰地列出来一个领域的文献。
步骤:复制参考文献为一个txt文档,并把这个文献命名为一个标号;
按每行读取
获取每行中的年份数字(正则化取数字,转化为int最大的);获取每行的的前缀id
写入新的行 = 年份+标号+前缀id+文献引用格式
import re
f = open("A2.txt","r")
f_w = open("A2_w.txt","w+")
for line in f:
id_num = line.split(" ")[0]
new_id = "A2-"+id_num
x = re.findall(r"\d+\.?\d*",line)
year = int(max(list(map(float,x))))
new_line = str(year) + " "+new_id+" "+line
print(new_line)
f_w.write(new_line)
把新写入的文献复制到excel中,一键排序即可。
如果有多个文献,也可以一起复制到excel中,按照标号能区别是哪个文献的id,并一键排序。
举例:此文献代号命名为A3,并记录(这是为了有一个unique id,方便查找)[1] R. Arandjelovic 虂, P. Gronat, A. Torii, T. Pajdla, and J. Sivic. NetVLAD: CNN architecture for weakly supervised place recognition. In IEEE Conference on Computer Vision and Pattern Recognition (CVPR), 2016. 3
[2] R. Arandjelovic 虂 and A. Zisserman. DisLocation: Scalable descriptor distinctiveness for location recognition . In Asian Conference on Computer Vision (ACCV), 2014. 2
[3] Aubry, Mathieu and Russell, Bryan C. and Sivic, Josef. Painting-to-3D Model Alignment via Discriminative Visual Elements. ACM Transactions on Graphics (TOG), 2014. 2
[4] S. Bell, C. L. Zitnick, K. Bala, and R. Girshick. Inside- Outside Net: Detecting Objects in Context with Skip Pool- ing and Recurrent Neural Networks. In IEEE Conference on Computer Vision and Pattern Recognition (CVPR), 2016. 3, 4
[5] E. Brachmann, A. Krull, S. Nowozin, J. Shotton, F. Michel, S. Gumhold, and C. Rother. DSAC - Differentiable RANSAC for Camera Localization. In IEEE Conference on Computer Vision and Pattern Recognition (CVPR), 2017. 3
经过python程序处理,得到:2016 A3-[1] [1] R. Arandjelovic , P. Gronat, A. Torii, T. Pajdla, and J. Sivic. NetVLAD: CNN architecture for weakly supervised place recognition. In IEEE Conference on Computer Vision and Pattern Recognition (CVPR), 2016. 3
2014 A3-[2] [2] R. Arandjelovic and A. Zisserman. DisLocation: Scalable descriptor distinctiveness for location recognition . In Asian Conference on Computer Vision (ACCV), 2014. 2
2014 A3-[3] [3] Aubry, Mathieu and Russell, Bryan C. and Sivic, Josef. Painting-to-3D Model Alignment via Discriminative Visual Elements. ACM Transactions on Graphics (TOG), 2014. 2
2016 A3-[4] [4] S. Bell, C. L. Zitnick, K. Bala, and R. Girshick. Inside- Outside Net: Detecting Objects in Context with Skip Pool- ing and Recurrent Neural Networks. In IEEE Conference on Computer Vision and Pattern Recognition (CVPR), 2016. 3, 4
2017 A3-[5] [5] E. Brachmann, A. Krull, S. Nowozin, J. Shotton, F. Michel, S. Gumhold, and C. Rother. DSAC - Differentiable RANSAC for Camera Localization. In IEEE Conference on Computer Vision and Pattern Recognition (CVPR), 2017. 3
复制到excel中,可以得到:
使用自带功能一键排序:
即可按照年份查找。多个文献时,也可以较方便地多文献按照年份排序,而不是混淆,并查找出重复文献。