Python in Excel day 2: list comprehension, regex, unpivot, and more!

preview_player
Показать описание
Day 2 of my mission to learn Python in Excel.

You can access all the files I use as I work through this (at least the ones I'm able to share) here:

The challenge files also include links to the original challenges on LinkedIn.
Рекомендации по теме
Комментарии
Автор

😍😍love all these topics. Learn so many new stuff here.

ExcelWizard
Автор

Great video. You have a knack for teasing the detail out of these problems. Just goes to show that programming language isn't as important as logical thinking.

As an aside:

pd.Series.str.split == TEXTSPLIT

would grab the brand code. But I tried it in apply and I think there's a bug (reported to MS).

flexyourdata
Автор

I have the Linkedin challenge site link, but what was the other challenge site you mentioned?

cedjulemckeever
Автор

Finally 😂😂 get unstack work

df = xl("B8:G20", headers=True)
up =

ExcelWizard
visit shbcf.ru