This is where I keep track of things I learn. You can read my post about it here.
Adapted from simonw/til, which I learned about on Twitter.
28 TILs so far.
Recently Added
- Setting up a Linux Dev Environment in Windows with WSL (Windows Subsystem For Linux) (general_development) - 2022-12-18
- Access the Clipboard in Python with Pyperclip (python) - 2021-11-08
- Create a SQL ‘IN’ Statement from a Python List (SQL) - 2021-11-07
- Allow workflows to interact with other repos using Personal Access Tokens (github_actions) - 2021-02-23
-
Github actions basics and syntax (github_actions) - 2021-02-07
geopandas
- Convert a closed linestring to a polygon - 2020-10-15
- Group Well Survey Points into Lines - 2020-10-20
git
- Set git’s default text editor to vs code - 2020-10-18
- Stop tracking a file in version control - 2020-12-01
SQL
- Get the value counts of a column in SQL - 2020-10-18
- Query for Table and Column Names in a Database - 2020-11-02
- Create a SQL ‘IN’ Statement from a Python List - 2021-11-07
curl
- Write the output of curl to a file - 2020-10-18
python
- Create and activate a virtual environment in Python - 2020-10-18
- Using command line arguments when running a python script - 2020-11-17
- Use black code formatting in Jupyter - 2020-12-01
- Avoid nested for loops with itertools.product() - 2020-12-01
-
Replace multiple characters in a string using
string.translate()- 2020-12-06 - Using try-except to allow for optional imports in a module - 2021-01-09
- Using type hints in python - 2021-01-15
- Accessing the parts of a file path with Pathlib - 2021-01-15
- Access the Clipboard in Python with Pyperclip - 2021-11-08
vs_code
- Set vertical rulers for git commit messages in vs code - 2020-10-18
- Set a powerline enabled font in the terminal - 2020-10-26
- Enabling the type checking feature in vscode - 2021-01-15
docker
- Attach shell to running container - 2020-10-19
- Creating a bind mount into a docker container - 2020-11-17
pip
GIS
- Raster affine transforms in Python - 2020-10-26
pandas
- Binning data with cut and qcut - 2021-01-15
github_actions
- Github actions basics and syntax - 2021-02-07
- Allow workflows to interact with other repos using Personal Access Tokens - 2021-02-23