Welcome to a quick exercise for you to practice your pandas skills! We will be using the SF Salaries Dataset from Kaggle! Just follow along and complete the tasks outlined in bold below. The tasks will get harder and harder as you go along.
Import pandas as pd.
In [1]:
import pandas as pd
Read Salaries.csv as a dataframe called sal.
In [2]:
sal = pd.read_csv('salaries.csv')
Check the head of the DataFrame.
In [4]:
sal.head()
Out[4]:
In [14]:
sal.describe()
Out[14]:
Use the .info() method to find out how many entries there are.
In [5]:
sal.info()
What is the average BasePay ?
In [7]:
sal.BasePay.mean()
Out[7]:
What is the highest amount of OvertimePay in the dataset ?
In [8]:
sal.OvertimePay.max()
Out[8]:
What is the job title of JOSEPH DRISCOLL ? Note: Use all caps, otherwise you may get an answer that doesn't match up (there is also a lowercase Joseph Driscoll).
In [9]:
sal[sal['EmployeeName']=='JOSEPH DRISCOLL'].JobTitle
Out[9]:
How much does JOSEPH DRISCOLL make (including benefits)?
In [10]:
sal[sal['EmployeeName']=='JOSEPH DRISCOLL'].TotalPayBenefits
Out[10]:
What is the name of highest paid person (including benefits)?
In [11]:
sal[sal['TotalPayBenefits'] == sal.TotalPayBenefits.max()]
Out[11]:
What is the name of lowest paid person (including benefits)? Do you notice something strange about how much he or she is paid?
In [12]:
sal[sal['TotalPayBenefits'] == sal.TotalPayBenefits.min()]
Out[12]:
What was the average (mean) BasePay of all employees per year? (2011-2014) ?
In [15]:
sal.groupby('Year').BasePay.mean()
Out[15]:
How many unique job titles are there?
In [16]:
sal['JobTitle'].nunique()
Out[16]:
What are the top 5 most common jobs?
In [19]:
sal['JobTitle'].value_counts()[:5]
Out[19]:
How many Job Titles were represented by only one person in 2013? (e.g. Job Titles with only one occurence in 2013?)
In [24]:
one_person_jos = sum(sal[sal['Year']==2013]['JobTitle'].value_counts()==1)
one_person_jos
Out[24]:
How many people have the word Chief in their job title? (This is pretty tricky)
In [28]:
def chief_in_title(title):
if 'chief' in title.lower():
return True
else:
return False
In [29]:
sum(sal['JobTitle'].apply(chief_in_title))
Out[29]:
In [30]:
sum(sal['JobTitle'].apply(lambda x : chief_in_title(x)))
Out[30]:
Bonus: Is there a correlation between length of the Job Title string and Salary?
In [31]:
sal['title_len'] = sal['JobTitle'].apply(len)
In [32]:
sal[['title_len', 'TotalPayBenefits']].corr()
Out[32]: