pycounter makes working with COUNTER usage statistics in Python easy, including fetching statistics with NISO SUSHI.
A simple command-line client for fetching JR1 reports from SUSHI servers and outputting them as tab-separated COUNTER 4 reports is included.
Developed by the Health Sciences Library System of the University of Pittsburgh to support importing usage data into our in-house Electronic Resources Management (ERM) system.
Licensed under the MIT license. See the file LICENSE for details.
pycounter is tested on Python 2.6, 2.7, 3.3, 3.4, 3.5, 3.6 and pypy2
Documentation is on Read the Docs.
From pypi:
pip install pycounter
From inside the source distribution:
python setup.py install
About dependencies: pycounter uses lxml, an XML parsing library with a C extension. It requires libxml2 and libxslt to be installed to build correctly. It may be helpful to install lxml manually before installing pycounter, either with the Windows binary installers, a linux distro package, or with macports or homebrew on OS X. See the lxml installation docs for more information.
Parsing COUNTER reports (currently supports COUNTER 3 and 4, in .csv, .tsv, or .xlsx files, reports JR1, DB1, DB2, BR1, and BR2):
>>> import pycounter.report
>>> report = pycounter.report.parse("COUNTER4_2015.tsv") # filename or path to file
>>> print(report.metric)
FT Article Requests
>>> for journal in report:
... print(journal.title)
Sqornshellous Swamptalk
Acta Mattressica
>>> for stat in report.pubs[0]:
... print(stat)
(datetime.date(2015, 1, 1), 'FT Article Requests', 120)
(datetime.date(2015, 2, 1), 'FT Article Requests', 42)
(datetime.date(2015, 3, 1), 'FT Article Requests', 23)
Fetching SUSHI data:
>>> import pycounter.sushi >>> import datetime >>> report = pycounter.sushi.get_report(wsdl_url='http://www.example.com/SushiService', ... start_date=datetime.date(2015,1,1), end_date=datetime.date(2015,1,31), ... requestor_id="myreqid", customer_reference="refnum", report="JR1", ... release=4) >>> for journal in report: ... print(journal.title) Sqornshellous Swamptalk Acta Mattressica
Output of report as TSV:
>>> report.write_tsv("/tmp/counterreport.tsv")