Public
- Public
- Network
- Groups
- Popular
- People

sqlite3 :memory: -cmd '.mode csv' -cmd '.import taxi.csv taxi' -cmd '.mode column' \ 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' Output is an ASCII-art table of results

Download link

sqlite3 :memory: -cmd '.mode csv' -cmd '.import taxi.csv taxi' -cmd '.mode column' \ 'SELECT passenger_count, COUNT(*), AVG(total_amount) FROM taxi GROUP BY passenger_count' Output is an ASCII-art table of results
https://files.mastodon.social/media_attachments/files/108/514/781/838/936/250/original/8ffdb7814f8d599c.png

Notices where this attachment appears

Jorge Sanz (xurxosanz@mastodon.social)'s status on Tuesday, 21-Jun-2022 16:15:32 CEST Jorge Sanz

Tested locally with a 1M records file, and this is a super neat and approachable way to quickly inspect CSV files
RT @simonw@twitter.com
TIL you can run SQL queries directly against CSV files as a one-liner using the default sqlite3 command line utility
https://til.simonwillison.net/sqlite/one-line-csv-operations
🐦🔗: https://twitter.com/simonw/status/1539038172599836672

In conversation Tuesday, 21-Jun-2022 16:15:32 CEST from mastodon.social permalink

tiflolinux.org - GNU Social is a social network, courtesy of tiflolinux.org. It runs on GNU social, version 2.0.1-beta0, available under the GNU Affero General Public License.

All tiflolinux.org - GNU Social content and data are available under the Creative Commons Attribution 3.0 license.