From the course: ETL in Python and SQL
Join today to access over 24,600 courses taught by industry experts.
Challenge: Transform the data and remove duplicates and nulls
From the course: ETL in Python and SQL
Challenge: Transform the data and remove duplicates and nulls
(bright music) - [Instructor] Hello, welcome to another challenge. In this challenge, we'll test what you have learned by loading your previously transformed data from Challenge 2 into the H+ Sport data warehouse. A little hint, you should create an engine just like we did. and remember to use the two SQL pandas function. If you do not remember, feel free to go back to the previous videos or check out the official pandas and SQL Alchemy documentation. Remember to name the resulting table employees. Good luck, you can do this, I'm rooting for you.
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
Contents
-
-
-
-
-
(Locked)
Introduction to data warehouses and data lakes5m 1s
-
(Locked)
Loading data into relational databases8m 1s
-
(Locked)
Data quality checks and validation with SQL3m 27s
-
(Locked)
Challenge: Transform the data and remove duplicates and nulls40s
-
(Locked)
Solution: Transform the data and remove duplicates and nulls2m 37s
-
(Locked)
-
-