PYTHON IN EXCEL! Part 11 - Speed tests and changing the output type of xl!🐍😍
Never did I think I'd make a video 11 days in a row. But here we are. I really enjoyed what I found in this one. I hope it will help you or at least spark some ideas about how you can use it.
1. Learn how to use the IPython Magic (yes that's really what it's called 🪄) %timeit to test how fast your solution is. Spoiler: there are times when a NumPy array is much faster than a Pandas DataFrame
2. Learn how to change the output type of the xl method from DataFrame to ndarray. Spoiler: you pass a custom callback function into the initialization method excel.set_xl_array_conversion
3. If you're not familiar with callback functions, please check out my video "Functions as parameters with Excel LAMBDA" here: • Functions as parameters with Excel LA...
In that video I try to explain how we can pass functions as arguments to other functions.
#data #analytics #excel #python #pythoninexcel