Simon Willison’s Weblog

Subscribe

Sunday, 31st July 2022

Cleaning data with sqlite-utils and Datasette (via) I wrote a new tutorial for the Datasette website, showing how to use sqlite-utils to import a CSV file, clean up the resulting schema, fix date formats and extract some of the columns into a separate table. It’s accompanied by a ten minute video originally recorded for the HYTRADBOI conference.

# 7:57 pm / tutorials, sqlite-utils, datasette, documentation

2022 » July

MTWTFSS
    123
45678910
11121314151617
18192021222324
25262728293031