How can i merge two datasets with similar words in python?
For instance i have a row value on the dataset_1 : Entity = Apple
dataset_2 : Entity = iCloud Apple
(Entity is the column) I need to merge one dataset to the other by the column entity, but to do that i need them to have exacly the same value and Apple ≠ iCloud Apple.
Both datasets are huge so i cant do this manually, one by one