Looking for pandas web fronted

414 views
Skip to first unread message

Gabor Nyul

unread,
Feb 21, 2017, 1:57:04 PM2/21/17
to PyData

Is there any user friendly web frontend to pandas?

My point is: I have to give a browser based interface to my end users to see reports, statistics and so on. They have no real computer literacy, so I cannot give them iPython notebooks and so. They have to see simple list (although with sometime several thousand rows), charts based on that list and they might use he pivot capabilities to search/sort/group/analyze the data and sometimes download in Excel format.


I'm not looking for any reporting tools to generate pdf or such reports.


Pandas is wonderful, knows almost everything out of the box I need, but it requires python and pandas knowledge. So I'm looking for a user friendly web frontend to pandas The data is mainly MS SQL based (hundreds of tables with several millions of rows each) and queries and often done vie complex stored procedures.


Any hints?

Paul Hobson

unread,
Feb 21, 2017, 4:07:50 PM2/21/17
to pyd...@googlegroups.com
No one is going to have made specifically a pandas frontend. Instead, they'll make generic frontends that work with python in general.

One such framework is the jupyter widgets system: http://jupyter.org/widgets.html

It takes a notebook and provides basic graphical elements.
-p

--
You received this message because you are subscribed to the Google Groups "PyData" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pydata+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Gabor Nyul

unread,
Feb 21, 2017, 4:39:04 PM2/21/17
to PyData
Thanks for the advice.
But unfortunately my users will not be able to use the notebooks.
Basically they are able to use a menu system to select the report they need, enter the parameters required for that report and after search, filter, group the data.

So I'm not willing to reinvent the wheel and reprogram again all the pandas possibilities (indexing, grouping, pivoting, etc.) with a simplified and mouse driven user interface if a solution has already made by somebody.

Thiago Serafim

unread,
Feb 21, 2017, 4:59:53 PM2/21/17
to pyd...@googlegroups.com
Have you checked Airbnb's Superset project (previously named Caravel)?

Excerpt from their engeneering team blog post:
The codeless approach to data navigation allows everyone on board, democratizing access to data. On one side of the spectrum, users that are less technical find an easy interface to query data. On the other end of that spectrum, advanced users enjoy gaining velocity and the ease of sharing the content they create.




--

Gabor Nyul

unread,
Feb 21, 2017, 5:48:17 PM2/21/17
to PyData
Hey! I didn't heard about that! I will have a deeper look on it to see how I can fit that to my project/data. Thanks for suggesting it
To unsubscribe from this group and stop receiving emails from it, send an email to pydata+un...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages