Calculate the total sales amount for each region and store the results in a new dataframe called region_sales.
Given the expected result:
Which code will generate the expected result?
region_sales = sales_df.groupBy("region").agg(sum("sales_amountM).alias("total_sales_amount"))
region_sales = sales_df. sum ("salen_aiTiount") . groupBy ("region") .alias ("total_sale3_amount")
region_sales= sales_df.groupBy("category").sum(nsales_amount").alias("t_otal_sales_amounl")
region sales - sales_df.agg(sum("sales_amount").groupBy("region").alias("total sales amount"))
Submit