wq/django-rest-pandas

📊📈 Serves up Pandas dataframes via the Django REST Framework for use in client-side (i.e. d3.js) visualizations and offline analysis (e.g. Excel)

chart
csv
dataviz
django
django-rest-framework
excel
pandas
rest-api
spreadsheet

Django REST Pandas

Django REST Framework + pandas = A Model-driven Visualization API

Django REST Pandas (DRP) provides a simple way to generate and serve pandas DataFrames via the Django REST Framework. The resulting API can serve up CSV (and a number of other formats for consumption by a client-side visualization tool like @wq/analyst.

The design philosophy of DRP enforces a strict separation between data and presentation. This keeps the implementation simple, but also has the nice side effect of making it trivial to provide the source data for your visualizations. This capability can often be leveraged by sending users to the same URL that your visualization code uses internally to load the data.

While DRP is primarily a data API, it also provides a default collection of interactive visualizations through the @wq/chart library, and a @wq/pandas loader to facilitate custom JavaScript charts that work well with CSV output served by DRP. These can be used to create interactive time series, scatter, and box plot charts - as well as any of the other charting possibilities Plotly provides.

Latest PyPI Release Release Notes License GitHub Stars GitHub Forks GitHub Issues

Tests Python Support Django Support

Documentation

DRP is configured by defining one or more API views and mapping them to URLs. The underlying implementation is a set of serializers that take Django REST Framework's serializer output and converts it into a dataframe. Then, the included renderers generate the output file using pandas' built in functionality.

  1. Getting Started
  2. Installation
  3. Related Work

  4. API Documentation

  5. Configuration
  6. API Views
  7. Serializers (DataFrame transformation)
  8. Renderers (Output Formats)

  9. Data Visualization

  10. @wq/analyst
  11. @wq/chart
  12. @wq/pandas
Stars
1253
0.40% more than last month
Forks
126
Open Issues
10