Need help with csv-sql?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

alex
141 Stars 12 Forks Other 597 Commits 0 Opened issues

Description

Query your CSV files with SQL

Services available

!
?

Need anything else?

Contributors list

# 2,284
Python
Django
sentry
nacl
145 commits
# 748
GitHub
rust-la...
wechat-...
herokua...
67 commits
# 2,933
query-l...
python-...
mvvm-fr...
wechat-...
23 commits

CSV SQL

Take a CSV file, query it with SQL. Magic!

.. code-block:: console

$ cargo run file.csv
Loaded 3162 rows into t(domain, base_domain, agency, sslv2)
> SELECT COUNT(*) FROM t
+----------+
| 3162     |
+----------+

All your rows go into a table named

t
. It's great!

You can also specify multiple files:

.. code-block:: console

$ cargo run file1.csv file2.csv
Loaded 12 rows into t1(some, schema)
Loaded 74 rows into t2(some, other, schema)
>

If you'd like to export the results of a query to a CSV file:

.. code-block:: console

$ cargo run file.csv
Loaded 3162 rows into t(domain, base_domain, agency, sslv2)
> .export(results.csv) SELECT COUNT(*) from t;

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.