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
https://chandoo.org/wp/downloadfree...

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:
https://chandoo.org/wp/downloadfree...

Get Office 365:
Use my Amazon link to get Office and support the channel.
https://amzn.to/3sA7DUJ

Python for Excel Detailed Introduction + 10 code samples
https://chandoo.org/wp/introductiont...

‍ Learn to code with Python (3 simple projects)
Article + Code: https://chandoo.org/wp/pythonforexc...
Video:    • Python for Absolute Beginners with 3 ...  

Python vs. VBA Which is better?
   • VBA vs. Python  Which is better?  

Using Pandas Library 10 examples
   • Learn how to use PANDAS in Python in ...  


~

#python #excel

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