How Branchless Programming Can Speed Up Excel

Author(s): Ashutosh Malgaonkar

Originally published on Towards AI.

An Example of Branchless Logic Using Excel for Classification

Source: Unsplash

This is an article that uses the IRIS flowers dataset and the geometric mean classifier as an example to introduce the application of branchless logic in excel. (see video below to learn more on this )

Branchless Programming — https://www.youtube.com/watch?v=bVJ-mWWL7cE

This example will walk you through an example of converting a nested if statement use case into a faster calculation without any if statements. This improves performance in large excel workbooks and also makes code much shorter.

Imagine you are looking to classify the three flowers from the IRIS dataset based on their high-low range show below. The easiest way to program… Read the full blog for free on Medium.

Join thousands of data leaders on the AI newsletter. Join over 80,000 subscribers and keep up to date with the latest developments in AI. From research to projects and ideas. If you are building an AI startup, an AI-related product, or a service, we invite you to consider becoming a sponsor.

Published via Towards AI