Python’s incorporation into Excel offers data analysts robust new tools, particularly in the realm of data visualization. This blog post introduces Matplotlib, a core Python library for crafting visualizations. We’ll begin with the essential components, explore Matplotlib’s customization features, and discuss the benefits of using Pandas DataFrames ...

Over on LinkedIn, Dennis Sawyers is always a lively and outspoken voice worth following. His latest post has sparked my interest, compelling me to share my own thoughts candidly. Dennis argues that traditional BI tools like Tableau and Power BI might no longer be necessary due to AI advancements, especially ...

As we delve deeper into the age of artificial intelligence and AI-assisted programming, a question arises: Are the plethora of programming languages in Excel becoming obsolete? With the advent of AI, Python, and tools like Copilot, are we on the cusp of a paradigm shift in how data tasks are ...

Multimodal neural networks are a type of model designed to integrate data from multiple modalities, such as text, images, audio, video, or other data types. Multimodal networks aim to learn complex relationships between different kinds of inputs...

The latest release of Posit Package Manager introduces several enhancements, including: Python Git Builders: Build Python packages (wheels) directly from Git. Blocklists: Easily block specific packages or versions. Improved Documentation: Cleare...

On Day 29, we conducted our out-of-sample test on the four strategies and found that the adjusted strategy came out on top. We made this conclusion after ranking a cross section of the following metrics: cumulative return, Sharpe Ratio, and max draw...

Pyomo is another flexible Open Source optimisation modelling language for Python. It can be used to define, solve, and analyse a wide range of optimisation problems, including Linear Programming (LP) and Mixed-Integer Programming (MIP), nonlinear programming (NLP), and differential equations. 📢 The book Hands-On Mathematical Optimization with Python (available free online) ...

In a previous post, we explored the plotnine package in Python in Excel, highlighting how its implementation of the Grammar of Graphics allows for an almost limitless array of possibilities in creating any plot imaginable: In this post, we’ll focus on how to craft layered (i.e., multiple elements ...