Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.
There are many cases where you have to convert your Pandas dataframe into an HTML table. Two of the primary reasons are that you want to better view your dataset as a data analyst or integrate it into your organization's website.
In this tutorial, we will convert any Pandas dataframe into an interactive table with pagination, and we can perform sorting by column and searching.
To get started, of course, you have to have Pandas installed:
$ pip install pandas
Importing the necessary libraries:
import pandas as pd import webbrowser
We'll be using webbrowser module to automatically open the resulting HTML table in a new tab on the default browser.
Let's make a function that accepts the dataframe as an argument and returns the HTML content for that:
Luckily, Pandas has a built-in
to_html() method that generates the HTML content of that dataframe as a
table tag. After that, we make a complete HTML page and add a jQuery data tables extension, so it's interactive.
By default, pagination, sorting by column, and searching are enabled; you can disable them if you want. For example, if you wish to disable pagination and show the entire dataframe, you can uncomment
"//" and not
"#" as in Python).
I'm grabbing this dataset for demonstration purposes. Let's try it out:
if __name__ == "__main__": # read the dataframe dataset df = pd.read_csv("Churn_Modelling.csv") # take only first 1000, otherwise it'll generate a large html file df = df.iloc[:1000] # generate the HTML from the dataframe html = generate_html(df) # write the HTML content to an HTML file open("index.html", "w").write(html) # open the new HTML file with the default browser webbrowser.open("index.html")
After we get our HTML content, we write it into a new
index.html file and open it with
webbrowser.open() function. Here's what it looks like:
The cool thing is that we can search on the table:
Or sort by a specific column:
Or edit the pagination settings, for example showing 50 entries per page:
You can also see the pages below the table:
Alright! That's it for the tutorial. I hope it's helpful for you to easily better view your dataset or integrate it as HTML content on your website.
If you want the other way around, extracting HTML tables and converting them to CSV files, then check this tutorial.
Note that the styling of the table will only work if you have Internet connectivity. If you want it to work offline, you can simply download the JS/CSS files and put them in the current directory so it loads them from your local machine instead of from a CDN.
You can get the complete code here.
Finally, if you're a beginner and want to learn Python, I suggest you take the Python For Everybody Coursera course, in which you'll learn a lot about Python. You can also check our resources and courses page to see the Python resources I recommend on various topics!
Learn also: How to Extract Tables from PDF in Python
Happy coding ♥View Full Code