From the course: Complete Guide to AI and Data Science for SQL Developers: From Beginner to Advanced
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Applying log transformation and re-checking distribution - SQL Tutorial
From the course: Complete Guide to AI and Data Science for SQL Developers: From Beginner to Advanced
Applying log transformation and re-checking distribution
- [Instructor] What's up, what's up? And welcome back. Now that you've visualized and observed the distribution of your data in the last step, in this step, you'll be applying a log transformation to one of your variables. But why are we doing this and what does it even mean? Let's dive right in. First, let's talk about log transformation. A log transformation is like a tool that helps you make your data more balanced and easy to understand. When you apply a log transformation, you're essentially taking the logarithm of a number. It's a bit like using a magnifying glass to see small details. Imagine you have a range of numbers, some small and some large. Log transformation squishes the large ones down a bit and stretches out the small ones. So they're all close together. It's like leveling a bumpy road. Now, let's see why we're doing this. It's because of something called skewness. If you recall, skewness is like a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
(Locked)
Importing necessary libraries and dataset overview3m 18s
-
(Locked)
Loading the data7m 36s
-
(Locked)
Checking the data info2m 13s
-
(Locked)
Summary statistics of the dataset5m 49s
-
(Locked)
Checking the distribution of the variables5m 42s
-
(Locked)
Applying log transformation and re-checking distribution3m 6s
-
(Locked)
Challenge: Preparation1m 5s
-
(Locked)
Solution: Preparation1m 19s
-
(Locked)
-
-
-
-
-
-