This document outlines scraping tabular data in to Python in the Pandas format from any URL.
In this case, a website outlines chemicals, its formulae and common name in a table on the website is used to create a dictionary of chemicals and corresponding chemical formula.
https://srome.github.io/Parsing-HTML-Tables-in-Python-with-BeautifulSoup-and-pandas/