sci参考文献格式一键整理

web of science

1 选中需要引用的文献，选择导出excel格式

2 自定义引用需要的数据类型

3 然后导出到某个文件夹，并搭配Python代码

import pandas
import pandas as pd#导入pandas库
fm=pd.read_excel(r"C:/Users/sdlxl/Downloads/savedrecs.xls",sheet_name="savedrecs")#用该方法读取表格和表单里的单元格的数据

data=fm[['Publication Type','Authors','Article Title','Source Title','Volume','Issue','Start Page','End Page','Publication Year']]
for index, row in data.iterrows():
    PublicationType = row['Publication Type']
    Authors = row['Authors'].replace(";", ",") 
    ArticleTitle = row['Article Title']
    SourceTitle = row['Source Title'].title() 
    Volume = row['Volume']
    Issue = row['Issue']
    StartPage = row['Start Page']
    EndPage = row['End Page']
    PublicationYear = row['Publication Year']
    sentence =f"{Authors},{PublicationYear}.{ArticleTitle}.{SourceTitle}.{Volume},{StartPage}-{EndPage}."
    
    print(sentence)
    print()

    

注意修改成自己的文件夹哦~
当然，可以根据代码生成自己需要的文件格式。

4 生成示例