A company is contemplating a switch from their current hot water supply system to off$-$peak electricity as a means of reducing their energy costs. The off$-$peak electricity period, which runs from $21$:$00$ to $7$:$00,$ is available at a much lower rate of one$-$third of the current rate for the entire day. This option could potentially result in significant cost savings for the company.

The weekly hot water consumption was monitored. The averaged values and the recorded flow meter data and can be found in the Excel file $$Weekly flowrate data.xlsx$.$

Our task is to compare the daily and weekly water consumption of the averaged values and the flowmeter data. Use python codeThe flowrate data from excel file is below: $[$time$,$ min$][$V$,$ l$/$min$]$

$62$

$3602$

$360\mathrm{.}67$

$10807$

$1080\mathrm{.}61$

$14401$

$14462$

$18002$

$1800\mathrm{.}67$

$25207$

$2520\mathrm{.}61$

$28801$

$28862$

$32402$

$3240\mathrm{.}67$

$39607$

$3960\mathrm{.}61$

$43201$

$43262$

$46802$

$4680\mathrm{.}67$

$54007$

$5400\mathrm{.}61$

$57601$

$57664$

$61204$

$6120\mathrm{.}610$

$684010$

$6840\mathrm{.}62$

$72002$

$72061$

$75601$

$7560\mathrm{.}61$

$82801$

$8280\mathrm{.}61$

$86401$

$86461$

$90001$

$9000\mathrm{.}61$

$97201$

$9720\mathrm{.}61$

$100801$

Use the python code as shown the photo to solve the question