I want to create a python function for this query below.
I have 2 different excel files- File 1 and file 2. I want to check if file1 column 1 has words which are in file 2 column1. If yes get those rows.
file1
file2
The end result should be
File 1 rows:
Apple Electronics
motorola limited
phone ltd
oneplus company
New contributor
Bansal is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1