stuaxo

DATA_FILE = "your-file.parquet"

import pandas as pd

# Read the Parquet file
df = pd.read_parquet(DATA_FILE)

def df_schema(df):
    # Print the column names and their types
    for column in df.columns:

stuaxo

#!/bin/bash

# This script creates a Jupyter kernel for a virtual environment.

# Get the name of the virtual environment from the command line or default to the current environment.
VENV_NAME="$1"

# Check if a virtual environment name was provided
if [ -z "$VENV_NAME" ]; then
    if [ -z "$VIRTUAL_ENV" ]; then

stuaxo

Ubuntu in QEmu via UTM on a Mac

UTM is available from the app store for £9, or here: mac.getutm.app

Look up the instructions for installing Ubuntu, install it using Qemu. I used this 22.04 image (As of 3-Aug-2023 I was NOT successful in installing, or upgrading to 23.04) https://cdimage.ubuntu.com/jammy/daily-live/current/jammy-desktop-arm64.iso

stuaxo

#!/bin/bash

# Function to handle the download
download_file() {
  local delete_flag="${1:-false}"
  local url="$2"
  local filename="$3"

  # Extract filename from URL if not provided
  if [ -z "$filename" ]; then

stuaxo

#!/bin/bash
#
# Download all the files in a GitHub Gist
#
# Example usage:
# $ download-gist.sh https://gist.github.com/stuaxo/2e110aaa42050490ad3fd73cfbedf76a
#
# By default, files are not overwritten. The -f option overrides this behavior:
# $ download-gist.sh -f https://gist.github.com/stuaxo/2e110aaa42050490ad3fd73cfbedf76a
#

stuaxo

#!/bin/bash
#
# Download open watcom 1.9 from sourceforge.
#
# Requires curl or wget
FILENAME="open-watcom-c-linux-1.9"
URL="https://master.dl.sourceforge.net/project/openwatcom/open-watcom-1.9/$FILENAME"

# Check if curl is available
if command -v curl >/dev/null 2>&1; then

stuaxo

#!/usr/bin/env python3

# Usage: python dirtollm.py [files or glob patterns...] [options]
# Example: python dirtollm.py "*.py" "*.txt" /path/to/specific/file.py --exclude "*.pyc" --copy --verbose -x --binaries

import argparse
import pathlib
import fnmatch
import sys
import os

stuaxo

#!/bin/bash
#
# hyperlink.sh
#
# Generate clickable hyperlinks to files in the terminal using OSC-8 standard ANSI.
#
# Usage:
# hyperlink.sh [-t text] [-r relative_folder] [-s] [--help] file
#
# Many terminals that support OSC-8 hyperlinks including:

stuaxo

def update_paths():
    import os
    import sys
    
    import dotenv
    
    dotenv.load_dotenv(override=True)
    
    new_paths = {*os.environ["PYTHONPATH"].split(":")} - set(sys.path)
    sys.path.extend(new_paths)

stuaxo

# Ended up not using this, as there was only one place in the codebase.


def concat_non_null_fields(fields, seperator):
    """
    Build a case statement expression to concatenate the supplied fields where isnull is False.

    :param fields: List of fields to concatenate.
    :param seperator: Seperator to use between fields.
    :return: Case statement expression.