Python in Corporate Windows

Once in a while I have to quickly set up a simple Python script in a corporate environment, which more often then not is predominated by Windows. Since I'm not that familiar with that OS here are notes to help me navigate the most common quirks (hegemony of ISO-8859-2 encoding and the tyranny of XLS files) to try and speed up the process.

Prepare dev workspace

C:\> mkdir %USERPROFILE%\PROJECTS
C:\> subst r: %USERPROFILE%\PROJECTS       % requires redo after reboot
C:\> R:
R:\> git clone https://github.com/codcod/picw.git
R:\> cd picw
R:\picw> scripts/make_venv_here.bat

How-to's

• Process XLS data using a staging database

Windows tips

• Change Caps Lock into Ctrl
• Quickly open System Properties for example to change %PATH% in the "Environment Variables" window
• Python startup settings

Useful links

Download pages:

1. Python
2. SQLite
3. SQLiteBrowser
4. Neovim
5. VSCode
6. Notepad++
7. Mu
8. GNUWin Packages all at once