how to add a column in dataframe from another dataframe based on another column value code example
Example 1: add column to df from another df
feature_file_df['RESULT'] = RESULT_df['RESULT'].values
feature_file_df['RESULT'] = RESULT_df['RESULT'].to_numpy()
Example 2: Adding a new column in pandas dataframe from another dataframe with different index
merge(left, right, how='left', on=None, left_on=None, right_on=None,
left_index=False, right_index=False, sort=True,
suffixes=('_x', '_y'), copy=True)