stats: document zero_padded_numeric; bump stat count 47 -> 48 Reflects PR #3934 (qsv #3938): the new --zero-padded-numeric flag/column brings the stats summary-statistic count to 48. Document the flag in the main stats page (Aggregation-and-Statistics) and bump the 47 -> 48 count across the pages that cite it. The xsv-vs-qsv-1.0.0 legacy snapshot in Comparison.md and the describegpt 47-token content-type vocabulary are intentionally left as-is. Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>

jqnatividad committed Jun 3, 2026

docs(wiki): re-home color and pro to their natural categories color and pro lived on the AI & Documentation page for historical reasons, but neither has any LLM/AI surface — color is just a colorized table renderer, and pro is a desktop-app bridge. Now that synthesize has joined describegpt on the AI page, the mis-categorization stood out more. - AI & Documentation: drop the color and pro sections; trim the decision-table rows and the "color is the colorized cousin..." sentence in the intro; leave a redirect note pointing readers to the new homes - Selection & Inspection: add color right after table (its uncolored cousin); decision-table row; cross-link both directions - Integrations: add a "qsv pro Bridge" section covering the pro subcommands (lens, workflow) - Command Reference: move the color row into Selection & Inspection; add an "Integrations & Bridges" mini-section housing pro - Environment-Variables, Recipe-Inspect-Unknown-CSV, qsv-pro-Spotlight: rewrite stale AI-and-Documentation#color / #pro anchors to point at the new homes Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

jqnatividad committed May 18, 2026

wiki: Phase C batch 1 - Cookbook index + 3 beginner recipes Cookbook index now categorizes 12 recipes by goal (inspect / clean / enrich / validate / aggregate / combine / big files / integration) with anchor dataset and command columns. Legacy snippets (CKAN, Date Enrichment, multi-table join, cat varying columns, geocode) preserved at the bottom of the index with pointers to the expanded Recipe pages. Recipe-Inspect-Unknown-CSV: sniff -> headers -> count -> stats -> frequency -> sample -> table walkthrough on wcp.csv, ~0.7s for full stats on 2.7M rows. Variations: remote sniff, describegpt natural- language summary, colorized output. Recipe-Clean-and-Normalize: 6-step pipeline on Boston 311 covering input --auto-skip, safenames, regex replace of sentinel nulls, group-by fill, sort+dedup with audit trail. Variations: applydp for CKAN, pseudonymization, censoring, schema validation. Recipe-Date-Enrichment: expands the legacy date-enrichment snippets on NYC 311. Adds Year/YearMonth/Weekday/Quarter/TAT columns via datefmt + getquarter.lua + turnaroundtime.lua; partitions output by quarter. Variations: Brooklyn-only TAT, regex date columns, SQL- style aggregation, business-hours filter. Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

jqnatividad committed May 13, 2026

wiki: add stubs for Phase B/C/D/E pages so sidebar links resolve Adds 39 placeholder pages so every sidebar entry resolves to real content rather than a 404. Each stub declares its tier, the phase it will be filled in, and a one-paragraph preview of what's coming. They link back to Home / Getting-Started / Command-Reference / Cookbook for navigation. Pages added: - Phase B (Command Reference, 13): Command-Reference, Selection-and- Inspection, Transform-and-Reshape, Aggregation-and-Statistics, Joins- and-Set-Ops, SQL-and-Polars, Validation-and-Schema, Conversion-and-IO, Geospatial, HTTP-and-Web, Scripting-Luau-Python, Indexing-Compression- Diff, AI-and-Documentation - Phase C (Cookbook recipes, 12): Recipe-Inspect-Unknown-CSV, Recipe- Clean-and-Normalize, Recipe-Geographic-Enrichment, Recipe-Date- Enrichment, Recipe-CKAN-Integration, Recipe-JSON-Schema-Validate, Recipe-Build-a-Data-Pipeline, Recipe-Stats-to-Insights, Recipe-Fetch- and-Cache, Recipe-Larger-than-RAM, Recipe-Diff-and-Audit, Recipe-Multi- Table-Joins - Phase D (Tuning + ecosystem, 8): Performance-Tuning, Environment- Variables, Stats-Cache-and-Caching, Lookup-Tables, Claude-Cowork-Plugin, MCP-Server, qsv-pro-Spotlight, Integrations - Phase E (Polish, 6): Troubleshooting, FAQ, Comparison, Glossary, External-Resources, Contributing-to-the-Wiki Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>

jqnatividad committed May 13, 2026