In [1]:
import pandas as pd
import bib_parse

In [2]:
cited = bib_parse.bib_to_df('../bibtex/2017-02-01-times_cited_descending.bib')
newest = bib_parse.bib_to_df('../bibtex/2017-02-01-publication_date_newest.bib')
oldest = bib_parse.bib_to_df('../bibtex/2017-02-01-publication_date_oldest.bib')
c180 = bib_parse.bib_to_df('../bibtex/2017-02-01-useage_count_180.bib')
c2013 = bib_parse.bib_to_df('../bibtex/2017-02-01-useage_count_2013.bib')

In [3]:
cited.columns


Out[3]:
Index(['ENTRYTYPE', 'ID', 'abstract', 'address', 'affiliation',
       'article-number', 'author', 'author-email', 'booktitle',
       'cited-references', 'doc-delivery-number', 'doi', 'eissn',
       'funding-acknowledgement', 'funding-text', 'isbn', 'issn', 'journal',
       'journal-iso', 'keyword', 'keywords-plus', 'language', 'month',
       'number', 'number-of-cited-references', 'orcid-numbers', 'pages',
       'publisher', 'research-areas', 'researcherid-numbers', 'times-cited',
       'title', 'type', 'unique-id', 'usage-count-(last-180-days)',
       'usage-count-since-2013', 'volume', 'web-of-science-categories',
       'year'],
      dtype='object')

In [4]:
of_interest = pd.merge(left=cited, right=pd.DataFrame(c2013['unique-id']), on='unique-id', how='inner')

In [5]:
of_interest[['title', 'author', 'times-cited', 'year', 'journal',
             'usage-count-since-2013', 'usage-count-(last-180-days)',
             'web-of-science-categories']].\
    sort_values('year', ascending=False)


Out[5]:
title author times-cited year journal usage-count-since-2013 usage-count-(last-180-days) web-of-science-categories
11 The structure and dynamics of multilayer networks Boccaletti, S. and Bianconi, G. and Criado, R.... 398 2014 PHYSICS REPORTS-REVIEW SECTION OF PHYSICS LETTERS 249 49 Physics, Multidisciplinary
10 Globally networked risks and how to respond Helbing, Dirk 148 2013 NATURE 152 9 Multidisciplinary Sciences
9 Networks formed from interdependent networks Gao, Jianxi and Buldyrev, Sergey V. and Stanle... 282 2012 NATURE PHYSICS 104 16 Physics, Multidisciplinary
8 Statistical physics of social dynamics Castellano, Claudio and Fortunato, Santo and L... 1193 2009 REVIEWS OF MODERN PHYSICS 312 43 Physics, Multidisciplinary
7 Critical phenomena in complex networks Dorogovtsev, S. N. and Goltsev, A. V. and Mend... 843 2008 REVIEWS OF MODERN PHYSICS 249 33 Physics, Multidisciplinary
6 Influentials, networks, and public opinion for... Watts, Duncan J. and Dodds, Peter Sheridan 433 2007 JOURNAL OF CONSUMER RESEARCH 184 27 Business
4 Experimental study of inequality and unpredict... Salganik, MJ and Dodds, PS and Watts, DJ 456 2006 SCIENCE 95 18 Multidisciplinary Sciences
5 Complex networks: Structure and dynamics Boccaletti, S. and Latora, V. and Moreno, Y. a... 3988 2006 PHYSICS REPORTS-REVIEW SECTION OF PHYSICS LETTERS 1105 140 Physics, Multidisciplinary
3 The ``new{''} science of networks Watts, DJ 311 2004 ANNUAL REVIEW OF SOCIOLOGY 96 6 Sociology
2 The structure and function of complex networks Newman, MEJ 6790 2003 SIAM REVIEW 1212 160 Mathematics, Applied
0 Email networks and the spread of computer viruses Newman, MEJ and Forrest, S and Balthrop, J 1303 2002 PHYSICAL REVIEW E 171 24 Physics, Fluids \& Plasmas; Physics, Mathematical
1 Cascade-based attacks on complex networks Motter, AE and Lai, YC 587 2002 PHYSICAL REVIEW E 108 14 Physics, Fluids \& Plasmas; Physics, Mathematical

In [ ]: