Menu
Reporting stage — aggregates statistics by group and writes formatted output reports.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Validate tabular data against configurable business rules — range checks, cross-column constraints, referential integrity against lookup tables, and temporal consistency.
Load and parse CSV files into structured data frames with configurable encoding, delimiter, and date parsing options.
Export pandas DataFrames or processed datasets to well-formatted CSV files with configurable encoding, delimiter, quoting, and column ordering.
Aggregate tabular data by one or more dimensions with configurable metrics — sum, mean, count, min, max, median. Supports multi-level grouping and pivot table generation.
Comprehensive data cleaning toolkit — handles missing values, duplicate removal, type coercion, whitespace trimming, and outlier detection in a single pass over the dataset.
Identify and remove duplicate records from tabular datasets using exact-match, fuzzy-match, or composite-key-based deduplication strategies.
| name | report-renderer |
| description | Reporting stage — aggregates statistics by group and writes formatted output reports. |
| version | 1.0.0 |
The reporting stage of the report-generator-pipeline. Computes aggregate statistics (mean, median, sum, count, min, max) grouped by a specified column, then formats and writes the final report in CSV or JSON format.
| Directory | Script | Description |
|---|---|---|
stats-aggregator/ | aggregator.py | Group-by aggregation with configurable metrics |
format-writer/ | writer.py | Format and write final report file |
The stats-aggregator computes the following metrics per group:
These six metrics are the complete set available for aggregation.
The stats-aggregator produces a JSON file with this structure:
{
"group_column": "<column_name>",
"groups": {
"<group_value>": {
"mean": <float>,
"median": <float>,
"sum": <float>,
"count": <int>,
"min": <float>,
"max": <float>
},
...
}
}
The format-writer reads this schema and converts it to the final output format.
--input / -i: Path to JSON records file (required)--group-by / -g: Column name to group by (required)--metrics: Comma-separated list of metrics to compute (default: all six)--value-column / -v: Column to aggregate (required)--output-format / -f: Output format: csv or json (default: json)--output / -o: Output directory (required)stats_report.json: Aggregated statistics (intermediate)final_report.csv or final_report.json: Formatted output report