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,900 courses taught by industry experts.
Challenge: Preparation - SQL Tutorial
From the course: Complete Guide to AI and Data Science for SQL: From Beginner to Advanced
Challenge: Preparation
(calm music) - [Instructor] So here's the scenario. You're a data scientist about to perform the initial steps of your data preparation and exploration on a dataset of student score data. Assume that you're working with Python software and here's your challenge. Arrange the data analysis steps in the order in which they should typically be performed. The titles of the steps are as follows, checking the distribution of the variables, applying log transformation, and rechecking the distribution, checking the data information, loading the data, importing the necessary libraries and dataset overview and the summary statistics of the dataset. Take about five minutes for this challenge. Pause the video if needed. Once you formulated your answer, hit the play button to see the solution in the next video.
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)
-
-
-
-
-
-