Python:

a$.$ Calculate the total sales and profit for each state grouped by year. $[10$

mins$]$

i$.$ Output format : $[$Year$,$ State, $Sales, $Profit$]$

b$.$ Calculate the moving average $Sales and $Profit every week considering

a window of $4$ weeks in $2016$ to $2017.$ Also calculate the relative

delta$/$difference between every week in $Profit. $[20$ mins$]$

i$.$ Note: Relative delta $-$ If the sales last week was $10$K and current

week the sales is $8$K then the relative delta is $-20\%.$