1. Learn
    2. /
  2. Courses
    3. /
  3. ETL in Python

Exercise

Delete operation

After inserting new rows from the raw table to the clean table, you need to remove rows that are in the clean table but no longer in the raw one.

The session, PprRawAll and PprCleanAll classes are already initialized and ready to use.

Instructions

100 XP
  • Get the list of all transactions from the ppr_raw_all table.
  • Query the clean table, and filter out the rows that are in the clean table but not in the list of of raw transactions you just created.
  • Delete these rows.