I want to scrap data from Flipkart and amazon website into two separate excel files i.e., one for Flipkart data and the other for amazon data.
And then I have to do a comparison i.e., the entries which are common in both the above excel files to be written to a new excel file.
I need the workflow to be a Generic Solution i.e., that comparison works irrespective of their names from the above two excel files.
Which data you want scrape data from Flipkart or amazon? Like i want to search one company product in both e-commerce sites and compare the prices… am I right?
I want to compare the prices of those products which are common in both the websites.
Please have a look at this video.
This might solve your query.
May i know what all fields you want to extract for the product from both the websites ?
For eg Name, Price, ??
Er Pratik Wavhal
Product Name and Price
The issue is that while doing comparison the product name from the two websites are in different formats.
e.g: Flipkart Product Name : Apple iPhone 11 (Black, 64 GB)
Amazon Product Name : Apple iPhone 11 (64GB) - Black