MENU

Fun & Interesting

Mastering K Nearest Neighbors (KNN) Algorithm with Google Sheets, SQL, and Azure

Etietop Abraham 399 lượt xem 1 year ago
Video Not Working? Fix It Now

Join Etietop Demas Abraham, your trusted guide to the world of data science, as we demystify the K Nearest Neighbors algorithm in this detailed and engaging tutorial. As the saying goes, 'Show me your friends and I'll tell you who you are,' we dive deep into how this algorithm classifies new objects based on the traits of its surrounding neighbors.

In this comprehensive video, we'll:

1. Explain the fundamentals of the K Nearest Neighbors algorithm.
2. Illustrate the algorithm's workings using Google Sheets with a simple yet intriguing example - classifying fruits and vegetables based on their sweetness and crispness.
3. Explore different ways to calculate the distance between data points such as Euclidean Distance, Manhattan Distance, and Chebyshev Distance.
4. Show you how to implement this algorithm using SQL and Microsoft Azure, starting with a simple dataset, then escalating to a real-world problem involving the classification of car types based on horsepower, weight, and fuel efficiency.

Whether you're a student, a professional seeking to update your skills, or a curious mind eager to unravel the mysteries of machine learning algorithms, this tutorial is perfect for you. We'll take you on a journey from the fundamental concepts all the way to its application in Python, Google Sheets, SQL, and Azure.

Fasten your seat belts and join us in this exciting journey into the world of machine learning!

Timestamps:

00:02 - Introduction
00:14 - K Nearest Neighbors explained
00:35 - Applying K Nearest Neighbors on Google Sheets
01:01 - Understanding the dataset
01:30 - Classifying new data with K Nearest Neighbors
02:13 - Using different types of distances
04:27 - Understanding Euclidean Distance
04:54 - Demonstrating the implementation on Google Sheets
07:19 - How to calculate Manhattan and Chebyshev Distance
09:09 - Switching gears to SQL in Microsoft Azure
12:11 - Data transformation using SQL
15:04 - Calculating Euclidean, Manhattan and Chebyshev Distance in Azure
17:12 - Using SQL to sort by Euclidean Distance
19:02 - Classifying a new object using SQL in Azure
20:15 - Conclusion

#KNearestNeighbors #MachineLearning #Azure #Python #GoogleSheets #SQL #DataScience #Tutorial

Comment