Mastering pandas - Second Edition

HTML

HTML is the popular file format for creating and wrapping web elements and pages. Sometimes, tabular data is stored in a file. In such cases, the read_html method is directly used to read such data. This function parses table elements from HTML files and reads the tables as DataFrames:

pd.read_html('http://www.fdic.gov/bank/individual/failed/banklist.html') 

You can find all of the table elements containing a particular match word by using the following code:

 match = 'Malta National Bank' 
df_list = pd.read_html('http://www.fdic.gov/bank/individual/failed/banklist.html', match=match) 

A DataFrame can be converted into an HTML table element so that it can be placed into an HTML file like so:

data=pd.read_csv('http://bit.ly/2cLzoxH')