I have been tinkering with the GUI library for Python called tkinter. There are some interesting features in it although I’m not thoroughly impressed by the API designs. It feels to me a little clunky and at times, work-in-progress or subject -to-change type of work. Nevertheless, I’m always curious and I had to explore. Specifically, […]
Category: Coding
A complete weather app (Python)
Here, I show step-by-step a complete weather application built using Python. Along with the critical explanations, the full source code is also included. The app makes a RESTful API call to weather service, gets the results back in JSON, then it parses the information and presents it in locale-specific format. The information we will send […]
Parsing date-time string and formatting according to AM/PM (Excel)
Here’s a relatively quick way to parse a date-time string or any string (regardless of data type in your source) containing date and/or time. It doesn’t matter if the time format is in 12 or 24 hour format, this method works. The time portion of the data can be in HH:MM:SS or HH:MM or similar […]
Tracking Actual vs. My Predictions 4/29/20
Back in March 2020, I did some predictive modeling using simple math and Excel where I presented 3 scenarios: Likely, Best-case, Worst-case. You can read the original blog here: What-If Models (COVID-19): Results Let’s take a look at today’s latest data from WHO and compare my Model 1: Likely Scenario numbers. We’ll compare the USA […]
Generating, plotting trajectory and…gamification (Excel)
Reminiscing the old tank game, I wanted to re-create a low-weight, low-code option of that simulation. The game depended on a canon (projectile) shot at your selected speed and angle to hit an enemy tank. The foundational formula is used in missile launch, sports, and many (you guessed it) military applications. Here, using the same […]
Selected movies: searchable, sort-able for utility and fun
Today, I present a web application with a list of selected movies (about 3,000 titles) I extracted using developer APIs from IMDB and OMDB databases using my Python app. After extraction in the app, I reshape the data according to my needs and then export programmatically to XLSX format (for Excel). Which is then wrapped […]
What-if Models (COVID-19): Results
Here are the results of the four models that I had created to get results of What-If scenarios around COVID-19 (“corona”) virus using the data on hand as published officially as of 3/20/2020. Since we don’t have all the answers or even data for many variables, I hypothesized in such instances. For explanation of my […]
Creating Beautiful Violin Plots
A violin plot is a visual that traditionally combines a box plot and a kernel density plot. This is typically created in R, Python languages using MATPLOTLIB and other applications/modules. However, I show here how to get it done using only PowerBI. About Violin Plots Before I go into how to plot it, let’s understand […]
How many cats and dogs are there in your city? (method and cool charts)
In this seemingly simple couple of charts, I demonstrate a few nifty tricks that are fun and effective. First, we want to find out how many cats and dogs in a few selected cities (around me) and come with an educated estimate based on data. Then, we will use some cool, free add-in to create […]
Understanding buckets, bins, categorization (3/3)
In this multi-series of blog, I’ll touch on different ways to categorize data in buckets, or bins, and summarize in meaningful ways. Some will use Pivot Tables, some will not. But we’ll cover 3 common scenarios. Let’s do the third and final one here… The Scenario We have about 2,000 rows of data on sales […]