The script should use as input the supplied publication data from Web of Knowledge (format: tab-delimited) and produce as output 3 tables readable in Excel. The goal is to look into the references of a number of scientific publications and to output pairs of articles that are systematically cited within the same scientific publication.
3 tables readable in Excel (details and data sample are attached). The 1st table contains a list of all the pairs of referenced papers meeting a few simple criteria: (a) cited in the same paper, (b) no common author, and (c) same publication year (+ or - 1 year) The 2nd table provides some information on each publication (row) of the input data (e.g. number of within sample citations) The 3rd table includes a simple combination of the data from the first two tables.
The script should preferably by written in Python and operate on Windows 7 and run on a Linux server