dtale is a free, open source business intelligence & reporting project written in TypeScript and released under LGPL-2.1. It has 5,223 GitHub stars, 447 forks and 71 open issues, and was last pushed 2 months ago. On this registry it ranks #24 of 57 tracked projects in Business Intelligence & Reporting, with 5 head-to-head comparisons available.

What is dtale?

D-Tale is an open-source visualizer for pandas data structures that combines a Flask back-end with a React front-end, giving data scientists and analysts a browser interface for inspecting DataFrames, Series, MultiIndex, DatetimeIndex and RangeIndex objects.

What it is

D-Tale is a Python tool that renders pandas data structures as an interactive web page. A Flask service drives the data, a React front-end draws it, and the two together let a user view and analyze a DataFrame without writing a chain of ad-hoc pandas expressions. It integrates with IPython notebooks and with python/ipython terminals, so the visualization starts from the session where the data already lives. The registry lists it under Data & Analytics / Business Intelligence & Reporting, with the front-end written in TypeScript and released under LGPL-2.1.

The concrete problem it solves is exploratory data analysis for pandas users who would otherwise inspect frames by printing them. It descends from a SAS-to-Python conversion: what began as a Perl script wrapper around the SAS insight function became a lightweight web client layered on top of pandas. Teams moving from SAS to Python keep the interactive inspection step they were used to, and pandas users get the same step without a separate BI product or a data export.

Key capabilities

  • Browser views over DataFrame, Series, MultiIndex, DatetimeIndex and RangeIndex objects, all named as supported pandas types.
  • Chart routes driven by URL parameters, for example a chart path carrying chart_type, query, agg and cpg values.
  • Choropleth maps through map_type=choropleth with loc_mode=USA-states, loc, map_val and colorscale parameters.
  • Three-dimensional scatter and surface chart types, requested through chart_type=3d_scatter and chart_type=surface, with x, y and z axes.
  • Network analysis at the /dtale/network/ route, parameterized by to, from, group and weight.
  • Time-based animation of a map series via animate_by, as in the animated US COVID-19 deaths by state example.
  • Embedding inside IPython notebooks, python terminals and IPython terminals, plus an Open in VS Code entry point.

Who uses it and how

  • Data scientists running exploratory data analysis on pandas frames inside Jupyter notebooks, where the visualization attaches to an existing kernel session.
  • Quantitative and financial analysts, indicated by the project's origin at man-group, the Man Institute write-up, and demo data keyed on security_id.
  • Teams converting from SAS to Python who want to retain the interactive insight-style inspection step rather than rebuild it.
  • Users who need to share a chart or view as a browser link, since chart state is encoded in URL parameters such as query, agg and map settings.
  • Legacy environments, because the topic list includes both python27 and python3 alongside flask, react and react-virtualized.

Getting started

Install the dtale package from PyPI or from conda-forge, then start it against a pandas object from a Python, IPython or notebook session. A live demo is published at the project's pythonanywhere homepage.

How it compares

No list of paid products that D-Tale replaces is provided in the available facts, and the facts name no directly comparable tools. On the evidence here, it stands alone in this registry.

When to use it — and when not to

Choose D-Tale when the data is already a pandas structure and the goal is quick interactive inspection from a notebook or terminal. A self-hoster should expect to run the Flask back-end and the React front-end themselves; the facts describe no managed hosting beyond the public demo, and the README excerpt gives little detail on authentication, data-store or SMTP configuration. The LGPL-2.1 licence is a copyleft licence, which matters for teams embedding it in closed products, and the presence of an open-issue backlog and python27 support signals a project carrying legacy surface area.

project readme (upstream, from github) — read inline


CircleCI PyPI Python Versions PyPI Conda ReadTheDocs codecov Downloads Open in VS Code

What is it?

D-Tale is the combination of a Flask back-end and a React front-end to bring you an easy way to view & analyze Pandas data structures. It integrates seamlessly with ipython notebooks & python/ipython terminals. Currently this tool supports such Pandas objects as DataFrame, Series, MultiIndex, DatetimeIndex & RangeIndex.

Origins

D-Tale was the product of a SAS to Python conversion. What was originally a perl script wrapper on top of SAS's insight function is now a lightweight web client on top of Pandas data structures.

In The News

Tutorials

Related Resources

Contents

Where To get It

The source code is currently hosted on GitHub at: https://github.com/man-group/dtale

Binary installers for the latest released version are available at the Python package index and on conda using conda-forge.

# conda
conda install dtale -c conda-forge
# if you want to also use "Export to PNG" for charts
conda install -c plotly python-kaleido
# or PyPI
pip install dtale

Getting Started

readme truncated — read the full docs on github

Frequently asked questions

Is dtale free to use?

dtale is open source under the LGPL-2.1 licence. There is no licence fee and no seat count — you can self-host it or, where the project offers one, pay a vendor for a managed version instead.

What does dtale do?

Visualizer for pandas data structures

What is dtale written in?

dtale is primarily written in TypeScript. Its source is publicly available at https://github.com/man-group/dtale, and it has 5,223 GitHub stars.