Filtering by company
Using that same dataset from the last exercise, you realized that you only care about the jobs that are entry level ("EN") in Canada ("CA"). What does the salaries look like there?
Remember, there's already a SparkSession called spark in your workspace!
Bu egzersiz
Introduction to PySpark
kursunun bir parçasıdırEgzersiz talimatları
- Filter to subset the DataFrame to where
company_locationis"CA". - Calculate the average of the
salary_in_usdcolumn. - Show the result!
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
# Average salary for entry level in Canada
CA_jobs = ca_salaries_df.____(ca_salaries_df[____] == "CA").filter(ca_salaries_df['experience_level']
== "EN").groupBy().____("salary_in_usd")
# Show the result
CA_jobs.____()