从NSE下载csv文件

Question

我想从https://www1.nseindia.com/products/content/derivatives/equities/historical_fo.htm下载csv文件。

投入:不同的选择。输出:自动下载csv文件

无法获得由csv文件生成的链接，并试图使用python下载红色高亮显示的csv文件。

​

​

   import requests
import pandas as pd

query = {  # just mimicking sample query that I saw after loading link
'instrumentType': 'OPTSTK',
'symbol': 'SBIN',
'expiryDate':'26-12-2019', #'select',
'optionType': 'CE',
'strikePrice': '',
'dateRange': '',
'fromDate': '02-12-2019',
'toDate': '25-12-2019',
'segmentLink': '9',
'symbolCount': '',
}

headers = {
    'Pragma': 'no-cache',
    'Accept-Encoding': 'gzip, deflate, br',
    'Accept-Language': 'en-US,en;q=0.9',
    'User-Agent': 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36',
    'Accept': '*/*',
    'Referer': 'https://www.nseindia.com/products/content/derivatives/equities/historical_fo.htm',
    'X-Requested-With': 'XMLHttpRequest',
    'Connection': 'keep-alive',
    'Cache-Control': 'no-cache',
}



url = 'https://www.nseindia.com/products/dynaContent/common/productsSymbolMapping.jsp?\
instrumentType=%s\
&symbol=%s\
&expiryDate=%s\
&optionType=%s\
&strikePrice=%s\
&dateRange=%s\
&fromDate=%s\
&toDate=%s\
&segmentLink=%s\
&symbolCount=%s' %(query['instrumentType'],
  query['symbol'],
  query['expiryDate'],
  query['optionType'],
  query['strikePrice'],
  query['dateRange'],
  query['fromDate'],
  query['toDate'],
  query['segmentLink'],
  query['symbolCount']
  )

response = requests.get(url,headers=headers)

现在打印url并在浏览器中粘贴.我得到的数据非常少。

Answer 1

若要重播单击并下载数据，必须使用Selenium或类似的包。