legendtkl/agentic-skill-router/skill-008

Claude Code and agent skill by legendtkl/agentic-skill-router

Trust tier 3
  • community
Source check pending

Checking that the SKILL.md file is still in the repository.

A robust tool for cleaning, standardizing, and preparing CSV data files for analysis. Ideal for ensuring accuracy in datasets before use in reports or financial models.

Install

npx vskill@latest install legendtkl/agentic-skill-router/skill-008

SKILL.md

The same SKILL.md was published earlier as legendtkl/agentic-skill-router/skill-008.

Requirements for Outputs

General CSV File Handling

Cleanliness Standards
  • All CSV files must be delivered free of duplicate entries and with consistent formatting.
  • Ensure all string values are trimmed of whitespace and standardize case (e.g., all lowercase).
Standardization Rules
  • Dates should be formatted to YYYY-MM-DD.
  • Numerical values should not contain commas or currency symbols.
  • Replace any missing values with "N/A" or appropriate placeholders.

Data Cleaning Techniques

Deduplication
  • Implement algorithms to detect and remove duplicate rows based on key columns.
  • Example code snippet:
python
import pandas as pd
def remove_duplicates(file_path):
df = pd.read_csv(file_path)
df_cleaned = df.drop_duplicates()
return df_cleaned
Formatting Strings
  • Normalize string values by removing leading or trailing whitespace and converting to lowercase before analysis.
  • Example code snippet:
python
def format_strings(df):
df['column_name'] = df['column_name'].str.strip().str.lower()
return df
Handling Missing Data
  • Replace missing values with specified placeholders or use interpolation if appropriate.
  • Example code snippet:
python
def handle_missing_data(df):
df.fillna('N/A', inplace=True)
return df

Documentation Requirements

Data Source Citation
  • Ensure all cleaned data is accompanied by a citation of the original data source: "Source: [System/Document], [Date], [Specific Reference]."
Change Log
  • Maintain a change log documenting any alterations made during the cleaning process, including date and reason for changes.

Security

  • Security scanPassed, 95 of 100Pattern checks on the skill's files.
  • Model reviewPassed

Quality evaluation

  • Task evaluationNot runNo evaluation yet. Run one in Skill Studio.

Source

Popularity

7-day trend score
5

Not refreshed yet.

Works with

Any agent vskill installs to: 56 targets in all. These 39 have a page on this site.

  • Claude Code
  • Cursor
  • GitHub Copilot
  • Windsurf
  • Codex
  • Gemini CLI
  • Cline
  • Amp
  • Roo Code
  • Goose
  • Continue
  • Kilo Code
  • Junie
  • Trae
  • OpenHands
  • Qwen Code
  • AI Agent
  • Tabnine Chat
  • Sourcegraph Cody
  • Amazon Q
  • Firebase Genkit
  • Sweep
  • Devin
  • Phind
  • Mentat
  • Claude Desktop
  • Aider
  • GPT Pilot
  • Plandex
  • bolt.new
  • v0
  • Replit Agent
  • Anse
  • TypingMind
  • BetterChatGPT
  • LibreChat
  • Warp AI
  • Pieces
  • Fig AI
Embed badge
vskill VERIFIED badge
[![vskill VERIFIED](https://verified-skill.com/api/v1/skills/legendtkl/agentic-skill-router/skill-008/badge)](https://verified-skill.com/skills/legendtkl/agentic-skill-router/skill-008)

Something wrong with this skill or its page? Tell us.