Convert HTML Table to Pandas Data Frame in Python Convert HTML Table to Pandas Data Frame in Python python-3.x python-3.x

Convert HTML Table to Pandas Data Frame in Python


You can just Use pandas read_html function for that, and remember to convert the html you get to string else you will get some parsing error.

import requestsfrom bs4 import BeautifulSoupimport pandas as pdurl = 'http://my-trade.in/'page = requests.get(url)soup = BeautifulSoup(page.content, 'html.parser')tbl = soup.find("table",{"id":"MainContent_dataGridView1"})data_frame = pd.read_html(str(tbl))[0]