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!
This exercise is part of the course
ETL and ELT in Python
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
def extract(file_name):
# Read a CSV with a path stored using file_name into memory
return pd.____(file_name)