I’m scrapping data from one website after searching for a particular product, but I need to check if the data found is correct wrt my conditions.
This is the data after scrap.
When the term “Lays” is searched, above result is obtained.
- The term “Lays” if “Preferred” should return “Available”.
- The term “Lays” if “Non-Preferred” should return “Not Available”.
- If above both conditions are satisfied, then it should return “Both”.
The returned data should be appended to the following excel file (in column F)
Thanks in advance…