Comparing salaries
Exploratory data analysis is a crucial step in generating hypotheses!
You've had an idea you'd like to explore—do data professionals get paid more in the USA than they do in Great Britain?
You'll need to subset the data by "Employee_Location"
and produce a plot displaying the average salary between the two groups.
The salaries
DataFrame has been imported as a pandas DataFrame.
pandas
has been imported as pd
, maplotlib.pyplot
as plt
and seaborn
as sns
.
This exercise is part of the course
Exploratory Data Analysis in Python
Exercise instructions
- Filter
salaries
where"Employee_Location"
is"US"
or"GB"
, saving asusa_and_gb
. - Use
usa_and_gb
to create a barplot visualizing"Salary_USD"
against"Employee_Location"
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Filter for employees in the US or GB
usa_and_gb = salaries[____["____"].____(["____", "____"])]
# Create a barplot of salaries by location
sns.____(data=____, x="____", y="____")
plt.show()