df3['color'][df3['fruit_name'].isin(df1['fruit_name'])] = 'yellow'
df3['color'][df3['fruit_name'].isin(df2['fruit_name'])] = 'red'
df3
Trying to create a pandas series within a dataframe with values based on whether or not keys are in another dataframe