csv-tools
Skill: csv-tools
When to Use
Use this skill when the user asks to:
- View or pretty-print a CSV/JSON file
- Filter rows from a data file
- Sort data by a column
- Get summary statistics (count, mean, min, max)
- Convert CSV to JSON or JSON to CSV
- Query or analyze tabular data
- Count rows or summarize a dataset
Input Parameters
| 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 |
Procedure
-
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
Bundled Scripts
| Script | Type | Description |
|---|---|---|
scripts/query.py |
Python | Query, filter, sort, and transform CSV/JSON data |
Script Usage
# 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
Example
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
More from dalehurley/phpbot
desktop-control
Control the mouse, keyboard, and read screen content via accessibility. Use this skill when the user asks to click somewhere on screen, type text into an app, move the mouse, press keyboard shortcuts, read what's on screen, get the accessibility tree of the current window, automate desktop interactions, or control the computer.
39summarize-unread-emails
Retrieve and summarize all unread emails from your inbox, organized by category, sender, and date. Use this skill when the user asks to summarize unread emails, get an overview of unread messages, organize inbox emails, or review pending email communications. Provides a structured summary with categorization and timeline analysis.
20open-application
Open or launch applications on your computer by name. Use this skill when the user asks to open, launch, or start an application like Mail, Finder, Safari, Chrome, or any other installed macOS application. Works with both built-in and third-party applications.
10homebrew
Install, manage, and search for software packages on macOS using Homebrew. Use this skill when the user asks to install software, apps, CLI tools, developer utilities, programming languages, databases, or any package on a Mac. Supports formulae (CLI tools) and casks (GUI apps). Can also search, update, upgrade, uninstall, and diagnose Homebrew issues.
10get-weather-forecast
Retrieve current weather conditions and multi-day forecasts for any location using the wttr.in API. Use this skill when the user asks for weather information, weather forecast, current conditions, temperature, or weather updates for a specific city or location. Provides detailed weather data including temperature, wind, precipitation, and visibility.
8self-correct-reasoning
Analyze and correct previous responses when questioned or when contradictions are detected. Use this skill when the user challenges your reasoning, points out inconsistencies, or asks 'what makes you think that?' to help you review your logic, identify errors in your previous statements, and provide accurate corrections. Useful for maintaining consistency, admitting mistakes, and rebuilding trust through transparent self-evaluation.
8