Introduction to Data Visualization with Python in Excel
Integrating Python with Excel stands as a groundbreaking plug-in that acts as a bridge connecting two popular but previously separate ecosystems. Seamlessly integrating Python code within an Excel workbook empowers us to leverage Python’s extensive libraries for data analysis and visualization right within Excel, making it an invaluable tool for data enthusiasts and analysts. In […]
Introduction to Text Analysis with Python in Excel
Text analysis is an essential technique for extracting valuable insights from unstructured text data that serves as a fundamental component of natural language processing (NLP) applications and more. In this blog post, we will explore an exciting new way to perform text analysis using Python within the familiar environment of Microsoft Excel, made possible […]
What Are Python Packages in Excel?
https://www.youtube.com/watch?v=JskOwIuSECU [Transcript] You may come across the term “package” or “Python library” as you dive into the world of data analysis with Python. Packages—or Python libraries—are collections of code written to perform a specific task. Anaconda enables you to quickly access over 400 packages for use in Excel, and if you want to take your […]
Announcing Python in Excel: Next-Level Data Analysis for All
Now you can write Python code directly in Microsoft Excel’s grid—no Python installation required. Today, Anaconda and Microsoft announced a groundbreaking innovation: Python in Excel. This marks a transformation in how Excel users and Python practitioners approach their work. For Excel users, this opens a new world of data analysis potential previously limited to […]
Why Data Scientists Should Be Excited About Python in Excel
I know what you’re thinking. If you’re an experienced data scientist, your work with Excel may be grudging or fleeting. But in stepping outside the rarified realm of data science and engineering, you will discover a very different reality. People in positions of responsibility have used spreadsheets to make critical decisions for several decades now. […]
Python for Excel Analysts: Filtering Tables
This is the third in a series of blog posts that explains how to work with tables of data using Python code. The subject of this post is one of the most common operations performed when analyzing data: filtering tables. The most impactful analyses are born from the best data. Filtering your data using the […]
Create Your First Machine Learning Experiment with Python in Excel
The new Python in Excel integration by Microsoft and Anaconda grants access to the entire Python ecosystem for data science and machine learning. Thanks to its direct connection to Anaconda Distribution, we can leverage built-in functionality with packages like NumPy, pandas, Seaborn, and scikit-learn directly within our Excel workbooks. This post will explain a simple use case for creating […]
5 Quick Tips for Using Python in Excel
In this post, I share some useful tips, tricks, and lessons I’ve learned since diving into the new Python in Excel integration. You can follow along with these tips by opening an Excel workbook and trying to replicate the code and described behaviors (when applicable). Note: To reproduce the tips in this post, install the […]
From Notebook to Workbook: Power Up Your Data Science Skills with Python in Excel
The most common way to create effective data reports with Excel and Python normally requires loading the data into a Jupyter notebook (e.g. using pandas) and converting the notebook itself into a report to share with stakeholders. But what if we didn’t need to work in external Jupyter notebooks anymore, and instead could work with Python […]
Python for Excel Analysts: The Basics
As a Microsoft Excel analyst, you know that data tables are the raw materials of any analysis. It doesn’t matter if the raw materials are tabular worksheet data, Excel tables, or PivotTables. Everything in analytics starts with a table. Similarly, your Python journey starts with data tables. This is the first of a series of […]
