Hi there, I want to implement a pivot table from a dataframe using Streamlit, and when a specific cell in the pivot table is clicked, I want to filter the original dataframe based on the column, row, and value of that cell and display the detailed contents. Is there a way to do this? It seems that …

[image] Blank: I want to filter the original dataframe based on the column, row, and value of that cell and display the detailed contents. What do you mean by detailed contents?

Hi, This is not what I was looking for by selecting a value from a cell, but with this code I get to select the row to display and then display data from another dataframe relating it to a field and displaying a graph. @st.experimental_fragment def generate_dataframe_and_event(): …

I have a detailed code here. I want to retrieve the original rows from the DataFrame before pivoting when I click on a value in the pivot table, but it’s not easy.:sob: It seems like cell selection is not working with the code below, so an error occurs when calling it. I sent the code via mobile s…

We can select a cell in the dataframe but it does not return anything. However, as of streamlit version 1.35.0, depending on what you try to achieve, we can now select a row, or column or both and it returns a meaningful info. This info can be further utilized to achieve our goal. To activate sele…

Thank you so much! You’ve been a great help. However, while index calls work well in a regular DataFrame, they seem to cause errors when I try to use them in a pivot table with a multi-index. Given the following data, how can I retrieve the RAW value before pivoting when selecting the VALUE ‘F’ wit…

[image] Blank: Given the following data, how can I retrieve the RAW value before pivoting when selecting the VALUE ‘F’ with columns C and W, and rows G and P? Frame before pivot. [image] “when selecting the VALUE ‘F’ with columns C and W” There is no column “W”. And there are no rows G an…

[image] Blank: However, while index calls work well in a regular DataFrame, they seem to cause errors when I try to use them in a pivot table with a multi-index. Just reset the index. # Create the pivot table pivot_df_r = df.pivot_table(index=['C', 'D'], columns=['A', 'B'], values='E', aggfu…

Issue with Clicking Specific Cells in a Streamlit Pivot Table to Display Filtered Data

Using Streamlit

Blank June 2, 2024, 1:58am 5

I want the row data before pivoting when creating a pivot table from the above DataFrame. However, cell selection is not working, and only the row is being selected, which causes an error.

Dynamic Functionality of Table

Topic		Replies	Views
How return the value of the cell corresponding to the specified row and column in the dataframe Using Streamlit	3	816	May 17, 2023
New Component: <st_table_select_cell>, a new way to select a cell from a table Show the Community!	6	1512	September 22, 2025
Displaying pandas pivot_table in streamlit Using Streamlit pandas	4	7159	July 9, 2023
Single cell click events in Streamlit dataframe Using Streamlit dataframe , discussion , question	0	291	August 18, 2025
Clickable row in a dataframe Using Streamlit	3	2876	December 28, 2021

Issue with Clicking Specific Cells in a Streamlit Pivot Table to Display Filtered Data

Related topics