In my earlier blog post An Interactive Musical Keyboard Player (Python), I shared the full code on how to write an interactive musical keyboard that can also save what you play into memory and optionally to a file. In this post, I’ll share a related component as a separate code module that can read a […]
Blog
GDP Per Capita and PPP Adjusted GDP
We all know GDP (Gross Domestic Product), and GDP Per Capita is calculated by dividing the GDP of a nation by its population. Essentially, it represents how much economic production value can be attributed to each individual citizen. In this post, I present GDP=PPP and compare it to GDP Per Capita for selected countries to […]
Home Prices across USA and other metrics
In this blog post, I delve into an extensive collection of data and computations related to home prices across the United States. I examine the affordability of homes in each state, including Washington D.C., by taking into account regional income, down payment, loan costs, and mortgage payments. I also consider the minimum salary requirements needed […]
Gini Coefficient and how to calculate it
The Gini Coefficient is a way to measure the income distribution of a population. The value for the Gini coefficient ranges from 0 to 1 where higher values represent greater income inequality and where: 0 represents perfect income equality (everyone has the same income) and 1 represents perfect income inequality (one individual has all the […]
Reshaping data for Excel via Python
In this post, I demonstrate an effective way to reshape a CSV or XLSX file that originally has multiple rows repeating for each column. For example, many raw data exports will include a country’s metrics (GDP for example) for the year in each row and it repeats for different years as rows. Cntry Year GDP […]
Charting Team Lineups & Formations (Excel)
We have all seen the team lineups and formations graphics on TV for soccer (European football) games. It got me wondering if I could create a chart instead of a static image that can be easily scaled for any teams, any formations just by updating the underlying tables. It turns out, I can. It takes […]
Conditional Formatting Presentation (Excel)
Microsoft Quarterly Report was publicly released on April 25, 2024. It has tabulated data on year over year percent change in revenues by Microsoft fiscal quarter (Q1 is from July 1 through September 30). I tabulated the data from fiscal year 2023 Q1 through Q4, and from fiscal year 2024 Q1 through Q3 (Q4 data […]
Dumbbell Chart (Excel)
Dumbbell chart, aka Connected Dot plot is a type of chart that’s suitable for visually comparing values especially between two periods or showcase change. In this post, I demonstrate its usefulness as well some key steps on how to create one in Microsoft Excel (Office 365). Let’s start with the data. I have some data […]
Butterfly Chart (Excel)
Butterfly chart (aka Tornado or Divergent chart) is a type of bar chart used to compare two data sets side by side.It plots the data as two horizontal bars with the same X-axis in the center, resembling the butterfly wings.It gives a quick glance at the difference between two groups with the same parameters. It’s […]
An interactive musical keyboard player (Python)
In this post, I am sharing my Python code for creating a simple musical keyboard player that can be played using a standard computer keyboard. The app will generate specific musical notes as you press keys A-Z on your keyboard. You can increase a note by half-step or full-step by each press. So, increasing by […]