Aside from Pandas and Matplotlib, Openpyxl, Squarify, and Pyexcel are some of the popular Python libraries out there. I can’t wait to take them up for a spin in my Excel workflow.

Pandas makes it easy to quickly load, manipulate, align, merge, and even visualize data tables directly in Python.

Data analysis and visualization: Pandas and Matplotlib Python’s dominance in data analysis is evident through libraries such as Pandas and Matplotlib.

Python libraries like Pandas, NumPy, SciPy, and Matplotlib streamline data cleaning, statistical analysis, and visualization directly within Excel.

Stefanie Molin's new book, “Hands-On Data Analysis with Pandas" is about using the powerful pandas library to get started with machine learning in Python.