메뉴
Parse, query, filter, sort, transform, and summarize CSV and JSON data files. Use this skill when the user asks to view a CSV, filter data, get statistics from a data file, convert CSV to JSON or vice versa, sort data, or analyze tabular data.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Append or add new text content to an existing file. Use this skill when the user asks to update a file, add content, append text, add a verse, add a section, or extend a document with additional material. Supports any text-based file format including .txt, .md, .py, .json, and more.
Create and write text content to a file in a specified directory. Use this skill when the user asks to create a file, write content to a file, save text, generate a document, or write a poem, story, script, or any text-based content to disk. Supports any text format and custom file paths.
Update or modify text files (poems, documents, notes, etc.) in any directory. Use this skill when the user asks to edit, update, modify, revise, or rewrite a text file, poem, document, or similar content. Supports adding new content, expanding existing text, or replacing file contents while preserving the original location.
Analyze a codebase or project to identify actionable improvements, architectural enhancements, and optimization opportunities. Use this skill when the user asks to review code quality, suggest improvements, identify bottlenecks, audit a system, or get recommendations for enhancing a project. Generates a prioritized list of improvements with problem statements, solutions, and impact analysis.
Analyze and provide detailed feedback on documents including PDFs, text files, and other formats. Use this skill when the user asks for your thoughts on a document, wants a review, analysis, summary, critique, or evaluation of any written material. Supports document upload, file path references, or direct text content.
Answer factual questions about events, people, places, and general knowledge topics. Use this skill when the user asks 'who won', 'what happened', 'when did', 'where is', or other questions seeking factual information about sports, history, geography, current events, or other verifiable facts.
| name | csv-tools |
| description | Parse, query, filter, sort, transform, and summarize CSV and JSON data files. Use this skill when the user asks to view a CSV, filter data, get statistics from a data file, convert CSV to JSON or vice versa, sort data, or analyze tabular data. |
| tags | ["csv","json","data","filter","sort","statistics","transform","utility"] |
| version | 0.1.0 |
Use this skill when the user asks to:
| Parameter | Required | Description | Example |
|---|---|---|---|
action | Yes | view, filter, sort, stats, convert | view |
file_path | Yes | Path to the CSV or JSON file | data.csv |
column | For filter/sort | Column name to operate on | age |
value | For filter | Value to match (supports operators: >, <, >=, <=, !=, =) | >30 |
order | For sort | asc (default) or desc | desc |
output | For convert | Output file path | data.json |
limit | For view | Max rows to display (default: 50) | 20 |
Determine the action from the user's request
Run the bundled script:
# View first 50 rows
python3 skills/csv-tools/scripts/query.py view data.csv
# Filter rows
python3 skills/csv-tools/scripts/query.py filter data.csv --column age --value ">30"
# Sort by column
python3 skills/csv-tools/scripts/query.py sort data.csv --column name --order asc
# Summary statistics
python3 skills/csv-tools/scripts/query.py stats data.csv
# Convert CSV to JSON
python3 skills/csv-tools/scripts/query.py convert data.csv --output data.json
Report the result to the user
| Script | Type | Description |
|---|---|---|
scripts/query.py | Python | Query, filter, sort, and transform CSV/JSON data |
# View data (pretty-printed table)
python3 scripts/query.py view data.csv
python3 scripts/query.py view data.csv --limit 10
# Filter rows
python3 scripts/query.py filter data.csv --column status --value "active"
python3 scripts/query.py filter data.csv --column price --value ">100"
python3 scripts/query.py filter data.csv --column name --value "!=John"
# Sort
python3 scripts/query.py sort data.csv --column date --order desc
# Statistics
python3 scripts/query.py stats data.csv
python3 scripts/query.py stats data.csv --column revenue
# Convert formats
python3 scripts/query.py convert data.csv --output data.json
python3 scripts/query.py convert data.json --output data.csv
show me the contents of sales.csv
filter users.csv where age is greater than 30
sort the data by revenue descending
what are the statistics for this CSV file
convert this CSV to JSON
how many rows are in data.csv