How to use Python in Excel - Demo + My Review скачать в хорошем качестве

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 Easy ...   📺 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 15 mi...   ~ #python #excel My for loop in python doesn't want to run any more. It just needs some space. 🤣