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 […]
Tag: analytics
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 […]
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 […]
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 […]
Did Seahawks Need an Overhaul for 2024 season?
Seattle Seahawks find themselves at a crossroads after the 2023 NFL season. The team faces critical decisions regarding their coaching staff and personnel. Changes came hard and fast to some fans’ surprise, and to some, expectedly if not a little later than expected. Whatever your position is there are arguments for both supporting an overhaul […]
Projecting Neocaridina Shrimp Population
Two months ago I wrote an app for myself to keep track of my new hobby Neocaridina Shrimpkeeping. It was only 2 weeks before that I started the hobby before I recognized that a handy application to keep track of my shrimp’s water parameters, treatments and care with curated, accurate information would be very useful. […]