Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, ...

Pandas makes it easy to quickly load, manipulate, align, merge, and even visualize data tables directly in Python.

The January 2021 update to the Python Extension for Visual Studio Code is out with a short list of new features headed by a data viewer used while debugging.