Add other salary data - Githubissues

astrochun / uarizona-salary-app

Streamlit app to illustrate University of Arizona public salary data

https://sapp4ua.onrender.com

MIT License

6 stars 0 forks source link

Add other salary data #48

Closed astrochun closed 3 years ago

astrochun commented 3 years ago

I recently got a CSV table of salary for FY 2012, 2014, 2015, 2016, and 2017.

Note that:

[x] We will need to split out each fiscal year
[x] Column names will be to be changed
[x] Salary columns is formatted with $ and spaces. This need to be simplified to numerical values only.
[x] State fund ratio is provided as percentile. Let's convert this to decimal for consistency

This was provided by @dlebauer.

astrochun commented 3 years ago

To incorporate this data, we need to get fiscal hours for each year. Here's what I found: 2016-17: 2088 hr. See this PDF 2015-16: 2096 hr. See this PDF 2014-15: 2088 hr. See this PDF 2013-14: 2088 hr. There was no PDF, so I did my own calculation

astrochun commented 3 years ago

There are some data wrangling needed for this combined datasets:

It seems FY2014-15 and FY2015-16 are identical. Note that FY2015-16 was not available from Daily WildCat so I think this is a mistake (will exclude)
Some contents are missing such as College Location. As such, there are many NaN for some year. Specifically FY2013-14, FY2014-15, FY2015-16,