Exercise

Complex Aggregations

To get you familiar with more of the built in aggregation methods, let's do a slightly more complex aggregation! The goal is to merge all these commands into a single line.

Remember, a SparkSession called spark is already in your workspace, along the Spark DataFrame salaries_df.

Instructions

100 XP

Calculate the average salaries of large US companies using the "salary_in_usd" column.
Calculate the total salaries of large US companies.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise