sirq

sirq is a command-line tool designed for querying and manipulating data within CSV files. It allows users to filter rows, select specific columns, and perform basic aggregations directly from the terminal, without needing to load the entire dataset into memory or use more complex programming languages.

The primary function of sirq is to provide a streamlined way to interact with tabular data. Users can specify conditions to filter data, effectively subsetting the CSV based on criteria like string matching, numerical comparisons, or the presence of specific values. It also supports selecting particular columns, enabling users to extract only the information they need. Beyond simple selection and filtering, sirq can perform basic calculations such as counting rows that meet certain conditions, finding minimum or maximum values within a column, or calculating averages.

sirq is particularly useful for data exploration and quick analysis tasks where interactive scripting or full-fledged database solutions might be overkill. Its command-line interface makes it easily integrable into shell scripts and automated workflows. The tool emphasizes simplicity and speed for common data manipulation operations on CSV files.