30 Days to learn Python in Excel?? [Day 1]

30 Days to learn Python in Excel?? [Day 1]

Diarmuid Early

10 месяцев назад

6,371 Просмотров

Python is now in Excel! I'm very excited, and planning to focus on learning to use it over the next month. This will involve a lot of floundering around, writing bad code, and probably looking silly - but that's how we learn!

You can access all the files I use as I work through this (at least the ones I'm able to share) here:
https://1drv.ms/f/s!Aryypvyx4xIO3BDB5UetNvBOsC3a?e=kRX2o6

Today's task was a challenge from Vijay Verma (Excel BI) on LinkedIn - you can find it here:
https://www.linkedin.com/feed/update/urn:li:activity:7102137802192039937/

This excellent (and still growing!) play list by Carlos Barboza (@spilledgraphics) has loads of other new videos for learning Python in Excel:
https://www.youtube.com/playlist?list=PL6oXAzzeKAHeEj6csfyI6iuGQTO1H5Ok4
Ссылки и html тэги не поддерживаются


Комментарии:

Gabrielle Amadeus Mozart
Gabrielle Amadeus Mozart - 13.10.2023 08:57

Cool af.

Ответить
Edward Lorenz
Edward Lorenz - 05.09.2023 06:41

Why 30 days? Why not 31 days?

Ответить
Yameron
Yameron - 30.08.2023 05:34

unfortunately the option to insert python still not obtained. Even though I signed up for the insider program (beta channel)

Ответить
Greg Hingsbergen
Greg Hingsbergen - 29.08.2023 20:54

Thanks Diarmuid - this is the next best thing to having the beta myself! Like you, learning Python was always on the agenda but never quite got around to it - although I have at least set up the environment 😉

Ответить
Harry Gross
Harry Gross - 29.08.2023 19:50

There are some noticable issues with the recording software in this one - we often get hiccups building codebases when video calling iver slack/zoom and I know python is inefficient, but still this is so little python that I would be surprised if that's the culprit... worth checking task manager diagnostics when everything is on and seeing whether cpu/gpu/memory is the issue and what's hogging it

Ответить
Excel Wizard
Excel Wizard - 29.08.2023 19:31

I do so many 3! and still many more to go

applymap seems to work

xl("A2:A10").applymap(classify)

df => DataFrame.applymap
df.sentence => Series.apply

Ответить
Dipesh Das
Dipesh Das - 29.08.2023 19:11

🎉🎉🎉🎉

Ответить