Forum Discussion
Dynamo14324
Sep 30, 2022Copper Contributor
excel to python median if calculation?
srno sku rp sp lp 1 watch34 2799 3243 2524 2 watch34 2799 324 23423 3 watch34 2799 3432 2343 4 watch34 2799 3243 23423 5 - 3243 3243 234 6 watch34 2799 ...
GeorgieAnne
Oct 01, 2022Iron Contributor
Hello Dynamo14324
Just playing the Devil's advocate how do you know that Python will be any faster?
What I would suggest is to figure out what is going on to slow down this process and then figure out how to speed it up. I tried this on my development machine (3.07 gigahertz Intel Xeon X5675 (2 installed) and MS-Excel is using all 24 Hyper-threads) and it took a millisecond! No I did not measure the time, I just guesstimated. Tell us what version of MS-Excel are you using and stuff like that and lets see if we can help you speed this up.
Just playing the Devil's advocate how do you know that Python will be any faster?
What I would suggest is to figure out what is going on to slow down this process and then figure out how to speed it up. I tried this on my development machine (3.07 gigahertz Intel Xeon X5675 (2 installed) and MS-Excel is using all 24 Hyper-threads) and it took a millisecond! No I did not measure the time, I just guesstimated. Tell us what version of MS-Excel are you using and stuff like that and lets see if we can help you speed this up.