Using environment variables in GitHub Actions
Things held as GitHub secrets must be defined as environment variables in the GitHub Actions workflow in order to be able to use them in a script. E.g.: - name: Run script env: ODBC_DR...
Things held as GitHub secrets must be defined as environment variables in the GitHub Actions workflow in order to be able to use them in a script. E.g.: - name: Run script env: ODBC_DR...
Use: - name: Install Microsoft ODBC run: sudo ACCEPT_EULA=Y apt-get install msodbcsql18 -y Ref (NB: additional steps, on port mapping, don’t seem to be necessary. This is an abbreviated versio...
Putting an exclamation mark before a filename excludes that file from being ignored. !file1.py But where an entire directory is being ignored, this exclusion won’t work. I.e. for: my-app/ └──...
Create virtual environment named env inside current directory: python -m venv env_pn Create virtual environment named env inside current directory using a specific version of Python: python -3.13 ...
distutils requires Microsoft C++ Build Tools. When installing this, only the first option needs to be selected (desktop development, C++ developement tools (or similar naming)).
Converting warnings of a particular category from a particular module can be done using: import warnings warnings.filterwarnings("error", category=UserWarning, module="seaborn") (Ref.)
When doing memory-intensive operations in VSCode - e.g. working with large pandas dataframes - the kernel can crash with the following error: The kernel crashed while executing code in the current...
Attempting to upload large dataframes can result in the following error: PendingRollbackError: Can't reconnect until invalid transaction is rolled back. Please rollback() fully before proceeding ...
Images can be inserted using:  Ref. Spaces need to be URL-encoded in GitHub Markdown. Spaces are encoded as %20%.
Both when developing locally and when an app is deployed on-premises (e.g. on Streamlit), authenticating an app using an application service principal is an option. In fact, this is the only option...