Compare Adjacent Rows and Group Data by a Specific Interval
Jan 6, 2021
Below is part of the Excel file data.xlsx:
dt column stores datetimes; val column stores numbers. Task: group rows every 10 minutes and calculate average of val alues in each group. Below is part of the expected result:
It’s convenient to get the task done with esProc. Download esProc installation package and free license file HERE.
1. Write script avg.dfx in esProc:
2. Execute the script and A4 is the expected result.
