csvcomparer

Description

Compares two or more CSV files (*with Locust results) based on one or multiple columns and outputs an HTML report with the differences.

Installation

• Clone the repository and execute:

pip install .

• Or install directly from the remote repository without cloning, by executing:

pip install git+https://github.com/dhis2-sre/csvcomparer.git

Usage

Sample Locust CSV results are available in the data directory for testing and demo purposes.

• Compare a single column from the current report with the same column from a previous report

csvcomparer \
--current data/dhis_stats.csv \
--previous data/previous_dhis_stats.csv \
--column-name 'Average Response Time'

• Compare multiple columns from the current report with the same columns on multiple previous/baseline reports, based on a custom threshold percentage

csvcomparer \
--current data/dhis_stats.csv \
--previous data/baseline_dhis_stats.csv data/previous_dhis_stats.csv \
--column-name 'Average Response Time,90%' \
--threshold 15

• See more information for the available options

csvcomparer --help

Development setup

To have a development friendly setup - create a virtual Python environment and install in --edittable mode:

virtualenv venv
source venv/bin/activate
pip install --editable .

TODO

• Tests
• Have thresholds per endpoint
• Have better styling for HTML report
• Install with pip install git+URL or make repo public and publish to PyPi?