How to read a html page with Pandas Using Python

0 min readDataFramePandasHTMLWebscraping
7-Day Challenge

Land Your First Data Science Job

A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.

Build portfolios that hiring managers love
Master the Python and SQL essentials to be industry-ready
Practice with real interview questions from tech companies
Access to the $100k/y Data Scientist Cheatsheet

Join thousands of developers who transformed their careers through our challenge. Unsubscribe anytime.

Here is how to read a pandas DataFrame from an HTML page using the pandas.read_html() method.

Here is the code

How to read data

Here we read a wikipedia web page in HTML in a DataFrame format.

The pandas.read_html() method will return a list of DataFrames it found on the page. Here we take the 6th DataFrame so to say at index 5.

# We import the pandas library for the dataframes
import pandas as pd

# We import the table in html
df = pd.read_html("https://en.wikipedia.org/wiki/National_Basketball_Association")[5]

# We print the dataframe
print(df)

We have now the list of NBA championship in a DataFrame format.

Here you are! You now know how to read a HTML web page with Pandas.

7-Day Challenge

Land Your First Data Science Job

A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.

Build portfolios that hiring managers love
Master the Python and SQL essentials to be industry-ready
Practice with real interview questions from tech companies
Access to the $100k/y Data Scientist Cheatsheet

Join thousands of developers who transformed their careers through our challenge. Unsubscribe anytime.

Free Newsletter

Master Data Science in Days, Not Months 🚀

Skip the theoretical rabbit holes. Get practical data science skills delivered in bite-sized lessons – Approach used by real data scientist. Not bookworms. 📚

Weekly simple and practical lessons
Access to ready to use code examples
Skip the math, focus on results
Learn while drinking your coffee

By subscribing, you agree to receive our newsletter. You can unsubscribe at any time.