Skip to content

astrochun/uarizona-salary-app

Repository files navigation

uarizona-salary-app

Streamlit app to illustrate University of Arizona salary data.

Deployed as Heroku at: https://sapp4ua.herokuapp.com

TL;DR:
This is a website providing public salary data for the University of Arizona. It is a "Choose Your Own Data Science" tool, so just explore with different "data views" on the sidebar!

More information:
This site was developed to allow easy extraction, analysis, and interpretation of salary data from the University of Arizona.
It is built and maintained by one volunteer, Chun Ly.

This code is built purely with open-source software, specifically python, streamlit, bokeh, and pandas.

The source code is available on GitHub!

If you have suggestions or encounter an issue, please feel free to submit an issue request on GitHub!

As this is open source, we welcome contributions by forking the repository, and submitting a pull request!

This app was developed because I felt it was an important issue that requires greater transparency.
I maintain and develop this in my free time. With additional data, I hope to extend this application's resources.

You can begin your data journey by selecting a "data view" on the sidebar:

  1. Individual Search 🆕 : Find all salary data for individual(s)
  2. Trends: General facts and numbers (e.g. number of employees, salary budget, etc.), for each fiscal year
  3. Salary Summary: Statistics and percentile salary data, includes salary histogram
  4. Highest Earners (Updated): Extract data above a minimum salary. Now you can select a given college/division
  5. College/Division Data: Similar to Salary Summary but extracted for each college(s)/division(s)
  6. Department Data: Similar to Salary Summary but extracted for each department(s)

Enjoy!
‐ Chun 🌵

Sponsorship:
If you find this website beneficial, please consider making a small monetary donation either through GitHub or PayPal.Me (click on the Sponsor button). This support ensures that this project will:

  1. Grow to provide more data, tools, and visualizations, and
  2. Continue to be an open-source transparent resource for our community.

Your donations will be highlighted below.

This project has been sponsored by these gracious folks:

Continued donors:

  1. Casper da Costa-Luis

One-time donors:

  1. John Moeller
  2. Sedona Heidinger

Sources:
The salary data are made available from the The Daily WildCat. Links are available for:

  1. FY2019-20 (Google Sheets). Extracted and converted to a machine-readable version by Michael Clarkson.
  2. FY2018-19 (Google Sheets)
  3. FY2017-18 (Google Sheets)
  4. FY2011-12, FY2013-14, FY2014-15, FY2015-16, FY2016-17: These data were made available by Dr. David Le Bauer, obtained from older records from The Daily Wildcat (Google Sheets are currently not available/public)

Inflation data shown on Wage Growth plots were obtained from the U.S. Bureau of Labor Statistics using their Consumer Price Index (CPI) Inflation Calculator. Calculations were either over a 1- or 2-year period (depending on prior year's data) and adopted FY start (e.g., July 2017 to July 2018).