I have a weblink:
url = "https://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=1270&symbol=RELCAPITAL&symbol=RELCAPITAL&instrument=-&date=-&segmentLink=17&symbolCount=2&segmentLink=17"
I need to move the below table data to pandas dataframe.
You can use (create a helper browser):
import urllib.requestuser_agent = 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.7) Gecko/2009021910 Firefox/3.0.7'url = "https://www.nseindia.com/live_market/dynaContent/live_watch/option_chain/optionKeys.jsp?symbolCode=1270&symbol=RELCAPITAL&symbol=RELCAPITAL&instrument=-&date=-&segmentLink=17&symbolCount=2&segmentLink=17"
headers={'User-Agent':user_agent,} request=urllib.request.Request(url,None,headers)
response = urllib.request.urlopen(request)
data = response.read()
df=pd.read_html(data)[1]
print(df.head())
CALLS \Chart OI Chng in OI Volume IV LTP Net Chng BidQty BidPrice
0 NaN - - - - - - 37500 32.45
1 NaN - - - - - - 37500 23.90
2 NaN - - - - - - 37500 15.35
3 NaN 15000 - - - 24.00 - 37500 6.65
4 NaN 46500 - 5 10.59 4.00 -8.00 1500 4.00 ... PUTS \AskPrice ... BidPrice AskPrice AskQty Net Chng LTP IV Volume
0 52.55 ... - 1.20 3000 - - - -
1 51.75 ... - 1.20 3000 - - - -
2 40.20 ... 1.00 1.10 1500 0.60 1.10 168.46 21
3 20.25 ... 2.50 2.55 1500 0.60 2.00 150.32 47
4 5.00 ... 5.35 6.00 9000 3.30 6.10 147.49 115 Chng in OI OI Chart
0 - - NaN
1 - - NaN
2 -10500 135000 NaN
3 -22500 192000 NaN
4 -34500 292500 NaN [5 rows x 23 columns]