unsub
unsub is a collection analysis tool that assists libraries in analyzing their journal subscriptions. The tool provides rich data and a summary graph, but more detailed analysis tends to take place off the site in an exported .csv file that allows for filtering, notes, and additional visualization.
This project, unsub extender, is a Python script that takes an unsub data export file and automates useful plots and visualizations for a collection analysis team to explore. The graphs are interactive through Altair and support zoom, pan, and hover, and filters in the left sidebar help set parameters to quickly narrow in on obvious titles to KEEP or CANCEL. The Python code is turned into a web app using Streamlit.
Hosting provided by Iowa State University.
Requirements
An unsub export .csv file - from an unsub project, choose "Export - Download as spreadsheet".
A .csv file will be saved, which is the input to unsub extender.
The .csv file must have the following columns in any order, but named exactly as:
- title
- downloads
- citations
- authorships
- usage
- subscription_cost
- subscribed
- cpu
- cpu_rank
- use_ill_percent
- use_oa_percent
- use_other_delayed_percent
These should already be the default column names assigned by unsub in the file export.
subscribed column
The subscribed column is especially important as it determines the color-coding of data points in several of the graphs. The column accepts the following values:
(TRUE and FALSE are conventions carried over from unsub, MAYBE is supported as a third option for future consideration, and leaving the cell blank will color that journal data point grey):
- TRUE
- A title to keep, displayed in blue
- FALSE
- A title to cancel, displayed in red
- MAYBE
- A title to think more about, displayed in green
- (blank)
- A title with no decision yet, displayed in grey
Usage
Hosted by Iowa State University
Navigate to https://unsubextender.lib.iastate.edu to run in browser
