I often get questions such as: “How do I export Google business data into a database?” or “How do I import Google locations data into an Excel sheet?” They’re both pointing to the same need. The scenario is that we can search on Google Maps or Bing Maps or just on any online Search engine […]
Tag: STEM
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 […]
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 […]
Working with clipboard, dataframe, and data files
In this blog, I’ll share tips on: How to read data into a dataframe, create a subset of dataset in memory Read/write curated subset from/to clipboard as Text/CSV or XLSX Create new data files CSV/Excel The Scenario I have a large dataset. Checking its shape via Python, I see it has 18241 records with 9 […]
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 […]
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 […]