I have the following operation to add a status showing where any string in a column of one dataframe column is present in a specified column of another dataframe. It looks like this:
df_one['Status'] = np.where(df_one.A.isin(df_two.A), 'Matched','Unmatched')
This won't match if the string case is different. Is it possible to perform this operation while being case insensitive?
Also, is it possible return 'Matched' when a value in df_one.A ends with the full string from df_two.A? e.g. df_one.A abcdefghijkl -> df_two.A ijkl = 'Matched'