How Branchless Programming Can Speed Up Excel
Last Updated on July 19, 2023 by Editorial Team
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