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
In questa pagina del sito puoi guardare il video online Python in Excel! Part 6 - Using Python to restructure data! 🐍🤩 della durata di ore minuti seconda in buona qualità , che l'utente ha caricato flexyourdata 27 agosto 2023, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 4,295 volte e gli è piaciuto 114 spettatori. Buona visione!
