This is a task for Merge command - you define condition for merge (your unique column) and then actions.

MERGE INTO target
USING  src
ON target.column = source.column
WHEN MATCHED THEN
  UPDATE SET *
WHEN NOT MATCHED
  THEN INSERT *

could be your dataframe registered as temporary view):