csv

$npx mdskill add vercel-labs/bash-tool/csv

Process CSV files using bash tools like awk and cut to analyze, filter, select, and sort data for data manipulation tasks.

  • Helps with summarizing statistics, filtering rows, selecting columns, and sorting data in CSV files.
  • Integrates with standard bash tools including awk, cut, sort, and grep for data processing.
  • Executes based on user-provided commands specifying file paths, column numbers, values, and options.
  • Delivers results through command-line output, displaying processed data or summaries directly.

SKILL.md

.github/skills/csvView on GitHub ↗
---
name: csv
description: Analyze and transform CSV data using bash tools
---

# CSV Processing Skill

Process CSV files using standard bash tools (awk, cut, sort, grep).

## Available Scripts

### analyze.sh
Get statistics and summary of a CSV file.
```bash
bash /skills/csv/scripts/analyze.sh data.csv
```

### filter.sh
Filter rows where a column matches a value.
```bash
bash /skills/csv/scripts/filter.sh data.csv <column_number> <value>
```

### select.sh
Select specific columns from CSV.
```bash
bash /skills/csv/scripts/select.sh data.csv <col1,col2,col3>
```

### sort.sh
Sort CSV by a column.
```bash
bash /skills/csv/scripts/sort.sh data.csv <column_number> [--numeric] [--reverse]
```

## Examples

```bash
# Show CSV summary
bash /skills/csv/scripts/analyze.sh sales.csv

# Filter where column 3 equals "active"
bash /skills/csv/scripts/filter.sh users.csv 3 active

# Select columns 1, 2, and 4
bash /skills/csv/scripts/select.sh data.csv 1,2,4

# Sort by column 2 numerically in reverse
bash /skills/csv/scripts/sort.sh data.csv 2 --numeric --reverse
```

More from vercel-labs/bash-tool

SkillDescription
textAnalyze and transform text files using bash tools