I need a prompt that compares 2 sheets- and lists out the data in the 2nd sheet that are mentioned in the 1st sheet either in the exact same words or in the same context/meaning. With GPT-4 Advanced Data Analysis plugin, I was able to create a prompt that detects exact matches. But the AI couldn’t detect contextual matches.
AI added- “I’ll proceed by using fuzzy string matching to identify those attributes where exact or substring matches were not found. This step will allow us to capture the attributes that are similar in context but not exactly the same as the attribute names. The additional fuzzy string matching step is complete, and the results have been added to the DataFrame in a new column.”
But the final file had only the data that were an exact match and no contextual matches. Does this mean GPT-4 cannot detect/list contextual match data?
Can GPT-4 compare and list out contextual match data from 2 datasets?
Kindly help me to create a prompt that can detect and list contextual match data from 2 datasets.