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 […]
Tag: education
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 […]
Text to Morse: codes and sound generation (Python)
In this blog, I’ll discuss how to create a fully functional program that takes user inputs as letters, numbers, and symbols and turns them into International Morse codes, and also play the actual sound of the codes as transmitted at 550Hz (20WMP speed). This program is written in Python and while I’m not a Morse […]
“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 […]
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, […]
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 […]
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 […]