Python in Excel! Part 6 - Using Python to restructure data! 🐍🤩
Guys. I tried. I did. Honestly.
I really tried not to turn this into a Python tutorial. Buuuut... there's only so much "press this button to get that candy" we can talk about before we start to ask ourselves:
Why bother using Python?
What's the point?
Or before we convince ourselves:
I can do this with a formula
I'll stick with Power Query
I mean yeah. You could. It's definitely doable. LAMBDA and dynamic arrays mean there's very little you can't do.
But there are some things that are just SO much easier with Python.
Let's look at a challenge posted last year by Wyn Hopkins regarding expanding a range of Ticket Numbers.
At the time this was a perfect opportunity for LAMBDA, so I created a generic solution called STACKER which has proved useful over and over again since then.
If you haven't watched the STACKER videos yet and you're interested in advanced LAMBDA solutions which have nothing to do with Python, please take a moment to watch the videos linked in the comments.
Anyway, in this video I have a go at solving the challenge with Python.
The star of the show here is definitely df.explode.
Knowing the kind of data we often see in Excel, I have a feeling this is going to become your new best friend.
Let me know what you think in the comments and don't forget to like/share/subscribe for more! 💬
#data #analytics #excel #python #dataanalytics
On this page of the site you can watch the video online Python in Excel! Part 6 - Using Python to restructure data! 🐍🤩 with a duration of hours minute second in good quality, which was uploaded by the user flexyourdata 27 August 2023, share the link with friends and acquaintances, this video has already been watched 4,295 times on youtube and it was liked by 114 viewers. Enjoy your viewing!
