Often I find myself working with a subset of the full dataset for experimentation, trials, and exemplification. For instance, my dataset may have 33,000 records but I want to work with about 100 records first in a separate sheet. Sure, I could (as most do) select the desired columns and continue to scroll down to […]
Tag: coding
GOTO conference in Amsterdam: Agile
Although the message was delivered about the misinterpretations of Agile back in 2015, few heeded. Or perhaps few could hold back the ocean of this profitable industry with a broom while the proponents pushed a new framework as a methodology to the panicky companies entering the hashtag#programmanagement hashtag#agile 21st century. This clip is of Pragmatic […]
A basic spin-slot game in…Excel??
With Excel’s toolbox of thousands of formulas and VBA support, it’s not out of question to be able to create games although it’s not designed for that purpose. However, not for the sake of playing, rather for experimentation and learning, I decided to present a simple form of a spin game. Game Rules Have 2 […]
Random Fun with Excel
This is a seemingly useless but visually fun usage of visuals, combined with Excel functions and VBA I did to take a break from my typical gnarly Excel analytics work 🙂 How it works: 1. Fill in a formula to generate random numbers between 1 and 100 (inclusive) across the cell range. 2. Apply 2 […]
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 […]
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 […]
Sample Size (Contd.)
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 In this blog, we’ll use actual numbers to determine […]
Sample Size and Margin of Errors. Everything you need to know and ++
I’m not a statistician by profession or training. However, I find it fascinating with even the basics under my belt and find plethora of statistic’s practical usage. Without it, we’re really ignorant. With it, we’re equipped but not always best educated either. I heard the phrase again and again, “Correlation does not equal causation!” and […]
Running code from within another code (Python)
Most of us who have done any programming know that virtually all languages allow you to execute another program from within a program. For example, you start your program, which may start another process (via calling Execute or the like) that’s a self-contained program by itself, resulting in another process or spawn another thread as […]
The 3n+1 Problem & More! (Part 2)
This is a continuation (part 2) of my blog titled The 3n+1 Problem & More! I recommend you read that first to get the context, or it’ll be really boring or at least confusing 🙂 In the previous blog we generated a sequence of numbers starting from ANY number and converging to 1…always! I also […]