Python in Excel: How to visualize seasonality

July 9, 2025 | George Mount

Visualizing seasonality is a critical analytical skill in business because many essential metrics like sales, revenue, or demand often follow predictable seasonal patterns. Understanding these patterns helps businesses anticipate periods of peak activity, manage inventory, allocate resources effectively, and create accurate forecasts. Python in Excel makes seasonal analysis especially straightforward. ...
[...Read more...]

Python in Excel: How to work with Pandas MultiIndex

July 9, 2025 | George Mount

When working with complex datasets, especially panel data common in finance, managing multiple levels of indexing can quickly become overwhelming in traditional Excel. This is where Pandas’ MultiIndex feature shines. A MultiIndex in Pandas lets you efficiently handle data indexed across multiple dimensions, such as financial metrics tracked over time ...
[...Read more...]

Bokeh Display Customization in Python

July 7, 2025 | Dr. Darrin

In this post, we will examine how to modify the default display of a plot in Bokeh, a library for interactive data visualizations in Python. Below are the initial libraries that we need. The first line of code is where our data comes from. We are using the data() function ...
[...Read more...]
1 2 3 143