Microsoft Excel Tutorial: Python in Excel
After using Python in Excel for 2 days, I am gaining confidence. Topics today:
• Python Tips from Day 2
• Slow rollout of Python
• Paying for Anaconda
• Python Libraries to explore
• How to write Python results back to Excel grid
• Real-life K-Means clustering with 18K customers, 30K transactions, 300 products
To download the first workbook: https://www.mrexcel.com/youtube/GMF1E0dmjWs/
The second workbook contains actual customer data and I am not sharing it at this time.
Table of Contents
(0:00) Welcome
(0:45) Keyboard shortcuts for Python
(1:22) Leila tip DF.Customer eliminates square bracket notation
(2:14) Seaborn Library of Charts as shown by Mynda
(2:49) Initialization of 5 Python libraries automatically
(3:25) Partial Calculation Mode in Excel
(3:48) Use .Mean for AVERAGE()
(4:10) Chances you have Python
(4:40) Eventual cost is Anaconda which adds security
(5:15) Python libraries supported
(5:35) InDesign and Ctrl+Alt+Shift shortcuts
(6:37) Writing Python results back to Excel!
(8:21) Python examples start with fake random data
(8:39) Real data example with Python
(8:52) K-Means clustering based on 100’s of products
(9:48) Using Power Query with Python in Excel
(11:20) 3D Scatter Chart in Python
(11:52) Choosing Number of Clusters
(12:13) Reset Python after 30 minutes inactivity
(13:00) Loading data frame back to Excel grid
(13:55) Data-Sciencey
(14:15) Tomorrow: Python pivot tables in Excel