情报探索
情報探索
정보탐색
INFORMATION RESEARCH
2015年
6期
86-89
,共4页
Web of Science(WoS)%关键词%词频统计%Excel%BibTex%Visual Basic(VB)
Web of Science(WoS)%關鍵詞%詞頻統計%Excel%BibTex%Visual Basic(VB)
Web of Science(WoS)%관건사%사빈통계%Excel%BibTex%Visual Basic(VB)
Web of Science (WoS)%keywords%word frequency statistics%Excel%BibTex%Visual Basic (VB)
使用Visual Basic编程,采用正则表达式批量提取由Web of Science导出的BibTex题录中所有Keywords字段关键词,按需合并所得关键词的同义词、近义词及词形变化词,然后将出现频度的统计数据写入Excel表,并编制Excel宏自动生成折线图,实现关键词分布的简单可视化。情报工作者后续可借助Excel功能对该程序生成的Excel表执行复杂的数据组合分析,以提高工作效率。
使用Visual Basic編程,採用正則錶達式批量提取由Web of Science導齣的BibTex題錄中所有Keywords字段關鍵詞,按需閤併所得關鍵詞的同義詞、近義詞及詞形變化詞,然後將齣現頻度的統計數據寫入Excel錶,併編製Excel宏自動生成摺線圖,實現關鍵詞分佈的簡單可視化。情報工作者後續可藉助Excel功能對該程序生成的Excel錶執行複雜的數據組閤分析,以提高工作效率。
사용Visual Basic편정,채용정칙표체식비량제취유Web of Science도출적BibTex제록중소유Keywords자단관건사,안수합병소득관건사적동의사、근의사급사형변화사,연후장출현빈도적통계수거사입Excel표,병편제Excel굉자동생성절선도,실현관건사분포적간단가시화。정보공작자후속가차조Excel공능대해정서생성적Excel표집행복잡적수거조합분석,이제고공작효솔。
The paper takes Visual Basic as programming tool and uses regular expression to extract keywords filed data in batches from BibTex bibliography derived from Web of Science, combines synonyms, homoionyms and morphological changes of words as need-ed, then writes the keywords frequency statistics in Excel graph, and programs an Excel macro to draw broken line graph automatically to visualize the data. Information workers can further carry out complex data portfolio analysis of the Excel files by using Excel to im-prove their working efficiency.