1. Learn
  2. /
  3. Courses
  4. /
  5. ETL and ELT in Python

Connected

Exercise

Extracting, Transforming, and Loading Student Scores Data

Alright, it's time to build your own ETL pipeline from scratch. In this exercise, you'll build three functions; extract(), transform(), and load(). Then, you'll use these functions to run your pipeline.

The pandas library has been imported as pd. Enjoy!

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • In the extract() function, use the appropriate pandas function to read a CSV into memory.