AWS Glue DataBrew vs csvkit
AWS Glue DataBrew
aws.amazon.comcsvkit
github.comSide by side
| Figure | AWS Glue DataBrew | csvkit |
|---|---|---|
| Price from | $0.48/mo | Free |
| Free plan | — | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Web | Yes | — |
| Windows | — | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| API | Yes | — |
| Plans published | 4 | 1 |
| Spec score · Data Preparation Software | 8.9 (#2) | 8.0 (#10) |
| Intended users | AWS identifies data analysts and data scientists who prepare data for analytics and machine learning as DataBrew’s primary users. | The tutorial assumes basic command-line familiarity and says no prior experience with data processing or analysis is assumed. |
| Purpose | AWS Glue DataBrew is a visual tool for preparing data for analytics and machine learning without writing code. | csvkit is a suite of command-line tools for converting to and working with CSV files. |
Plans
AWS Glue DataBrew
- DataBrew interactive sessions$1 a month
- DataBrew jobs$0.48 a month
- DataBrew interactive sessions$1, paid once
- Pay-as-you-goPriced on request
In their own words
AWS Glue DataBrew
AWS Glue DataBrew has no write-up on Specifiction yet; its figures are above.
csvkit
csvkit is a free suite of command-line tools for converting, inspecting and transforming CSV data on Linux, macOS and Windows. Its tools handle common file and table tasks: in2csv converts formats such as Excel, JSON and fixed-width files; csvcut selects, removes or reorders columns; and csvlook and csvstat display data and summary statistics. Other commands filter matching rows, sort records, join related data or stack subsets. For database workflows, csvsql can query CSV data with SQL and import it into PostgreSQL, while sql2csv exports query results. csvjson converts CSV to JSON or GeoJSON. Commands can read standard input and write standard output, making them suitable for repeatable pipelines. By default, csvkit infers format from the first 1024 bytes and infers cell types, with options to turn off either behavior. Installation instructions include pip and Homebrew and recommend a virtual environment. The tutorial assumes basic command-line familiarity, but not prior data-processing experience. The project notes that larger files or faster processing may exceed its limits and suggests SQL or other tools in that case.