Thursday, October 02, 2025
Education STEM

Simple & brilliant way to extract multiple matches in one cell

  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 […]

Read More
Coding Education 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 […]

Read More
Coding Education STEM

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 […]

Read More
Coding Education STEM

“Rabid Racoon” tracking (Python, using our own class)- Part 1

Just like most high-level programming languages, Python also supports the idea of classes. Once the class(es) is/are created they can be inside the main python file or separated (in most usage scenarios), along with it methods. For Python-specific syntax, please refer to its documentation online or offline (python.org is a good start), but you should […]

Read More
Back To Top