agentCLAWHUBUnverified

Clean CSV Toolkit

Local CSV / TSV / JSONL inspection and cleanup toolkit. Profile, validate, deduplicate, diff, preview (head/tail/random sample), filter with a safe predicate... Skill: Clean CSV Toolkit Owner: gopendrasharma89-tech Summary: Local CSV / TSV / JSONL inspection and cleanup toolkit. Profile, validate, deduplicate, diff, preview (head/tail/random sample), filter with a safe predicate... Tags: aggregation:0.3.0, column:0.5.0, concat:0.4.0, convert:0.2.0, csv:0.5.0, data:0.3.0, dedupe:0.2.0, derive:0.5.0, diff:0.2.0, expression:0.5.0, filter:0.5.0, groupby:0.4.0, head:0.2.0, join:0

OpenClaw

Rank

62

Safety

84

Downloads

1.2k

Updated

Oct 11, 2026

Version

0.5.0

Source

CLAWHUB

About

What it does, and when to use it.

Capability contract not published. No trust telemetry is available yet. 1.2K downloads reported by the source. Last updated 10/11/2026.

Avoid when

  • Contract metadata is missing or unavailable for deterministic execution.

Risk flags: missing_or_unavailable_contract, trust_data_unavailable, schema_references_missing

Public facts

Every fact links back to the source it came from.

Vendor
Clawhubvendor · observed Oct 11, 2026
Protocol compatibility
OpenClawcompatibility · observed Oct 11, 2026
Adoption signal
1.2K downloadsadoption · observed Oct 11, 2026
Latest release
0.5.0release · observed May 21, 2026
Handshake status
UNKNOWNsecurity

Install and run

Setup complexity: low.

clawhub skill install s17cp87fy279ggwne1mqcb6675843tdy:clean-csv-toolkit
  1. Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.
  2. Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data.

Contract: missing

curl -s "https://www.xpersona.co/api/v1/agents/clawhub-gopendrasharma89-tech-clean-csv-toolkit/snapshot"

Documentation

CLAWHUB

95,150 characters of source documentation, loaded on request.

Extracted files

4 files captured from the source.

SKILL.md

---
name: clean-csv-toolkit
description: Local CSV / TSV / JSONL inspection and cleanup toolkit. Profile, validate, deduplicate, diff, preview (head/tail/random sample), filter with a safe predicate language, sort, concat, merge (inner/left/right/outer joins), pivot (group-by aggregations + wide cross-tabs), transform (derived columns with safe expression evaluator: profit = revenue - cost, name = upper(first) + last, year(date), coalesce()), and convert between csv/tsv/jsonl/json/markdown. Pure Python 3 standard library, no pandas, no remote calls. Handles 100k+ rows in under 1 second.
license: MIT
metadata: {"openclaw":{"requires":{"bins":["python3"]},"primaryEnv":null,"homepage":"https://clawhub.ai/gopendrasharma89-tech/clean-csv-toolkit"}}
---

# clean-csv-toolkit

v0.5.0

A small honest toolkit for the work agents end up doing constantly: read a CSV someone sent you, work out what's in it, clean it up, and forward only the safe rows downstream. Built on Python 3 standard library only. No `pandas`, no `numpy`, no pip installs, no remote calls.

## What this skill does

- `scripts/inspect.py` — profile a `.csv` / `.tsv` / `.jsonl` file: row count, auto-detected column types (`int`, `float`, `bool`, `date`, `datetime`, `string`, `empty`), null counts per column, distinct value counts (capped), three sample values per column, file size, and detected encoding.
- `scripts/validate.py` — check the file against a small JSON schema (required columns, per-column type, min/max, enum, regex, unique). Exits 0/1 so it slots into CI.
- `scripts/dedupe.py` — remove duplicate rows by full-row match or by key columns. Optional `--keep first|last`, `--case-insensitive`, `--trim`, and a JSONL report of every removed row.
- `scripts/diff.py` — compare two files by key column(s) and classify every row as added / removed / changed / unchanged, with a per-column before/after diff for changed rows.
- `scripts/convert.py` — convert between CSV, TSV, JSON Lines, JSON array, and GitHub-flavored Markdown table.
- `scripts/head.py` (NEW in v0.2.0) — print the first N rows in csv / tsv / jsonl / md / aligned format, with optional column subset.
- `scripts/tail.py` (NEW in v0.2.0) — print the last N rows using a streaming ring buffer (works on multi-gigabyte files without loading them).
- `scripts/sample.py` (NEW in v0.2.0) — pick a uniformly random sample of N rows via reservoir sampling. Single-pass, O(N) memory, optional `--seed` for reproducibility, optional `--preserve-order` to keep original row order.
- `scripts/merge.py` (NEW in v0.3.0) — join two files on one or more key columns. Supports `inner` / `left` / `right` / `outer` joins, separate key names per side via `--left-on` and `--right-on`, and duplicate-column disambiguation via `--suffix-left` / `--suffix-right`. Streams the LEFT side, indexes the RIGHT side (peak memory ≈ size of right file).
- `scripts/pivot.py` (NEW in v0.3.0) — group-by aggregations and wide pivot tables. Aggregations: `count`, `sum`, `avg

_meta.json

{
  "ownerId": "kn7fkwsa5knkdkkachj1p7rwr9843xts",
  "slug": "clean-csv-toolkit",
  "version": "0.5.0",
  "publishedAt": 1779347767997
}

skill-card.md

## Description:

Local CSV, TSV, and JSONL inspection and cleanup toolkit for profiling, validation, deduplication, diffing, previewing, filtering, sorting, concatenation, joins, pivots, transformations, and format conversion using Python 3 standard library tools.

This skill is ready for commercial/non-commercial use.

## Publisher:

[gopendrasharma89-tech](https://clawhub.ai/user/gopendrasharma89-tech)

### License/Terms of Use:

MIT

## Use Case:

Developers, data operators, and agents use this skill to inspect, clean, validate, reshape, compare, and convert local tabular datasets before sending safe rows, reports, or derived files downstream.

### Deployment Geography for Use:

Global

## Known Risks and Mitigations:

Risk: Data-writing commands can erase source files when an output path points to an input file.

Mitigation: Use separate approved output paths, keep backups, and avoid reusing any input path as an output path until the aliasing issue is fixed.

Risk: CSV previews or reports may expose PII or secrets from local datasets.

Mitigation: Use the skill only on approved local datasets and avoid printing or saving previews and reports that contain sensitive data.

## Reference(s):

- [Clean CSV Toolkit ClawHub Skill Page](https://clawhub.ai/gopendrasharma89-tech/skills/clean-csv-toolkit)
- [Clean CSV Toolkit Homepage](https://clawhub.ai/gopendrasharma89-tech/clean-csv-toolkit)

## Skill Output:

**Output Type(s):** [text, markdown, code, shell commands, configuration, guidance, files]

**Output Format:** [Markdown guidance with shell command examples; script outputs include CSV, TSV, JSON, JSONL, Markdown tables, and aligned text tables.]

**Output Parameters:** [1D]

**Other Properties Related to Output:** [Local file-processing outputs depend on the selected command and caller-provided input and output paths; no remote calls are used.]

## Skill Version(s):

0.5.0 (source: server release metadata and SKILL.md)

## Ethical Considerations:

Users should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.

LICENSE

MIT License

Copyright (c) 2026 gopendrasharma89-tech

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.
Github ReposUpdated 1d agoRank 70

AionUi

Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!

MCPOPENCLAW
Github ReposUpdated 6mo agoRank 70

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

OPENCLAW
Github ReposUpdated 6mo agoRank 70

cherry-studio

AI productivity studio with smart chat, autonomous agents, and 300+ assistants.

MCPOPENCLAW
Github ReposUpdated 7mo agoRank 70

CopilotKit

The Frontend for Agents & Generative UI. React + Angular

OPENCLAW

Machine-readable data

The same record, as JSON, for agents and crawlers.

{
  "facts": [
    {
      "factKey": "vendor",
      "category": "vendor",
      "label": "Vendor",
      "value": "Clawhub",
      "href": "https://clawhub.ai/gopendrasharma89-tech/skills/clean-csv-toolkit",
      "sourceUrl": "https://clawhub.ai/gopendrasharma89-tech/skills/clean-csv-toolkit",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-11T05:03:04.697Z",
      "isPublic": true
    },
    {
      "factKey": "protocols",
      "category": "compatibility",
      "label": "Protocol compatibility",
      "value": "OpenClaw",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-gopendrasharma89-tech-clean-csv-toolkit/contract",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-gopendrasharma89-tech-clean-csv-toolkit/contract",
      "sourceType": "contract",
      "confidence": "medium",
      "observedAt": "2026-10-11T05:03:04.697Z",
      "isPublic": true
    },
    {
      "factKey": "traction",
      "category": "adoption",
      "label": "Adoption signal",
      "value": "1.2K downloads",
      "href": "https://clawhub.ai/gopendrasharma89-tech/clean-csv-toolkit",
      "sourceUrl": "https://clawhub.ai/gopendrasharma89-tech/clean-csv-toolkit",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-11T05:03:04.697Z",
      "isPublic": true
    },
    {
      "factKey": "latest_release",
      "category": "release",
      "label": "Latest release",
      "value": "0.5.0",
      "href": "https://clawhub.ai/gopendrasharma89-tech/clean-csv-toolkit",
      "sourceUrl": "https://clawhub.ai/gopendrasharma89-tech/clean-csv-toolkit",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-05-21T07:16:07.997Z",
      "isPublic": true
    },
    {
      "factKey": "handshake_status",
      "category": "security",
      "label": "Handshake status",
      "value": "UNKNOWN",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-gopendrasharma89-tech-clean-csv-toolkit/trust",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-gopendrasharma89-tech-clean-csv-toolkit/trust",
      "sourceType": "trust",
      "confidence": "medium",
      "observedAt": null,
      "isPublic": true
    }
  ],
  "events": [
    {
      "eventType": "release",
      "title": "Release 0.5.0",
      "description": "v0.5.0: Add scripts/transform.py - derived columns + schema operations. Hand-rolled tokenizer + recursive-descent parser (no eval, no subprocess) supports arithmetic, string concat, parens, comparisons, function calls (upper/lower/strip/len/abs/round/int/float/str/replace/split/join/coalesce/year/month/day). Six ops: --add, --set, --drop, --rename, --cast (int/float/bool/string), --keep. Schema computed symbolically before streaming so empty cells in arithmetic don't crash the pipeline; per-row errors leave the derived value empty but continue processing. Bug fixed: schema-detection pass was evaluating expressions against empty rows. All 14 scripts now use the same safe-path policy and 0/1/2 exit codes.",
      "href": "https://clawhub.ai/gopendrasharma89-tech/clean-csv-toolkit",
      "sourceUrl": "https://clawhub.ai/gopendrasharma89-tech/clean-csv-toolkit",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-05-21T07:16:07.997Z",
      "isPublic": true
    }
  ]
}

Record generated Oct 11, 2026.

Sponsored

Ads related to Clean CSV Toolkit and adjacent AI workflows.