القائمة
Format and write final report from stats aggregation results in CSV or JSON format.
التثبيت باستخدام Codex أو Claude انسخ هذا Prompt والصقه في Codex أو Claude أو مساعد آخر ليراجع صفحة Skill ويثبّتها لك.
استنادا إلى تصنيف SOC المهني
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 | format-writer |
| description | Format and write final report from stats aggregation results in CSV or JSON format. |
| version | 1.0.0 |
Takes a stats aggregation JSON file (produced by stats-aggregator) and converts it into the
final output format. Supports CSV and JSON output. The input must follow the stats-aggregator
output schema: a group_column field and a groups dict mapping group names to metric dicts
containing mean, median, sum, count, min, and max values.
The input JSON must match this structure:
{
"group_column": "<name>",
"groups": {
"<group>": {"mean": ..., "median": ..., "sum": ..., "count": ..., "min": ..., "max": ...},
...
}
}
No other fields are expected. The writer iterates over each group and outputs one row per group with all available metrics as columns.
--input / -i: Path to stats_report.json (required)--format / -f: Output format: csv or json (default: json)--output / -o: Output directory (required)final_report.csv or final_report.jsonfinal_report.csv or final_report.jsonpython3 format-writer/writer.py -i stats_report.json -f json -o <dir>json, csv, argparse, os)