Data Scrapping Use Case

Hi,
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.

Hi @vishal.jyoti_cs15
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?

Yes.
I want to compare the prices of those products which are common in both the websites.

@vishal.jyoti_cs15
Hey,
Please have a look at this video.


This might solve your query.

Regards,
Krishna

Hi @vishal.jyoti_cs15

May i know what all fields you want to extract for the product from both the websites ?

For eg Name, Price, ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

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