Hide columns in DataGrid

[ccd2796]

It would be nice to be able to hide columns when displaying the DataGrid. I am working with a DataFrame that has lots of columns not relevant to the user, but useful for calculations. So it would be helpful to be able to hide those columns, get the input from the user (who will edit the cells), and store all that info with DataGrid.data

[ibdafna]

Hello @ccd2796 🙋‍♂️and welcome to the ipydatagrid community! Would you be interested in helping implement this feature?

[ccd2796]

Sent you an IB!

[jgunstone]

this is something that @ollyhensby and I are interested in also...
is this where the lumino table definitions are defined:
https://github.com/bloomberg/ipydatagrid/blob/fcd6a9399942dbb425904cd740272db30c88a99c/ipydatagrid/datagrid.py#L481-L482

or rather, would editing __dataframe_reference_index_names and __dataframe_reference_columns change the UI view?

[ibdafna]

I think it should be relatively easy to add this functionality on the Python side. We would just need to set the width of the column to 0. The only thing we need to figure out is the best way of un/doing this from the GUI. The references above will not affect the lumino definitions - they're used to restore pandas' native indices when retrieving the data back from the front-end.

[jgunstone]

reinvigorating this chat as i'd still love to be able to hide a column without changing the underlying data...

import pandas as pd
from ipydatagrid import DataGrid

df = pd.DataFrame.from_dict({"a":[1,2], "b":[3,4]})
gr = DataGrid(df)
gr

gr.column_widths = {"a":0}
# nothing happens

gr.column_widths = {"a":1}
# width reverts to minimum value of 10

this is called to update to column_widths
https://github.com/bloomberg/ipydatagrid/blob/c7cf3a48756264db92218ac40a0d5417a078dc9a/js/feathergrid.ts#L832-L868

ultimately calling a resize command in the core lumino package.
this.grid.resizeColumn('body', i, colSize)

I'd like to be able override whatever sets the minimum col width to 10 such that it allows a column_width = 0 as this would effectively hide the column.

but I couldn't find the code that did that in this repo... ?

I had a look in the base lumino package and found this:
https://github.com/jupyterlab/lumino/blob/a817cb2d05ac264403ad930fb9c038746c5393ff/packages/datagrid/src/datagrid.ts#L86-L88

but again can't find where the minimum column width number (=10) is actually set...!
Lumino has a minimumSizes class which feels like I'm getting warm...

if anyone can point me in the right direction I'd be v grateful

[zwelz3]

I don't have the knowledge to contribute, but this would be a nice enhancement (I came here after trying to set column_width to 0).

Would be doubly nice if it also overrides the auto_fit_columns flag (so you can use both)

[ollyhensby]

this is called to update to column_widths https://github.com/bloomberg/ipydatagrid/blob/c7cf3a48756264db92218ac40a0d5417a078dc9a/js/feathergrid.ts#L832-L868

ultimately calling a resize command in the core lumino package. this.grid.resizeColumn('body', i, colSize)

I'd like to be able override whatever sets the minimum col width to 10 such that it allows a column_width = 0 as this would effectively hide the column.

but I couldn't find the code that did that in this repo... ?

I had a look in the base lumino package and found this: https://github.com/jupyterlab/lumino/blob/a817cb2d05ac264403ad930fb9c038746c5393ff/packages/datagrid/src/datagrid.ts#L86-L88

but again can't find where the minimum column width number (=10) is actually set...! Lumino has a minimumSizes class which feels like I'm getting warm...

Looks as though the minimum sizes get set here:

https://github.com/jupyterlab/lumino/blob/a817cb2d05ac264403ad930fb9c038746c5393ff/packages/datagrid/src/datagrid.ts#L6708-L6713

Gets set as a section list object:

https://github.com/jupyterlab/lumino/blob/a817cb2d05ac264403ad930fb9c038746c5393ff/packages/datagrid/src/datagrid.ts#L86-L88

And in the _resizeColumn method, uses this resize method from the SectionList class:
https://github.com/jupyterlab/lumino/blob/a817cb2d05ac264403ad930fb9c038746c5393ff/packages/datagrid/src/datagrid.ts#L3429

This is the line I think is setting the minimum instead of allowing a user to set less than 10 (the minimum column width):
https://github.com/jupyterlab/lumino/blob/64171d9977a1850f076bd548e14a68c54c58f8a2/packages/datagrid/src/sectionlist.ts#L342

Maybe we could update the lumino datagrid to allow to override the minimum? Currently it won't let you set anything less than 10.