df1 = df1.set_index('column_in_df1') df1 = df1.reindex(index=df2['column_in_df2']) df1 = df1.reset_index()