In week 6, we provide hands-on training in using OpenRefine to standardize variant forms of author and institution names in data obtained from Web of Science.
Verborgh R, De Wilde M. 2013. Using OpenRefine the essential OpenRefine guide that takes you from data analysis and error fixing to linking your dataset to the web. Birmingham, UK: Packt Pub.
Import a .csv file of publication records from Scopus or Web of Science into OpenRefine. If you’re working with Web of Science data, remember to parse the .isi file with Sci2 and then save it as a .csv file first. Clean the data in the author and affiliation columns and then export the file to a new .csv file.
Last modified date: Thu, 10/17/2019 - 3:36pm