dvcrn CSVKit Next
Swiss army knife for CSV files. Filter, transform, merge, validate, analyze.
Installation
npm install -g @lxgicstudios/csvkit-next
Commands
Filter Rows
csvkit filter data.csv age gt 30
csvkit filter users.csv email contains @gmail
csvkit filter sales.csv status eq completed
Operators: eq, ne, gt, lt, gte, lte, contains, startswith, endswith, regex, empty, notempty
Transform Columns
csvkit transform data.csv "full_name=first+' '+last"
csvkit transform prices.csv "total=price*quantity"
csvkit transform users.csv "domain=email.split('@')[1]"
Merge Files
csvkit merge users.csv orders.csv -o combined.csv
Validate
csvkit validate data.csv
csvkit validate data.csv schema.json
Schema example:
{
"required": ["id", "email"],
"types": { "age": "number", "email": "email" }
}
Statistics
csvkit stats sales.csv
Shows: rows, columns, min/max/avg, unique values.
Other Commands
csvkit head data.csv 20 # First 20 rows
csvkit tail data.csv 20 # Last 20 rows
csvkit columns data.csv # List columns
csvkit sort data.csv price desc # Sort
csvkit unique data.csv category # Unique values
csvkit sample data.csv 50 # Random rows
csvkit convert data.csv -t json # To JSON
Common Use Cases
Filter high-value orders:
csvkit filter orders.csv total gt 1000 -o high_value.csv
Add calculated column:
csvkit transform sales.csv "profit=revenue-cost" -o with_profit.csv
Quick data overview:
csvkit stats large_dataset.csv
Features
- Zero dependencies
- Fast streaming for large files
- Expression-based transforms
- Schema validation
- Multiple output formats
Built by LXGIC Studios