How to apply pandas styles to qgrid dataframe

[javierorozco]

Is it possible to apply pandas styles to qqgrid dataframes? Something like described here http://pandas.pydata.org/pandas-docs/stable/style.html or simply like this df.style.set_caption('Colormaps, with a caption.').background_gradient(cmap='Spectral')

[TimShawver]

Hi @javierorozco, it's not currently possible, but I've heard a similar request before: https://github.com/quantopian/qgrid/issues/28 so it seems like it might be worth adding. I'll have to look into it next time I scope out a qgrid project.

Thanks for the question.

[jstewart37]

Will this be introduced in the future, would be really usefull.

[Desimor]

I have actually been looking for this for the longest time. Currently, I can only apply styles to the widget.get_changed_df(), but after like 2 weeks of attempting to figure out how to do styling to the qgrid itself, I could not find anything related nor figure out some hacky solution to it.

[TimShawver]

Thanks for the feedback...yea this would be really cool (and sounds like a lot of people want it) but I haven't had time to figure out how to do it yet. I recently came up with a strategy for applying styles that make the cells look merged for MultiIndex dataframe (see https://github.com/quantopian/qgrid/pull/203) so hopefully I'll be able to use a similar strategy to tackle this problem. Not sure when I'll get to it though.

[Desimor]

Lol. It just occurred to me that my Dark Reader made the tables look black and darkened the picture, but they are technically white and the colors are brighter on a normal monitor. Anyway, I'm glad it's something everyone wants. I can't wait to see it implemented. Until then, I can highlight the dataframe that it produces using pandas until the actual qgrid widget can display the highlighting itself.

Just a few notes: -- I'll be adding a heat-map to the individual columns. -- I also need to put a standard deviation highlight to any data based on whatever calculation I used to determine it's deviation. So for instance, the red highlighted cells are are based on any number that is over 80, which means I'll be applying some logic to the column/series.

[CFGrote]

any progress on this one? i could also use this feature.

[alainwal]

Just following-up here as I was about to post in another thread. Any new update on that matter? would be awesome to use pd.style.format

[bajizhh]

How to apply pandas styles to qgrid dataframe ?

[bajizhh]

any progress on this one? i could also use this feature.