home / csvconf

talks

Data source: https://csvconf.com/

1 row where datetime = "2019-05-08T11:30:00" and speaker = "Nicholas Canzoneri" sorted by title descending

View and edit SQL

datetime

Link rowid title ▲ speaker time day room url datetime abstract image
11 Bash <3's CSVs: Data Analysis on the cmdline Nicholas Canzoneri 11:30 AM May 8 2019 Daisy Bingham Room https://csvconf.com/speakers/#nicholas-canzoneri 2019-05-08T11:30:00 Your bash shell has a _lot_ utilities that can be used to help you analyze your data, often easier and faster than trying to import your data to an external tool. But these utilities can be hard to find and even harder to figure out the right options. I'll walkthrough a data set and show examples of the best utility to use in different situations. I'll go over common commands like `grep` and `cut`, more exotic commands like `comm` and `tr`, and dig up very useful options to a command you might have overlooked, like `sort -k`. https://csvconf.com/img/speakers-2019/ncanzoneri.jpg

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [talks] (
   [title] TEXT,
   [speaker] TEXT,
   [time] TEXT,
   [day] TEXT,
   [room] TEXT,
   [url] TEXT,
   [datetime] TEXT,
   [abstract] TEXT,
   [image] TEXT
)
Powered by Datasette · Query took 4.439ms · Data source: https://csvconf.com/