Run: bundler exec jekyll serve

df.loc[ df ["col_name"].dropna().astype(str).str.contains(r'[a-z]') ]["col_name "].unique() dropna() is needed where the column contains NaNs, to fend off an error. astype() is needed to for...

The current pyodbc version - 5.1.0 - can’t be installed on Python using the standard cmd commands - it fails with an error relating to building wheels. A workaround is to install the latest versio...

As of version 1.49.1 at least, Azure Data Studio settings need to be synced manually - ADS doesn’t include a built-in feature to sync settings across multiple devices. Steps that need to be taken:...

Use: git config --global user.name "Philip Nye" git config --global user.email "philipnye@users.noreply.github.com" Note that the email address should be the privacy-defending email address asso...

The Storage Blob Data Owner role is needed to upload data - even when the Owner role is held. It can take up to five minutes for role assignments to propagate.

This can be necessary as there seems to be an issue loading files more than 2GB in size via the Azure Storage UI in Chrome - attempting it results in a “The requested file could not be read, typica...

& can be used to run two commands in one && can be used to run two commands in one, with the second running conditional on the first executing successfully Ref.

Use Python for manipulation relating to cell values: string manipulation, deduplication and fuzzy matching. Use SQL for other manipulation. It’s much easier to do things step-by-step in SQL and s...

React component names must all start with a capital letter. And, in fact, a warning is raised if they aren’t either in Pascal_Case or SCREAMING_SNAKE_CASE.