An example site about django-rest-pandas HOT 2 CLOSED

Looks like an interesting use case. I am working on some examples myself, but they won't be ready until next week.

To use Django REST Pandas in your project, the first thing to do would be to set up Django and Django REST Framework if you don't have them running already. (Even if you aren't using the Django ORM, these libraries are needed to set up the URL routing and request/response handling). As I noted in my reply to your tweet, DRP is optimized for the use case where the source data is coming out of a Django queryset. That said, there is a PandasSimpleView precisely for the use case where you want to supply your own data. The class has a get_data function that you can override with your own version, however it (currently) expects you to return a list of dictionaries which it will push into a dataframe for you.

I'll look into allowing you to return a pre-constructed dataframe from get_data, but in the meantime you should be able to get it to work with something like this:

# views.py
from rest_framework.response import Response
from rest_pandas import PandasSimpleView
class MyDataView(PandasSimpleView):
    def get(self, request, *args, *kwargs):
        dataframe = my_dataframe_fn()
        if "filter" in request.GET:
            dataframe = dataframe[...]
        return Response(dataframe)

You can then set up your urls.py as in the README to allow specifying the renderer via a file-extension-like format suffix. FWIW, I've had the most success working with the CSV renderer (which uses dataframe.to_csv behind the scenes). Since the CSV header generated by Pandas is often more complex than a simple list of columns, I'm also working on a d3 extension to load Pandas-style csv served up by DRP.

Thanks for your interest, I'll try to update the README with some of this information and get DRP out to PyPI within a week or so. Also, I am curious whether the Bokeh plotting server would meet your particular use case better - could you elaborate on why you want to serve up the dataframe separately?

from django-rest-pandas.

I added an example link to the README.

from django-rest-pandas.