Environment setup

Inspiration: data science at command line

Install packages on Google Colab

sudo pip install csvkit #https://csvkit.readthedocs.io/en/latest/tutorial/1_getting_started.html
sudo pip install sqlitebiter #https://sqlitebiter.readthedocs.io/en/latest/pages/usage/index.html
sudo pip install sqlite-utils #https://sqlite-utils.datasette.io/en/stable/cli.html
sudo pip install sqlfluff

# install jq for pretty printing of json at the terminal
sudo apt-get install jq


# Install bat for syntax highlighting of programming files at the terminal
wget https://github.com/sharkdp/bat/releases/download/v0.18.0/bat_0.18.0_amd64.deb
sudo dpkg -i bat_0.18.0_amd64.deb
rm bat_0.18.0_amd64.deb

Install from a requirements file

requirements.txt

csvkit
sqlitebiter
sqlite-utils
sqlfluff
sql-formatter