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

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:

Today's task was a challenge from Vijay Verma (Excel BI) on LinkedIn - you can find it here:

[GregHingsbergen]

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 😉

[ExcelWizard]

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

applymap seems to work



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

[ReactionSquad]

how did you created a list before creating a dataframe

[Harryjackgross]

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

[Harryjackgross]

My comment about the map/apply thing got killed because it linked away from YouTube

To summarise:
1) I am very jealous that you have Python now
2) I am not that familiar with Python (pandas in particular here) and series vs data frames
3) Stackoverflow says map works on series and apply/applymap works on dataframes
4) Series appear to ‘make up’/'be columns of' dataframes

[yameron]

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

[Nabsii]

wouldn't be smart to show how to activate/add python in excel in first place?