Get FAST results with 3D NumPy arrays! Python in Excel #25

Learning how to use 3D NumPy arrays (or arrays with higher dimensionality) can be daunting at first, but it's well worth the effort.

In the video I look at two possible solutions to a challenge from Kamran Mumtaz on LinkedIn.

Here's the challenge page:

00:00 Problem Statement
01:04 Solution 1 using a list comprehension
06:25 Solution 2 using a 3D NumPy array

#python #coding #excel #data #analytics

[DimEarly]

6:10 😮 I would have assumed it just pulled once and cached or something - good to know!

The Boolean cube was very cool. I half-jokingly told Joe McDaid when I started using dynamic arrays that we’d need to have a 3-D transpose for just this kind of situation - and here it is actually happening. Love it!

[nishantkumar]

Thanks,
Just a thought, I have not tried this.
Can we extract coordinates of unique set of characters from the table and then sum them up and create a dictionary for each characters and the replacement numbers and then use the replace characters to it's corresponding numbers.