CODE EXAMPLE FOR PYTHON

pandas add missing rows from another dataframe

pd.concat([df1, df2[~df2.isin(df1)].dropna()]).sort_values(['index','type','class']).reset_index(drop=True)