Active Hackathon

Hands-On Guide to Datapane Python Tool for Reporting and Visualization

Datapane is an open-source python library/framework which makes it easy to turn scripts and notebooks into interactive reports.
Datapane Reports

Creating reports using python is an easy task because we can use different python libraries and combine our exploration of the data with some meaningful insights. But sharing this report is not that easy because not everyone or your client is used to python so that he can open your jupyter notebook and understand what you are trying to tell.

Datapane is an open-source python library/framework which makes it easy to turn scripts and notebooks into interactive reports. We can share these reports with our viewers or clients so that they can easily understand what the data is trying to tell.


Sign up for your weekly dose of what's up in emerging technology.

Datapane allows you to systematically create reports from the objects in your Python notebook, such as pandas DataFrames, plots from visualization libraries, and Markdown text. We can also choose to publish our datapane reports online by selecting the desired audience.

In this article, we will explore how we can create a data report using Datapane and publish it to an HTML file. 


Like any other library, we will install datapane using pip install datapane.

  1. Importing Required Libraries

We will be loading our dataset using pandas so we need to import pandas and for creating the report we will import datapane.

import pandas as pd

import datapane as dp

  1. Loading the required Dataset

We will load an advertisement dataset that contains different attributes like ‘Sales’, ‘TV’ etc of an MNC. We will use this data to create a report of the data.

df = pd.read_csv(‘Advertisement’.csv’)


Dataset Used
  1. Creating Visualizations for report

We need to create the required visualizations in the jupyter notebook so that we can pass it to the datapane reports for visualizing. Here we will create a histogram, box plots, and Regression plots.


histogram = df.hist()


boxplot = df.boxplot(column=['TV', 'Radio', 'Newspaper'])

#Regression Plots

import seaborn as sns

scat1 = sns.regplot(x="Sales", y="TV", data=df)

scat2 = sns.regplot(x="Sales", y="Radio", data=df)

scat1 = sns.regplot(x="Sales", y="Newspaper", data=df)

We have created these plots and stored them in a variable so that we can call them in our report for visualization.

  1. Creating the report 

The next step is to create a report, we will use markdowns so that we can clearly define different sections of our report.

report = dp.Report(

    dp.Markdown("Advertisement Report With Sales Data"),


    dp.Markdown("Histogram Of all Attributes"),


    dp.Markdown("Box Plot of the Feature Variable"),


    dp.Markdown('Regression Plots for all features against target variable'),





Here we have created the report with importing all the plots we have created and the dataframe as a table. Next, we will publish this report to an Html file.

  1. Publishing Report

The final step is to publish the report we created so that we can share the reports with respective clients/users.'adver_data.html')

Now let us open the report we have created and see how it looks. The report would be downloaded in your system where your python setup is installed, go to the directory, and open the file.

Data in Tabular form

This is the main page of our report, you can see here that the data is represented in the form of a table and you can search for different values in the particular column. Also, we can arrange the data in ascending or descending order. Let’s look at the visualization we created and how they look in our report.

regression plots

Here, we can see in the report that the data and the visualization along with the markdowns create a highly informative report which can be shared with the respective person.

Similarly, we can use different datasets to create different types of reports and visualization and publish them into shareable Html reports.


In this article, we saw how we can create a report with a dataset and visualize different types of charts and graphs in it. We saw how we can publish these reports in an offer to make it a shareable report in HTML format. Datapane is easy to use and open-source due to which it is highly recommended for creating shareable data reports.

More Great AIM Stories

Himanshu Sharma
An aspiring Data Scientist currently Pursuing MBA in Applied Data Science, with an Interest in the financial markets. I have experience in Data Analytics, Data Visualization, Machine Learning, Creating Dashboards and Writing articles related to Data Science.

Our Upcoming Events

Conference, Virtual
Genpact Analytics Career Day
3rd Sep

Conference, in-person (Bangalore)
Cypher 2022
21-23rd Sep

Conference, in-person (Bangalore)
Machine Learning Developers Summit (MLDS) 2023
19-20th Jan

Conference, in-person (Bangalore)
Data Engineering Summit (DES) 2023
21st Apr, 2023

3 Ways to Join our Community

Discord Server

Stay Connected with a larger ecosystem of data science and ML Professionals

Telegram Channel

Discover special offers, top stories, upcoming events, and more.

Subscribe to our newsletter

Get the latest updates from AIM
How Data Science Can Help Overcome The Global Chip Shortage

China-Taiwan standoff might increase Global chip shortage

After Nancy Pelosi’s visit to Taiwan, Chinese aircraft are violating Taiwan’s airspace. The escalation made TSMC’s chairman go public and threaten the world with consequences. Can this move by China fuel a global chip shortage?

Another bill bites the dust

The Bill had faced heavy criticism from different stakeholders -citizens, tech firms, political parties since its inception

So long, Spotify

‘TikTok Music’ is set to take over the online streaming space, but there exists an app that has silently established itself in the Indian market.