1 of 7

Analysis of San Francisco Salaries 2011 -2014

By Anita Kiricenko

2018-07-22

2 of 7

Basic information

  • Name of the data: San Francisco Salaries
  • Data source: Transparent California, 2011-2014 Salaries of San Francisco city government employees*
  • The aim of the project is to analyse how the employee pay changed over the period of four years.
  • Assumption - the employee pay went up

​

* I used modified version of the data from Kaggle.com

​

3 of 7

The head of the dataset “Salaries”

4 of 7

General Facts About the Dataset

​

  • Columns: 11
  • Column names:

Id, EmployeeName, JobTitle, Basepay, Overtime, OtherPay, Benefits, TotalPay, TotalPayBenefits, Year, Agency

  • Rows(entries): 148654
  • The dataset was analysed in Python Notebook. Mostly Pandas library was used

5 of 7

Basic statistics on the average pay by year

  • The mean of the TotalPayBenefits went up over 4 years with slight decrease in 2014
  • The highest salary was paid in 2011
  • The number of workers increased over 4 years almost by 2 thousand
  • There is much more variation among salaries paid in both 2013 and 14 compared to 2011

​

6 of 7

Boxplot of salaries paid over 4 years

7 of 7

Results

  • The average pay went up with slight decrease in the last year
  • There is much more variability among salaries paid
  • In order to avoid false conclusions, it is advised to look for the pay change among the same employee groups over time