1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to PySpark
Connected

Exercise

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!

Instructions

100 XP
  • Filter to subset the DataFrame to where company_location is "CA".
  • Calculate the average of the salary_in_usd column.
  • Show the result!