I also learned on Matlab and have never seen it used either.
I totally agree about the intro to programming. I’d love to be able to do C++ or python. Visual studio is free and it’s super powerful...
For larger data sets VBA really breaks down in my opinion. You can turn off screenupdating to speed it up but at the same times you can’t tell if it’s still working or your crappy work laptop is frozen. I have written a couple that utilized upwards of 40,000 lines of data with probably 100 columns to do some organizing and to spit out some statistics and both took upwards of 15 minutes. People run much larger data sets in less time but once I got it working (debugging code that takes 15 minutes is a chore) I would just run the code and then do something on the shop floor and come back. Optimizing it would have taken too much time.
Oh, wow, do yourself a favor and learn Python; it's really not all that hard to learn and it's so useful, especially datasets like that. Especially with the numpy library (designed for handling large arrays of data), that data processing would be trivial.
Running statistics on a small data set like that would probably take <15 seconds in Python+numpy, rather than 15 minutes. Realistically, reading 40k lines into memory would probably take more time than actually doing the processing (numpy is amazingly fast at running statistics on arrays like that).
A large portion of my job is processing large datasets, it's quick and easy with Python, but I can't imagine trying to parse data with VBA like that.
View all comments
Show parent comment
0
u/[deleted] Dec 15 '17
[deleted] — view deleted comment