3 ms·
I guess they really get a lot of pressure there. Putting Python in Excel can potentially lift more analysts to proper developers or at least make the code base
by markus_zhang 5y ago
I guess they really get a lot of pressure there.
Putting Python in Excel can potentially lift more analysts to proper developers or at least make the code base more robust. A lot of analysts' first language is VBA and then they move on to more serious development and land on a developer job.
I'm one of those examples. My first language was VBA and I dig a bit deeper into it (e.g. reading about moving pointers and general coding best practice, downloading rubberduck extension for VBA, etc.) and taught myself C++ and Python. Eventually I landed a BI developer job.
- pjmlp 5y agoI have seen many move to VB by following that path on life science research labs that tend to be Windows based, as per reading devices and laboratory robots. So they went Excel => .NET, and were served by .NET and COM APIs in Excel. In modern Excel you also have Lambda, JavaScript and PowerQuery as an inbox option.
- markus_zhang 5y agoI thought about moving to C# but we didn't really need the power so I didn't bother. PowerQuery is also very good for data cleaning. Learned a few tricks here and there.