Calculating salary percentiles
In the video, you saw that the conversion of numeric data into categories sometimes makes it easier to identify patterns.
Your task is to convert the "Salary_USD" column into categories based on its percentiles. First, you need to find the percentiles and store them as variables.
pandas has been imported as pd and the salaries dataset read in as DataFrame called salaries.
This exercise is part of the course
Exploratory Data Analysis in Python
Exercise instructions
- Find the 25th percentile of
"Salary_USD". - Store the median of
"Salary_USD"assalaries_median. - Get the 75th percentile of salaries.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Find the 25th percentile
twenty_fifth = ____["____"].____(____)
# Save the median
salaries_median = ____["____"].____()
# Gather the 75th percentile
seventy_fifth = ____
print(twenty_fifth, salaries_median, seventy_fifth)