Iterate both i and j in Python
Posted 2nd September 2020
Two methods for implimenting nested iterations of i and j in Python.
SVG not displaying in Chrome browser
Posted 31st August 2020
A simple solution for a situation when a SVG fails to display in Google Chrome but works in other browsers.
PostgreSQL: Add columns to a query table with variables
Posted 3rd July 2020
Generate a new column in your PostgreSQL database query from data in other columns or other tables.
Rescaling Data in R
Posted 23rd September 2019
A simple methodology for rescaling multiple series of data via min-max normalisation in R, then plotting.
Check file names with RegEx in ImageJ
Posted 26th July 2019
Use regular expressions to apply different steps in an ImageJ macro script by querying the file name.
Force “git pull” to overwrite local files
Posted 19th June 2019
I needed to over-write a local version of a repository as it was not fully updating. This worked.
SQL to CSV via Python, with Headers
Posted 7th June 2019
Nifty Python code that converts a SQL database file into a CSV file and includes column headers.
Larger matplotlib images in Jupyter Notebook
Posted 21st February 2019
Simple code to enable matplotlib to generate larger inline images in Jupyter Notebook.
Push local files to GitHub
Posted 6th February 2019
Instructions for committing a folder of local files to a new GitHub repository via the Command Prompt.
Relative file paths in BAT files
Posted 30th January 2019
Instructions for using a relative file path in batch files.