Python in Excel is a GAMECHANGER

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
In this video, I take a close look at the promising fusion of Python within Excel, and it's quite a transformative experience. From the basics of converting Excel tables into Pandas dataframes for more structured data handling to crafting visual data narratives using Matplotlib and Seaborn, I cover it all. As a practical application, I offer an in-depth analysis of a Japanese sales transaction table, extracting valuable insights directly within the Excel environment. Along the way, I'll share my thoughts on this integration and discuss some limitations that users might face.

🌍 𝗟𝗜𝗡𝗞𝗦:

⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
0:00 – Introduction
0:39 – Starting with a Basic Example
3:45 – Diving into a Real-World Analysis
9:05 – Sharing My Thoughts on Python in Excel
11:36 – Discussing the Limitations of Python in Excel
12:00 –Outro

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:

[CodingIsFun]

*What do you think about the integration of Python in Excel? Let me know in the comments!*

[LukeBarousse]

My dude, I'm glad to see you got access!! Also, your Excel sheets are SO organized; I need to get on your level! 🙌🏼

My spreadsheets look like a hot mess 🔥💩

[echidne]

For the moment I think the limitations are too important (working only with 365 online) I prefer to use the tools already in place like xlwings or your toolbelt. I'm wondering also what are the sizes of your excel files with Python inside?

[Mandelbrot]

As I am retraining as a data analyst I have been learning python with pandas recently and am really pleased with this development. I was not looking forward to learning TypeScript as well so hopefully python will be a good option.

[memolingvo]

How to install the Python libraries which are missing in the Python for Excel?

[ОлегВоропаев-къ]

Cool!!! Integration of everything with everything, soon it will be possible not to leave the house at all, all desires will be fulfilled instantly:)

[m.bouguerra]

a big thank you for this valuable information, and I would like to practice on the example file of your tutorial, can you share it.. thank you again... I am an Algerian who follows you

[RashmilDahanayake]

Which version of Excel supports this? Or do you have to enable a specific tool bar?

[GamePulseMemes]

is it available for excel 2021 version

[eska]

Top Video. Thank you...i didnt know about that. I work with vba...but vba will Not be Further development...so to know about the possibility wird python is goof to know :)

[ixternal]

Seems like it'll be useful for some things but mostly irrelevant for the majority of cases where you would use python over excel.

[nafizhaq]

hey thanks for sharing! Would you do a series of video to use python and panda in excel?

[theeurostep]

Hopefully this goes through beta stage soon.

[Aardappeltje]

You can use it in a very limited way if you are a O365 Family subscriber. I’m impressed with Python, but not with Microsoft.

[FoobsTon]

under the formulas ribbon you will see no, it's not there.

[HarshColby]

Python in Excel is so slow it's useless.
I hope they fix that before making it publically available to everyone.
It's way faster to write an external python program to open Excel and make updates.

[Shubham.y]

Hey, Sven can i be your YouTube thumbnail designer.
I will design your Thumbnails more eye catching to engage people.
I recently design your Thumbnail topic name AI app.
Pleas

[peterxxl]

A really stupid idea. The last thing an Office user needs is another programming language whose ONLY obvious use is to call FUNCTIONS from a function LIBRARY, which in turn was written in completely different languages. It would have made much more sense to make libraries like NumPy or Pandas directly accessible for VBA, instead of converting table cells into uncomfortable editor fields for Python scripts (this is also possible with other libraries whose functions can be called as functions or formulas). If I only need Python to call C, C++ or Rust functions, there is a lot wrong. What Microsoft thought about this remains mysterious - the explanations are anything but rational - it will probably be about economic interests. Probably they have seen that obviously many people like to program in Python and want to bind them as new customers, what do I know. Once again, it's a stupid, completely unnecessary idea - and I'm not saying that because I have something against Python, but I would also say that if it were any programming language.

[logenninefinger]

Not exactly what you would call an editor. Bah.. terrible, who really uses that?