Forum Discussion

Hemanth_R's avatar
Hemanth_R
Copper Contributor
Sep 15, 2022

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...
excel
Excel for web
mtarler's avatar
mtarler
Silver Contributor
Sep 16, 2022
that website seems to take a very long time to load the data. what exactly are you trying to do?
  • Hemanth_R's avatar
    Hemanth_R
    Copper Contributor
    Sep 20, 2022
    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
    • mtarler's avatar
      mtarler
      Silver Contributor
      Sep 20, 2022
      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.
      • Hemanth_R's avatar
        Hemanth_R
        Copper Contributor
        Sep 20, 2022

        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

Resources