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')
print(data.to_html())
We get the following output:
HTML table element created from a DataFrame
A selected...
