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
https://chandoo.org/wp/download-free-...
📃 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/download-free-...
💻 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/introduction-t...
👨💻 Learn to code with Python (3 simple projects)
Article + Code: https://chandoo.org/wp/python-for-exc...
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. 🤣
Watch video How to use Python in Excel - Demo + My Review online without registration, duration hours minute second in high quality. This video was added by user Chandoo 05 September 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 107,229 once and liked it 2.6 thousand people.