manual-dataset-cleaning

Clean and synchronize interview datasets across Markdown, CSV, and JSON with provenance.

Updated Apr 27, 2026
One-click install
npx skills add https://github.com/Pans0020/opencode-skills --skill manual-dataset-cleaning
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: manual-dataset-cleaning
Source: https://github.com/Pans0020/opencode-skills/tree/main/manual-dataset-cleaning
Command: npx skills add https://github.com/Pans0020/opencode-skills --skill manual-dataset-cleaning

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you collect and clean interview/dataset records that are duplicated across multiple final artifacts while preserving source provenance and preventing CSV/JSON/Markdown drift.

Core Features & Use Cases

  • Provenance-first collection: capture platform, source URL, post ID, title, author, and raw snapshots before any normalization.
  • Conservative extraction & normalization: keep raw question text, create a cleaned/standardized version separately, and avoid hallucinating missing fields.
  • Synchronized multi-file cleaning: choose a source of truth (CSV/JSON) and apply narrow, anchored edits so mirrored artifacts stay consistent.
  • Deduplication with auditability: merge duplicates only when meaning matches, while preserving all source links and metadata.
  • Verification-driven safety: use parser-based checks, row counts, field allowlists, and mismatch reporting instead of visual inspection.

Quick Start

Ask for the Skill's workflow to manually collect Nowcoder interview records and then synchronize cleanup across your Markdown table, CSV, and JSON while preserving source URLs and raw text snapshots.

Frequently Asked Questions about manual-dataset-cleaning

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I deduplicate interview datasets while keeping source provenance across multiple files?

To deduplicate interview datasets while keeping provenance, merge records only when meaning matches and preserve all source URLs and raw text snapshots. This ensures auditability while preventing data loss during synchronized multi-file cleaning.

What is the best way to synchronize dataset cleaning across CSV, JSON, and Markdown formats?

The best way to synchronize dataset cleaning across CSV, JSON, and Markdown is to choose a source of truth and apply narrow, anchored edits. Parser-based verification then checks that row counts and selected fields remain consistent across all mirrored artifacts.

How do I normalize Nowcoder interview records without hallucinating missing data fields?

To normalize Nowcoder interview records without hallucinating missing data, keep the raw question text and create a cleaned version separately. This conservative extraction approach prevents fabricating missing fields during the normalization process.

How does parser-based verification prevent CSV JSON Markdown drift during dataset cleaning?

Parser-based verification prevents CSV JSON Markdown drift by automatically checking row counts, enforcing field allowlists, and reporting mismatches. This replaces visual inspection to guarantee mirrored artifacts remain strictly consistent after edits.

Can I use this approach to collect interview datasets from platforms other than Nowcoder?

Yes, you can collect interview datasets from platforms other than Nowcoder. The provenance-first schema requires capturing platform, source URL, post ID, title, author, and raw snapshots before any normalization, making it adaptable to various sources.