Overview

Python app - process and summarise activity lines from CSV

Installation

1. Requirements: python3 - suggest installing via Homebrew [https://brew.sh/] for convenience

Usage

1. Download to local
2. Generate your csv file of activities

• header format: Date, Activity, Duration
• each row:
  • date in format dd/mm/yyyy
  • category and activity text
    • note: dash (-) is optional and will be removed
    • note: any detail after the pipe (|) character (for example TMI below) will be removed
    • commas (') must be escaped by surrounding with double-quotes ("")
  • duration in format [optional hours]:minutes:seconds

For example:

28/04/2025, "INTERNAL - Doctor appointment | TMI, surround commas with quotes", 30:00

3. Run this script:

python3 activityprocessor.py path/to/your/.csv

You will be warned if the header doesn't match and/or any csv rows are malformed.

License

This is free and unencumbered software released into the public domain.

Anyone is free to copy, modify, publish, use, compile, sell, or distribute this software, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means.

Development testing

Via shell

pytest -v

Or use VS Code Testing :)