Skip Navigation

Scout Archives

Home Projects Publications Archives About Sign Up or Log In

q - Text as Data

q is a command-line utility that allows users to execute SQL queries in tabular format text files (CSV, TSV, and other such formats). Users wanting to accomplish this task without a tool like q would typically need to load the CSV data into database software of some kind. The examples section on the q website provides an analysis of website click-count data and an analysis of file sizes to determine the owner using the most disk space. Users less familiar with SQL syntax may find the more detailed tutorial section useful. q requires Python 2.5 or higher and can run on any platform where Python runs. Python 3 is not yet supported. Installers are available for Windows and Linux. q is free software, licensed under the GNU General Public License v3, with source code available on GitHub.
Archived Scout Publication URL
Scout Publication
GEM Subject
Date of Scout Publication
June 8th, 2018
Date Of Record Creation
June 7th, 2018 at 9:13am
Date Of Record Release
June 7th, 2018 at 4:10pm
Resource URL Clicks
Add Comment


Subject: Comment On: q - Text as Data
Posted By: PriyaS
Date Posted: 11/21/18 5:58am
I want to know how to use q-textasdata to insert or delete any data