Blog

STEM

Find Superscripts, Subscripts, and Unicode in a text file (Python)

Occasionally, it becomes necessary to search for special characters like superscripts, subscripts, symbols, emojis, or any Unicode characters within a text document. This is crucial when working with data files that should not contain any such characters, unless they are explicitly required and managed. Most editors, including Word, lack a ‘Find’ feature that reveals all […]

Read More
STEM

How to make a perfect birthday cake in Excel

I’ve been exploring whether it’s possible to create a birthday cake-style chart in Excel. After some adjustments, I’ve reached a point where I can confidently say it’s achievable! You may ask, why not simply download an image from the internet? Well, that’s less engaging, potentially unlawful, and above all, it lacks the customization and scalability […]

Read More
Analytics Coding Education STEM

Excel…aww…I love you too!

Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]

Read More
Analytics Coding Education STEM

Creating A Game Timeline Chart in Excel

Recently, while following the thrilling Premier League matches, I came across an eye-catching visual representation of the day’s game scores and timelines on BBC Sports. The post appeared as follows (on my mobile app): It’s both beautiful, elegant and conveys the key events of the game without overwhelming the viewer with too much other details. […]

Read More
Coding STEM

Windows 11 Boot MicroAnimation and Wise Monkey using just text

Recently, an ex-colleague of mine brought to our attention the Microsoft font possibly used in creating the spinning dots in Windows 11 boot screen. The font is called “Segoe Boot Semilight” and is a true type font. So, I had to verify that this is true, and I wanted to try to create the animation […]

Read More
STEM

Different ways to generate a list and array containing numbers

In this post, I show different ways to generate a list and array containing numbers (ints, and floats, positive and negative, mixed) in python…using random, list, and numpy arrays. Why do we need both? NumPy arrays are very efficient for numerical operations and require elements to be of the same data type, whereas lists are […]

Read More
STEM

Finding min, max in a sequence and plotting the distances

Let’s say that we have a sequence of numbers in consisting of whole numbers, fractions, positive and negative numbers of varying length, that is, of no predefined length (e.g.2.25, 5.25, 6.75, 8.25, 9.75…). What we want to do is to sort the numbers in ascending order, and find the differences between 2 adjacent numbers and […]

Read More
Back To Top