utils

Utilities

Turps (Linear interpolator)

This script linearly interpolates the log files once they have been converted from sqlite to excel. This merges all sheets / devices into a single sheet by linearly interpolating between data points.

Installation

pandas, numpy and openpyxl are required. Install these with:

pip3 install pandas numpy openpyxl

Usage

usage: turps.py [-h] -i INPUT -o OUTPUT [-t TIME_STEP]

Linearly interpolates between DAS log files and merges all tables.
This script loads a spreadsheet converted from a DAS log file and resamples all sheets to a single table. The output is saved to a csv file.

Of special note, the pandas library needs to be installed (pip install pandas).

Example:
./turps.py -i runfile_2023-09-15_14-12-37.xlsx -o runfile_2023-09-15_14-12-37.csv -t 0.5

options:
  -h, --help            show this help message and exit
  -i INPUT, --input INPUT
                        The input file (excel spreadsheet)
  -o OUTPUT, --output OUTPUT
                        The output file (csv)
  -t TIME_STEP, --time-step TIME_STEP
                        The time step of the output in seconds.

Written by Jotham Gates for Monash Human Power (MHP), 2023.