How to use Python in Excel - Demo + My Review

Not exactly a snakes on a plane situation, but your spreadsheets are going to get a lot more hissy, thanks to introduction of Python for Excel.

So, in this video, I take the new "Python for Excel" feature for a test drive and share my thoughts. We are going to look at some practical examples of what you can do with Python in Excel, how it works, what I like and dislike about this feature and how to learn more about Python. So put on your strongest gumboots and jump in.

💥 DOWNLOAD FREE PYTHON FOR EXCEL GUIDE

📃 Topics covered in this video:

What is Python for Excel feature and how to use it?
Loading your data and building a dataframe in Python
Basic data analysis with Python in Excel
Creating a pivot table with Python
Libraries used by Excel Python (Pandas, Seaborn etc.)
What happens when there is an error or problem
Behind scenes - how your python code runs
Creating a chart with Python in Excel (using Seaborn library)
3 problems with Excel's python implementation
Resources to learn how to code with Python

⏱ Timestamps:
==============
0:00 - Introduction to Python in Excel
0:45 - Loading your data to Python and creating a dataframe
2:44 - Data analysis with Python in Excel
4:32 - Creating a pivot report with Python (groupby operation)
6:08 - Data Changes and Errors
7:16 - Data Visualization with Seaborn in Excel
8:43 - The good & bad of Python in Excel
10:26 - Excel python is not full python!
11:15 - Licensing of Python is going to be a pain
12:00 - Too many languages in Excel
13:02 - Next steps - how to learn Python properly

~ R E S O U R C E S ~

📘 Python for Excel - FREE BOOK:

💻 Get Office 365:
Use my Amazon link to get Office and support the channel.

📰 Python for Excel - Detailed Introduction + 10 code samples

👨‍💻 Learn to code with Python (3 simple projects)

📺 Python vs. VBA - Which is better?

🐼 Using Pandas Library - 10 examples

~

#python #excel

My for loop in python doesn't want to run any more.
It just needs some space. 🤣

[stopthink]

Chandoo, you have THE BEST Excel channel on YouTube!! So clearly explained, no marketing fluff, real world point of views. So rare these days and immensely valuable!! Keep up the awesome work!!

[pravinshingadia]

Your videos are brilliant Chandoo. You take time to explain both the good and bad of any new introductions and agree that this adds new level of complexity above learning all the other features.

[pup]

I learnt Excel from you back in 2010. Your passion for this is still the same. More respect and power to you Chandoo Sir !

[yupingsun]

the good thing about python in excel is some complicated calculations can be done inside excel with the help of python. A lot of people still like the interface excel provides for data and visualization.

[aiasaiascon]

One of the most Honest and Valuable review and opinion on the new features of Excel, because not everything that shines, is gold !

[Danny-extj]

8:10 Right click on the image > Picture in Cell > Create Reference
Alternative way instead of merging, Also...incase you need to paste into another sheet

[tw]

Wow.

1. Cloud based only
1a. Slow
1b. Nothing is private
2. Subscription based pricing
3. Not the full power of Python ecosystem

Python, running on your local machine and at full strength, can already get access to that local data and via installed libraries already do all of the data analysis and reporting.

And more. At full strength. Locally. For free. Excel or Libreoffice.

Microsoft is so lucky so many people are dependent on Excel, for whatever reasons.

The only advantage to this is letting Microsoft deal with keeping Python and third-parties up to date with no version conflicts. That is certainly worth _something_, but not even close to balancing out the negatives.

Thank you for this great video! Excellent presentation. Subscribed.

[allanmachado]

Thank you. I think you saved me a lot of time. I've been trying to decide on the right language to build myself some tools for work. I've been using Power Query M, but it hasn't been the right fit for the job. The tools need to be portable and M hasn't been great for that. The tools also need input from the user depending on what is in the data. There are several other challenges I found with using M for my tools. I know I could build my tools in VBA and it would resolve the challenges I faced in M, but I didn't want to build my tools in a dying language if there's a better new way. I thought Python in Excel might be the way or maybe the Javascript library, but ultimately it seems VBA will still be the answer (weather it's dying or not). Seeing this video was the tipping point on the decision. I'm glad I didn't put hours into exploring Python in Excel at this stage. Thanks again.

[venkatatalatam]

Thanks you! you've made complex tasks feel accessible! Mr. Chandoo

[piyushnautiyal]

Very excited to use python in Excel.. thanks chandoo for the amazing video lecture on this topic 👍👍

[TomlynAdvisors]

Would be good to first being with a high level overview of what python is and the benefits of using it. This way it will make better sense for students to follow, rationalize, and understand the video.

[shrirams]

03:55 timeframe, my roommate was checking with me whether i am studying or watching something else 😂

[dereksmith]

The key advantage for me as someone who switches between excel and Python/Pandas, is that sometimes I don't know where I want to go with my data. Being able to create intermediate dataframes and see them in excel, before having that lightbulb moment, is something that I struggle with when working in VSCode. Holding a many step dataframe sequence in your head as you work towards a solution is tough. This may be a good way to deal with that. I look forward to trying it out.

Nice video.

[davidfelipepenaguardiola]

Thanks so much for this absolutely usefull video, Mr. Chandoo

[IoannisStoupis]

Thank you Chandoo! I always follow your videos and I want to say that you are amongst the best instructors for Excel and beyond.

[barttitulaerexcelbart]

Thanks Chandoo, I saw a few video's about the new Python, but you were also giving con's. That is very good! Sometimes we do not realize how much the scope of Excel has widened. see min 12.30. Very good video!!

[sairamadaboina]

Thank you Sir, your explanation was very effective, please upload more and more new trending courses.

[dheerajpatel]

Thankyou Chandoo for the amazing information. Helping a lot of people like me in our daily tasks.❤

[llal-India]

Lovely! seeing chandoo in years and he is awesome as always.

[vaibhavshinde]

This is going to be a game changer for Traders.... Unbelievable algos can be written now...