The scenario: You have a dataset with values in one column that’s unique (or semi-unique) and another column with its associated values as Key:Value pairs but that column has repeating values. Imagine a list of members whose names are in one column and their corresponding membership status next to it as below: What we […]
Blog
How many real days…net? (Excel)
This is one of the simple and yet powerful tips when working with Dates in Excel. To calculate the number of workdays between two dates BUT EXCLUDING weekends (depending on your locale settings), we can use NETWORKDAYS(). In US and most western countries, Saturdays and Sundays would be excluded from the calculation. Without changing your […]
Defending base against Hammerman’s 4th attack
This is a short game play recording of me defending against Hammerman’s 4th wave of attack and losing. The game is Boom Beach, and it’s the only phone game that I played this long, and have actually made in-game purchases for more than once…yet, it has no ads. The game is very refined, simple, yet […]
Defending base against Hammerman’s 3rd attack
This is a short game play recording of me defending against Hammerman’s 3rd wave of attack and winning. The game is Boom Beach, and it’s the only phone game that I played this long, and have actually made in-game purchases for more than once…yet, it has no ads. The game is very refined, simple, yet […]
Phone number formatting tips (Excel and Python)
For most people working with data for a significant amount of time, formatting raw data from different sources are both a reality and a pain. Today, I show different ways to format an un-formatted string that contains phone numbers using Python, and Excel. Our task is to format it (either for human-reporting, or consumption by […]
Searching online (Google) with Python
In this blog, I demonstrate how to run a Google query from a Python app extremely easily. The harder part is just the set up and knowing what to install. So, let’s start with the set up details: You’ll need to install the following packages IN ORDER: 1) beautifulsoup4 2) google NOTE: The package to […]
Most brilliant people to know in the computing world
Here’s a list of some legendary programmers/tech-minds of the computing industry to-date. More brilliant minds will surface I’m sure, but if you know these names, you covered most of the critical people. Of these great people, I’ve had the pleasure to meet in person Bill Gates and Sir Tim Berners-Lee during my tenure at Microsoft. […]
Beating Dr. T at his highest level
This is a game play recording of me beating Dr. T at his highest level 60 (available for my current level 56). The game is Boom Beach, and it’s the only phone game that I played this long, and have actually made in-game purchases for more than once…yet, it has no ads. The game is […]
Can you solve this? Pattern matching
Every now and then, when my brain is bored, I come up with quizzes (around logic and code). This one’s about logic…specifically about color and order of the colored titles. Can you solve it? For more brain teasers and puzzles, click here.
Sample Size in Python
This is part of a 3-part series on the topic. Please read the posts in the order for maximum clarity and context: 1. Sample Size and Margin of Errors. Everything you need to know and ++ 2. Sample Size (Contd.) 3. Sample size in Python (This one) Ok, after reading the first 2 posts, you […]