querycsv -- Query a CSV File

Execute SQL on CSV files querycsv.py querycsv.py is a Python module and program that allows you to execute SQL code against data contained in one or more comma-separated-value (CSV) files. The output of the SQL query will be displayed on the console by default, but may be saved in a new CSV file. Actions that can be performed with the querycsv program include: Execute a single SQL statement, specified on the command line, against the specified data. Execute multiple SQL statements, read from a script file, against the specified data. Read data either from one or more CSV files or from a Sqlite data file. Create a new CSV file containing selected, summarized, data. Create a Sqlite data file from one or more CSV files. The Sqlite file can then be used either by querycsv or by other programs, such as the Python Sqliteplus shell . querycsv.py -i <fname> [other options] [S...

Linked on 2014-03-13 20:50:04 | Similar Links