Cumulative totals by group in R
Posted 4th June 2021
No comments
Use Tidyverse’s dplyr package in R to add cumulative totals to a table based on group.
Tips for cleaning-up an R session
Posted 29th May 2021
No comments
Sometimes one just needs a “clean slate” in R, particularly when using R Studio. Here are my quick tips for cleaning up an R session in R Studio:
Managing RAW photos with Python
Posted 23rd April 2021
No comments
Use Python to recursively scan directories and remove unused and redundant CR2 files.
Convert RGB to CMYK in Python
Posted 26th March 2021
No comments
Efficient Python code for taking a RGB image and converting it to CMYK before splitting the relevant channels out.
SFTP via the Command Line
Posted 3rd March 2021
No comments
Simple instructions for uploading or downloading files and directories using Secure File Transfer Protocol (sFTP) in Linux.
Structural Similarity Index (SSIM) in Python
Posted 19th February 2021
No comments
Quantitatively check the quality of a compressed image using a simple Python code for calculating the Structural Similarity Index (SSIM) and Mean Square Errors (MSE) between two images.
Multi-line gradient hyperlinks
Posted 18th February 2021
No comments
Use cascading style sheets to create a gradient underline link that will span multiple lines.
Peak Signal-to-Noise Ratio (PSNR) in Python
Posted 12th February 2021
No comments
Quantitatively check the quality of a compressed image using a simple Python code for calculating the Peak Signal-to-Noise Ratio (PSNR) between two images.
Reading EXIF data in Python
Posted 2nd February 2021
No comments
In order to review the properties of various common-format image files, I wrote a command-prompt script in Python that will display EXIF data and other properties of JPG, PNG, TIF, CR2 and NEF files.
Query a PostgreSQL database via Python
Posted 11th December 2020
No comments
Use this simple template script created in Python to connect to your PostgreSQL database and run a query.