In this post, I’ll show how to write a program that reads x,y coordinates for a complex shape (Polygon) from an external source. Then recreate the shape on a canvas with some interactivity. The application’s action clip is below: In the above clip, I’m reading datafiles that contain the coordinates as a series of contiguous […]
Category: Coding
Scattered Data to a Butterfly, or a Tornado!
What do butterflies and tornadoes have in common? 🙂 Butterfly charts aka Tornado charts are a special type of Bar chart where the data categories are listed vertically instead of the usual horizontal layout. It’s suitable for comparing different variables between two groups (e.g. male/female, apartment/house, car/boat, etc. etc.) and what variables you measure is […]
Interactive Text-To-Speech App with Presidents of USA (Python)
In this blog, I’ll discuss how to build an interactive lookup of data and have the results spoken back to you in human language. Specifically, I have a list of all POTUS to-date in a file (Excel, CSV, Text…they’ll work without any code design change). I want to be able to lookup the very first […]
Extracting phone numbers from any document/file
Imagine you have documents of various types: email, Word documents, PDF, text, HTML, Excel, etc. And you want to extract phone numbers, and phone numbers only from those documents as you try to build a list of contact information or a database. In this post, I show a quick and effective way to do just […]
Using Python, SQL, and Excel together for data shaping & analysis
There are times when I’d like to take a peek at my data CSV or XLS/X even before firing up Excel. Usually when the dataset is large and I want to quickly inspect it and modify it for my needs before even putting Excel to work. For that purpose, Python is very useful. Add its […]
“God” game—revisited (aka Pop game)
What seems like yonks ago, I wrote a fun, DOS based visual game in college that’s a simple simulation of population growth with some user-inputs to the game (i.e. playing “God”, hence the title). You can read about it here. But here, I’m sharing info about that game, revisited, with a different twist. I rewrote […]
Data extraction with multiple criteria with interactive UI
Imagine we are business owners who provide a range of services. We have a large set of customer data but we really want to target those customers who might be interested in your services. We want to extract only that subset of data based on our services. And since we provide multiple, diverse services the […]
Simple and accurate credit payoff calculator
This is built in Excel that shows how long it’ll take you to pay off a loan at a given interest, and also how much in total you’ll end up paying over the period until the loan is completely paid off. Additionally, you can simple visuals. To enter the required loan information as shown in […]
A GUI World Weather App (Python)
This is another version (improved with GUI and better error handling) of a weather app in Python that shows weather and related information of any city in the world. This uses tkinter library for GUI and its grid system for precise layout. The Web Service We’ll use openweathermap.org’s web service, which is free. It requires […]
Air-quality GUI Application Using Webservices (Python)
This is a complete GUI application in Python to retrieve air quality information based on a zipcode (within USA). It utilizes the following concepts: Using tkinter library for GUI Calling a webservice Parsing JSON payload Formatting date and UI controls (input box, button, label, will dynamic updates) How to name your application title, attaching your […]