Python in Excel is a feature that allows users to write and execute Python code directly within Excel spreadsheets. This integration enables advanced data analysis, automation, and visualization without needing external add-ins or additional purchases. Advanced, complex visualizations that are not possible directly in Excel is now possible with Python code that uses powerful libraries […]
Tag: programming
Bull’s-eye Diagrams — Dyamic, Data-Driven
A Bull’s-eye diagram in general terms, is a conceptual model designed to bring focus to the most important items from a collection of items. The diagram helps us prioritize various tasks and therefore often used in strategic decision-making and brainstorming situations. As on a dartboard, the diagram has an inner most smallest circle, and multiple […]
The “coolest code” Bill Gates ever wrote
As part of celebration of Microsoft’s 50th anniversary on April 4th, 2025, Bill Gates has shared the original source code for Altair BASIC. He described Altair BASIC as “the coolest code I’ve ever written”. Altair BASIC was developed in 1975 by Bill Gates and Paul Allen for the Altair 8800 microcomputer. This was Microsoft’s first-ever […]
Stock Data Acquisition And Analyses (Python, Excel)
The stock market is a prominent topic in recent public discussion. Rather than focus on the market itself, this post examines methods for acquiring stock data, reformatting it for use, generating various calculations and visualizations to facilitate analyses, and yielding insights. I will share my approach and point out some useful metrics and observations along […]
Do you know your leap years? Are you sure?
Many people remember to figure out whether a year is a leap year or not by checking if a year is divisible by four. If it is, it’s a leap year, meaning, the month of February of that year has 29 days and the year has 366 days, and if not, the month of February […]
Area Charts – Edgy to Smooth (various options)
Area charts are a great option when we need to show trends over time while also emphasizing the magnitude of values. They allow us to compare multiple series or variables easily, while the filled area illustrates the magnitude of values, and they also show how a part contributes to the whole over time. In this […]
Arrays, NumPy, Vectors, Tensors: 0 to 4+ Dimensions Demystified
In the domain of Python programming, data structures are the pillars of efficient and dynamic coding. From the straight-forward one-dimensional lists (arrays) to the complex realms of multidimensional arrays and tensors, Python provides a robust framework to handle and manipulate data. These are not just academic concepts; they are the building blocks of machine learning […]
Categorizing free-form feedback with ML
One of the toughest parts of analyzing survey feedbacks is processing the free-form feedbacks into some quantifiable measures. This is because people express the same thoughts differently, use different styles, spellings, lingos, abbreviations, and not surprisingly, inadvertently introduce spelling and grammatical errors. In order to quantify such entries, we have to arrange each feedback into […]
Handy bespoke helper library you can use in your code
In this post, I’m sharing a script loaded with useful functions that you can use in your code with ease for performing a myriad of necessary and critical tasks without the need to write (and rewrite, test and retest) your code. Just import it and call the function(s) you need. This Python helper library provides […]
A Complete Library Simulation with SQLite Database and Python
I am thrilled to announce that the end-to-end system for a book library is now finished and available for download! It’s a comprehensive package of a preloaded SQLite3 database designed for simulating a book library using Python with all source code and documentation included. The database contains 4 tables (preloaded, and fully documented) and sample […]