In this tutorial, you'll learn how to create an interactive Excel dashboard from scratch, focusing on the richest people in ...
spark.sql("SELECT Region, SUM(CASE WHEN Fruit = 'Apple' THEN Sales ELSE 0 END) AS Apple, SUM(CASE WHEN Fruit = 'Banana' THEN Sales ELSE 0 END) AS Banana FROM sales GROUP BY Region").show() # Exercise ...