Scrapping search results to csv based on search value


Dear All,

Could you please help me out I am trying to fetch search results into csv file using web scraping,

Scenario for my Use case:

1)Reading CSV (which contains various Company Name)
2)Searching the result on website
3) Web scraping for search results
4) Writing into CSV.

In this scenario I am getting only the data for First value present in CSV file.
Can we do web scrapping for tables based on search input value?

Web scraping & export to CSV

I tried it using append csv instead of write csv it works