On this page

DataFrame#

Download this notebook from GitHub (right-click to download).

import pandas as pd
import panel as pn

pn.extension()

The DataFrame pane renders pandas, dask and streamz DataFrame and Series types as an HTML table. If you need to edit the values of a DataFrame use the DataFrame widget instead. The Pane supports all the arguments to the DataFrame.to_html function.

Parameters:#

For layout and styling related parameters see the customization user guide.

  • bold_rows (boolean, default=True): Make the row labels bold in the output.

  • border (int, default=0): Width of the border included in the opening table tag.

  • classes (list[str]): CSS class(es) to apply to the resulting html table.

  • col_space (int or str): The minimum width of each column in CSS length units. An int is assumed to be px units.

  • decimal (str, default=’.’): Character recognized as decimal separator, e.g. ‘,’ in Europe.

  • escape (boolean, default=True): Convert the characters <, >, and & to HTML-safe sequences.

  • float_format (function): Formatter function to apply to columns’ elements if they are floats. The result of this function must be a unicode string.

  • formatters (dict or list): Formatter functions to apply to columns’ elements by position or name. The result of each function must be a unicode string.

  • object (object): The HoloViews object being displayed

  • header (boolean, default=True): Whether to print column labels.

  • index (boolean, default=True): Whether to print index (row) labels.

  • index_names (boolean, default=True): Whether to print the names of the indexes.

  • justify (str): How to justify the column labels (‘left’, ‘right’, ‘center’, ‘justify’, ‘justify-all’, ‘start’, ‘end’, ‘inherit’, ‘match-parent’, ‘initial’, ‘unset’)

  • max_rows (int): Maximum number of rows to display.

  • max_cols (int): Maximum number of columns to display.

  • na_rep (str, default=’NaN’): String representation of NAN to use.

  • render_links (boolean, default=False): Convert URLs to HTML links.

  • show_dimensions (boolean, default=False): Display DataFrame dimensions (number of rows by number of columns).

  • sparsify (boolean, default=True): Set to False for a DataFrame with a hierarchical index to print every multi-index key at each row.

The DataFrame uses the inbuilt HTML repr to render the underlying DataFrame:

df = pd._testing.makeMixedDataFrame()

df_pane = pn.pane.DataFrame(df, width=400)

df_pane

Like all other Panel objects changing a parameter will update the view allowing us to control the styling of the dataframe. In this example we will control these parameters using a set of widgets created directly from Pane:

pn.panel(df_pane.param, parameters=['bold_rows', 'index', 'header', 'max_rows', 'show_dimensions'],
         widgets={'max_rows': {'start': 1, 'end': len(df), 'value': len(df)}})

By setting escape to True you can include HTML markup in your Dataframe pane

links = pd.DataFrame({
    "site": ["Docs", "Discourse", "Github", "Twitter"], 
    "url": ["https://panel.holoviz.org/", "https://discourse.holoviz.org/", "https://github.com/holoviz/panel", "https://twitter.com/Panel_org"]
})
links["value"]="<a href='" + links["url"] + "' target='_blank'>" + links["site"] + "</a>"
pn.pane.DataFrame(links, escape=False, width=800, index=False)

In addition to rendering standard pandas DataFrame and Series types the DataFrame pane will also render updating streamz types (Note: in a live kernel you should see the dataframe update every 0.5 seconds):

from streamz.dataframe import Random

sdf = Random(interval='200ms', freq='50ms')

pn.pane.DataFrame(sdf, width=500)

type(sdf.groupby('y').sum().x)

streamz.dataframe.core.Seriess
This web page was generated from a Jupyter notebook and not all interactivity will work on this website. Right click to download and run locally for full Python-backed interactivity.

Download this notebook from GitHub (right-click to download).