Forum Discussion
Extraction of data from Website
Hi all, I am trying to extract data from a website ( https://csr.gov.in/content/csr/global/master/home/home/csr-expenditure--geographical-distribution/state/district/companies.html?=Bangalore%20Urba...
Trying to download the list of companies and their expenditure
S.No Company Name(s) Amount (INR Cr.)
1 Sbi Cards And Payment Services Limited
8.87
2 Biocon Limited
6.46
3 Biocon Biologics Limited
3.1
S.No Company Name(s) Amount (INR Cr.)
1 Sbi Cards And Payment Services Limited
8.87
2 Biocon Limited
6.46
3 Biocon Biologics Limited
3.1
Like I mentioned there is a long delay before the page will show the data (~15sec) and if you go to the 'Explore CSR Data' tab each of those reports request a captcha. i suspect they are intentionally doing this to prevent automated data mining and you will need to download individual reports or contact them to see if there is another option.
mtarler Thank you. But, I am not trying to get the detailed report as they show in 'Explore CSR Data'
I want the table visible in the link i had posted, which is just 3 columns - Sl no., the Company name and the CSR expenditure
- I realize that but what I was indicating is that it appears they might be intentionally introducing that long delay to thwart automated queries of the data.