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 […]
Category: STEM
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 […]
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 […]
Analyzing NFL Quarterbacks Stats
Data Science in sports is a huge deal! Even though most professional sports teams have been using them as a core part of their strategy, it was relatively recently that it got much more attention in the NFL…as soon as Seahawks dedicated a team to analytics! As they blew out records in virtually all positions […]
Peek into Infographics
From newspapers and magazines, online and offline, Infographic is the rage. They convey numbers in an attractive, easy to understand visuals for most people. There are everywhere! In this blog, I’ll offer some practical advice, tips, and resources. First, the caveats… While Infographic can be a lot of fun to make, avoid these pitfalls and […]
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 […]