On this page you find all important commands for the CLI tool q. If the
command you are looking for is missing please ask our AI.
q
Q is a command line tool that allows users to interactively query and analyze structured data stored in various file formats such as CSV, TSV, JSON, and more. It provides a convenient way to perform data manipulation and transformation tasks using a familiar SQL-like syntax. Q supports features like filtering, grouping, sorting, aggregations, joins, and even supports user-defined functions for more advanced analysis. It is designed to be lightweight, fast, and efficient, making it suitable for working with large datasets. Q also offers integration with popular scripting languages such as Python and R, allowing users to easily incorporate it into their data analysis workflows.
List of commands for q:
-
q:tldr:3fbc3 q: Query file with header row.$ q -d${delimiter} -H "SELECT * from ${filename}"try on your machineexplain this command
-
q:tldr:6ea84 q: Join two files (aliased as `f1` and `f2` in the example) on column `c1`, a common column.$ q "SELECT * FROM ${filename} f1 JOIN ${path-to-other_file} f2 ON (f1.c1 = f2.c1)"try on your machineexplain this command
-
q:tldr:79dc7 q: Format output using an output delimiter with an output header line (note: command will output column names based on the input file header or the column aliases overridden in the query).$ q -D${delimiter} -O "SELECT ${column} as ${alias} from ${filename}"try on your machineexplain this command
-
q:tldr:a4b7c q: Query `.tsv` file.$ q -t "SELECT * from ${filename}"try on your machineexplain this command
-
q:tldr:c73f0 q: Query `.csv` file by specifying the delimiter as ','.$ q -d',' "SELECT * from ${filename}"try on your machineexplain this command