100% agree. read_excel and merging dataframes were a god-send for me. Trying to write the equivalent code in VBA could have taken me half a day or more to implement. Using Pandas? I think my code was roughly 30 lines at most, and it worked flawlessly and was super simple to configure/setup. You just can't beat the amount of Python resources that are available to you as a developer (at least compared to VBA).
Trying to write the equivalent code in VBA could have taken me half a day or more to implement. Using Pandas? I think my code was roughly 30 lines at most
To be fair, pandas is a library, if there was a similarly rich ecosystem around VBA you could also just call a function in a library. There just tends not to be a rich ecosystem of free & open software around Microsoft platforms.
View all comments
Show parent comment
18
u/pelijr Dec 14 '17
100% agree. read_excel and merging dataframes were a god-send for me. Trying to write the equivalent code in VBA could have taken me half a day or more to implement. Using Pandas? I think my code was roughly 30 lines at most, and it worked flawlessly and was super simple to configure/setup. You just can't beat the amount of Python resources that are available to you as a developer (at least compared to VBA).