Sunday, January 29, 2023

## Decision Tree and Prediction (Python)

This is an example of a Decision Tree model (very useful and popular method) to make prediction using the power of Machine Learning…using just a normal PC. Here we predict salary (depedendent variable) by giving various types of criteria (different forks in a decision tree). e.g. What’s the salary of a particular gender, of some […]

## Wanna be a weather reporter? Me neither! So let’s do Machine Learning (AI)! Part 2/2

This is a continuation of weather prediction via ML and is the final part (2/2) where I demonstrate how to write Python code to leverage a neural network algorithm called Neural Prophet, a quite straight-forward and useful model. Be sure to read the first part that focuses on understanding the data in Excel and some […]

## Wanna be a weather reporter? Me neither! So let’s do Machine Learning (AI)! Part 1/2

Reporting weather by reading off the predictions is obviously a very different skill than creating the code and models that actually predicts the weather! Not just forecasting for the next 5 days, but actually PREDICTING for any number of period in the future! Is that even possible? Yes, it is albeit there are myriad of […]

## Logistic Regression Example (Excel, Python)

In my previous blog on Sigmoid function, I touched on its usefulness and how it’s used to solve Logistic Regression problems either in binary or multiclass classification scenarios. Be sure to check that out http://flyingsalmon.net/?p=3879 first! In this blog, we’ll be using a dataset containing people’s ages and whether or not they bought life insurance […]

## What is Sigmoid function and why?

In this blog, I touch on a core function that’s used in many machine learning scenarios whether explicitly or as a part solving a given problem. This is extremely useful for recoding values for classification (binary or multiclass) where we need to map some categorical values into a finite range of values (e.g. 0 or […]

## Machine Learning in Python (Univariate Linear Regression)

In this post, I share a method to utilize Machine Learning using Python. I have collected some data from CDC site about birth rate in the USA over several years. What I’d like to show you is how we can predict birth rate for a year that is NOT present in the dataset. For example, […]

## Make a computer guess your word – Python

You’ve undoutedly played games like hangman or seen TV games such as Wheel of Fortune where you’re supposed to guess a word by only given the number of letters (or their placeholders, blank tiles) in a given number of tries. You may have also written similar games yourself. In this post however, I’m going to […]

## Words to numbers challenge – Python

In this blog I share techniques on how to convert a dataset containing words into actual numbers (integer or float) save the output with numbers to an external CSV/XLSX data file. If you’re wondering why would one ever need this? Here’s a scenario: A list of movies and their corresponding revenues were read into a […]

## Eiesenhower Matrix in Excel (Quadrant Matrix)

Former US President Eisenhower is known to have said: “What is important is seldom urgent and what is urgent is seldom important.” This is reflected in a popular quadrant design, often referred to as “The Eisenhower Matrix”, used to effectively prioritize tasks according to their urgency and importance. This can be expressed in a quadrant matrix (image) […]

## HOW TO CREATE AN ORGANIZATIONAL CHART FROM EXCEL DATA

If you’ve worked with Visio or PowerPoint, you may have used their built-in organizational charts…and manually enter the information for each node. But what if you have the data already as a table, as in a CSV or Excel file? You can use that data and create an organizaitonal chart right within Excel. However, you’ll […]

Back To Top