python-functions VS Power-Fx

You can see look at my custom python settings here. You can also look into the recommended extensions there.

You can see my customizations for Python in PowerShell in Dark+ theme here, but it's just my personal preference, probably not everyone would like that ;).

szymonos/python-functions (github.com)

But if you're writing PS script in Windows it will most likely work on Linux if there is PS installed. This is my PS script to provision and manage Python virtual environments: python-functions/pysetup.ps1 at main · szymonos/python-functions (github.com) or my psprofile: powershell-functions/profile.ps1 at main · szymonos/powershell-functions (github.com)

Here are my tweaks to Dark+ theme: settings.json

If you're on Linux/Windows with WSL2 you can try it by yourself ( szymonos/python-functions (github.com) ) - there is a complete environment with Azure Functions in Python configured. You can debug it out of the box, there are configured linting with pylint, flake8, mypy, formatting with black, unit test with pytest, installed VSCode extensions for python development and so on.

Take a look at https://github.com/microsoft/Power-Fx ! It’s a language heavily based on excel’s formula language, and the open source interpreter can be used for simple expressions at the moment.

Microsoft Power Fx – A low-code general purpose programming language\ (114 comments)

Excel, I mean, PowerFx will have the last laugh: https://github.com/microsoft/Power-Fx