nmpowell

I downloaded this frustrating news article from the Guardian about Harrogate Spring Water cutting down trees to build a bottled water plant using the Firefox MarkDownload extension.

I fed the Markdown result into Claude 3.5 Sonnet with this prompt:

Given this news article, please make Mermaid diagram code which shows the relationship between the companies, people and organisations involved.

The result is shown here.

nmpowell

nmpowell

def replace_markdown_section(
    filepath: str, section: str, text: str, pad_before="\n\n", pad_after="\n\n"
) -> None:
    """Replace a section in a markdown file with new text.

    Args:
        filepath (str): Path to markdown file
        section (str): Section header to replace
        text (str): Text to replace section with
    """

nmpowell

# Zipped
sh_cmd(
    name = "build_hugo_zip_and_copy",
    # srcs = [":hugo_public_zip"],
    # Must escape newly defined env vars within the script to avoid Please expanding them at build time
    cmd = [
        "DEST=/home/username/hugo_site.com",
        "mkdir -p \\\$DEST",
        "cp -r $(out_location :hugo_public_zip) \\\$DEST",
    ],

nmpowell

REM    Windows batch script to run 1+ Python program/scripts, sequentially, within their virtual environment. This can be called from Windows Task Scheduler.

set original_dir=%CD%
set venv_root_dir="C:\Python-Venvs\env-name"

cd %venv_root_dir%

call %venv_root_dir%\Scripts\activate.bat

python your_python_script.py <arg1> <arg2> <arg3>

nmpowell

nmpowell

# !/usr/bin/python

"""
US 2017 Zip Code Tabulation Areas (ZCTA), latitude and longitude, and 2010 Census population, from US government data.

The final file includes GeoJSON Points for each ZCTA, and estimated population density per square kilometre.

Python code to create this Gist follows.

Notes:

nmpowell

REM   Windows batch script to set up Jupyter QtConsole and Notebook in a Python3 virtual environment.
REM   Place this script .bat file inside the root venv directory (same level as 'Scripts' and 'Lib' subfolders), and run.
REM   Also creates convenience launching scripts.

REM    Get current directory name and full path
for %%* in (.) do set VenvDirName=%%~nx*
set VenvDirFullPath=%~dp0

REM    Activate the venv
call %VenvDirFullPath%Scripts\activate.bat

nmpowell

Windows batch script to install locally-saved Python packages into a virtual environment

A hacky script to install Python packages from local wheels / tarballs. pip should do this by retrieving remote files, but if you're behind a firewall, you can use this instead.

• Find and download packages - ideally platform-specific wheel (.whl) files from: https://pypi.python.org/pypi
• set the path and name of your desired venv on line 6.
• package_names_in_order.txt lists files in a specific order, to enable installing requirements in the correct dependency order.
• /packages/ subdirectory (located relative to the .bat script dir) can contain anything pip accepts: .whl; .tar.gz; ...
• If you don't require a specific installation order, you can just use (note this is only for .whl files):

nmpowell

' Demonstrating mixed argument types to Application.OnTime (Integer and String).
' See these pages for more:
' - http://www.markrowlinson.co.uk/articles.php?id=10
' - https://www.mrexcel.com/forum/excel-questions/81724-calling-procedure-parameters.html
' - https://stackoverflow.com/questions/31439866/multiple-variable-arguments-to-application-ontime

Sub RunMe()
    Dim testName As String
    Dim counter As Integer