Tutorial by Examples: cumulative

import operator reduce(operator.mul, [10, 5, -3]) # Out: -150

Using the Item Sales Table, we will try to find out how the sales of our items are increasing through dates. To do so we will calculate the Cumulative Sum of total sales per Item order by the sale date. SELECT item_id, sale_Date SUM(quantity * price) OVER(PARTITION BY item_id ORDER BY sale...

To calculate moving average of salary of the employers based on their role: val cumSum = sampleData.withColumn("cumulativeSum", sum(sampleData("Salary")) .over( Window.partitionBy("Role").orderBy("Salary"))) orderBy() sorts salary column an...

A very useful and logical follow-up to histograms and density plots would be the Empirical Cumulative Distribution Function. We can use the function ecdf() for this purpose. A basic plot produced by the command plot(ecdf(rnorm(100)),main="Cumulative distribution",xlab="x") wo...