From the course: Complete Guide to AI and Data Science for SQL: From Beginner to Advanced
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Loading the data - SQL Tutorial
From the course: Complete Guide to AI and Data Science for SQL: From Beginner to Advanced
Loading the data
- [Instructor] All right, in your last step, you got your Python libraries loaded. Now, it's time to dive right into the data. If you plan on running the code for this step, you'll need the course dataset .csv file that you downloaded earlier from the exercise files area of the course. To work with your data, you need to load it into Python. Think of this step as opening a treasure chest full of information. In this code snippet, you're doing just that, opening your dataset. See this line of code? It's like telling your computer where to find the treasure chest, your dataset stored in a CSV file and how to open it. Once you've done that, it's like looking inside the chest and saying, "What's in here?" This is where we see the first few rows of your dataset. It's like peeking into the treasure chest and finding some sparkling gems. Each row is like a gem filled with information about houses in the neighborhood, and…
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)
-
-
-
-
-
-