Add cell selection functionality to st.dataframe

[xareelee]

Problem

In the official tutorial about st.dataframe, it provides a well interactive UI, but it lacks one important feature: indicate the selected (row, column).

For example:

import streamlit as st
import pandas as pd
import numpy as np

df = pd.DataFrame(
   np.random.randn(50, 20),
   columns=('col %d' % i for i in range(20)))

st.dataframe(df)

We can change the last line to the following:

row, column = st.dataframe(df)

And we can select a specific cell in the GUI:

Now we can do something with the selected row and/or column (in the above case: row==4 and column=="col 2"). For example, we can show the detail info for the selected row.

---

Community voting on feature requests enables the Streamlit team to understand which features are most important to our users.

If you'd like the Streamlit team to prioritize this feature request, please use the 👍 (thumbs up emoji) reaction in response to the initial post.

[LukasMasuch]

@xareelee Thanks for the suggestion! We are planning to add row selection to st.dataframe (related issue) soon. Would that already solve your use case, or do you specifically want to select a single cell in the dataframe?

[xareelee]

@LukasMasuch Yes, in most instances, returning the selected row would be useful.

[robingie]

That's a great start which also could help me with my use case. Currently, I want to reduce the dependency on the custom component for AgGrid because it's not actively maintained anymore. The missing piece for me would be selecting 1-n (multi-select + checkboxes) to implement all natively with st.data_editor / st.dataframe.

[LukasMasuch]

btw. you can find a workaround for adding row selection in this comment: #688 (comment)

[MrChadMWood]

Bump.

I need to know metadata about the selected cell. The (row, column) combination represents a database entity in my case. Lets say (teacher, student) and the intersect is the numeric grade for that student in that teachers class.

I want to know which cell is selected so that I can redirect to another page with more info on the (teacher, student). I need to know the teacher id and student id, which can be looked up via the row and column values.

Alternatively, if there was a way to embed metadata in each cell that isn't seen by the user but can be referenced by me after a cell is selected... That could work too; I'd only need to embed the required metadata in each cell (saving the lookup step).

[kanalive]

Bump.

Was looking for this feature. This is very much needed.

[lakshminarayanareddybn]

Having cell based event callbacks help in building interactive dashboards.

[chrispy-snps]

We are also quite interested in st.dataframe row selection.

[Dev-iL]

I managed to create a workaround in case anybody's interested. The code for this, as well as some earlier attempts, is available in the gist. Demo: