A Python class for extracting tables from websites

Hello, this is Python Statistical and in today’s video we are going to look at, “A Python class for extracting tables from websites”. It is called “HTMLTableParser”. This python class has been written by Josua Schmid and is available under the AGPL license. I will include a link below to his github page. It is a great little class that pulls out html tables without too much effort at all. In this video we will be extracting a html table from the US Bureau of Labor. I will then show how to do read it into a Pandas data frame and finally export the table to an Excel spreadsheet.

In the next video, I will show how we can use Josua’s class to extract US stock prices directly from NASDAQ.

Become a Patron and support this channel:-

https://www.patreon.com/user?u=9926749


References:-

Link to Josua Schmid’s github page:-

https://github.com/schmijos/html-table-parser-python3

AGPL License:-

https://github.com/schmijos/html-table-parser-python3/blob/master/LICENSE


Documentation for urllib.request:-

https://docs.python.org/3.0/library/urllib.request.html


Pandas Link:-

http://pandas.pydata.org/talks.html

http://pandas.pydata.org/pandas-docs/stable/

Spyder 3 Link:-

https://pythonhosted.org/spyder/

US Bureau of Labor Statistics:-

https://www.bls.gov/news.release/empsit.t02.htm