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 […]
Category: Education
Combining multiple datasets into a single data file (Excel or CSV)
The Scenario I want to analyze data for New England Patriots over the past 10 seasons. The data files are downloaded as a file by year. So, for 2010 through 2019 NFL season, I have 10 separate data files. I need to combine them all into a single file so I can do an all-up […]
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 […]
Updated Story Download Page (FREE)
Here’s an updated online commerce page about Twisted Magic Tales with Emojis. Direct link to it This is a secure site from where you can download the ebook (with 7 stories, generated by Rob Deborot, the robot) for free as a PDF. When you click “I want this!” button, be sure to enter 0 (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 Horse-race Simulation with a “Strip Plot”
Strip plots, or a dot plot horizontally spread out are very useful in certain cases. I’d use it to show spread or concentration of data points across multiple categories. For example, in order to visualize between brand A, and B, what are their product sales (or prices) and where they appear to focus. What the […]
Analyzing 10 Years of Patriots Performance: NFL
Love em or hate em, New England Patriots is a team to reckon with. They’ve implemented numerous creative and suspicious internal strategies that most other teams would love to copy or at least understand. Well, I cannot expose those details as they’re not available anywhere. What is available however is their scores and stats. So, […]
Re-creating Maslow’s Hierarchy of Needs in Excel
Intro Maslow’s hierarchy of needs is a theory in psychology proposed by Abraham Maslow in his 1943 paper “A Theory of Human Motivation” in Psychological Review. You can read more about it here. You have most likely have seen many depictions of his theory as a pyramid of “needs”. A typical one looks like this: […]
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 […]
Twisted Magic Tales with Emojis – Fun, Free, Wonky!
I’ve written a story generator application that spews out stories differently every time it’s executed! I did this thinking of kids and family activities, while having nerdy fun on my end. This story generator creates a semi-random* story based on a skeleton storyline and changes the characters, objects, mood, locations, accessories and placeholders/keywords in the […]