By test , did you mean running them from notebooks ( as against an IDE ) or, unit testing from notebooks.

If it is the first, checkout example notebooks. If it is the latter you could abstract out transformations into separate functions ( that accepts a dataframe and returns a dataframe) and have them unit tested using standard unit testing practices.