$./WKFusion
Raw WKF exports in. Clean, role-split data out.
Transform raw WKF competition exports into clean, role-split datasets in seconds. Handles multi-database event structures, infers participant roles from filenames, and outputs Excel statistics alongside ready-to-use CSVs.
[MODE] Single-DB detected (flat input/) [SCAN] 6 CSV files found [ROLE] referees.csv -> referee [ROLE] coaches_hr.csv -> coach [ROLE] competitors.csv -> competitor [NORM] 1,842 records cleaned [OUT ] 4 role-split CSVs written [OUT ] statistics_report.xlsx [DONE] run completed in 2.4s
Built for WKF data
+ Single & Multi-DB Processing
Process a single event database or batch-process multiple events stored in separate subdirectories — all in one run.
+ Auto-Role Detection
WKFusion infers participant roles (official, referee, coach, competitor) directly from source filenames — no manual tagging.
+ Excel Statistics
Generates a full Excel report with per-role statistics, aggregates, and a summary sheet per processing run.
+ Zero Config
Drop CSVs in the input folder, run the script, get clean data out. No database connection, no server, no config files.
Processing Pipeline
Drop Input CSVs
Place semicolon-separated CSV files exported from Sportdata SET software into the input/ directory.
Role Inference
WKFusion scans filenames and infers roles: officials, referees, coaches, competitors.
Data Normalisation
Cleans records, standardises field names, handles encoding, removes duplicates.
Role Splitting
Outputs separate CSV files per role with consistent column structure.
Excel Report
Generates statistics_report.xlsx with per-role counts, aggregates, and summary.
The full tutorial
Folder layouts for single and multi-database events, the exact filename-to-role rules with a live detector you can type into, what gets normalised, and every output file you get back.