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: datascience
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 […]
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 […]
What are the visual ranges of animals?
Visual ranges vary widely among animals due to differences in anatomy, habitat, and behavior. The visual ranges vary depending on the species even within the same animal. In this post, I share the distance up to which some selected animals are known to see clearly. Just for context, humans with good vision can clearly see […]
Cartoon strip to a data-driven, interactive chart
Recently, I saw this cartoon strip on my Facebook feed from an account called “Homes”. It was sort of funny and true. But beyond that, I couldn’t help but think how much effort would it take to make this into a completely data-driven visualization? Don’t get me wrong, I’m a hobby artist (which you probably […]
When do we peak?
Recently, I came across an article stating how humans peak at different ages in different aspects. Surprisingly, and even perhaps amusingly it turns out that humans peak at different things throughout life from about 6 years of age all the way into the 80s according to the article based on scientific research. I captured the […]
Big Tech Layoffs…Causes, Trend, Outlook
Recent dynamics in the high-tech sector, especially in the software domain, show that the halcyon days of boundless innovation and exponential growth seem to have given way to a more somber era of widespread layoffs and uncertainty. Reflecting on the tempestuous years spanning from 2022 to early 2025, the industry’s stalwarts, once revered as invincible […]
Private Boats Ownership: Stats And Visuals
Step aboard as we sail through private boat and yacht ownership stats. This blog post touches on maritime luxury, dissecting ownership stats across selected regions. From the shores of the Mediterranean to the marinas of Florida and California, I’ll share some basic facts, interesting facts, and insightful visuals. Whether you’re a seasoned sailor or a […]
Planes, Trains, and Automobiles: Selected Stats
Let me present some stats on planes, trains, and automobiles in selected countries from around the globe. Specifically, I present metrics on trips by each mode of transportation, reported accidents, and finally, scores for each mode for each of the countries in list. I also explain the data sources, my methodology, and caveats. Sit back, […]