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.
Checking the data info - SQL Tutorial
From the course: Complete Guide to AI and Data Science for SQL Developers: From Beginner to Advanced
Checking the data info
- [Instructor] What's up, data explorers? In your last step, you open your treasure chest of data. Now, let's shine a light on what's inside. Imagine your data set is like a book. And in this step, you're going to read the table of contents, basically getting to know what's in it. How do you do that in Python? With a simple command. You see this code, df.info. It's like asking the book for its table of contents. When you run this code, you get a bunch of information about your dataset. It's like reading the back cover of a book. You get a sneak peek of what's inside. Here are some key observations from this step. First, there are a total of 506 non null observations in each of the columns. This means, there are no missing values in the data. It's like having a complete puzzle with no missing pieces. Second, there are 13 columns in the dataset, and every single one of them is of numeric data type. So in a nutshell, your…
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)
-
-
-
-
-
-