When dataframe value is updated, sorts are not reset

[q275343119]

My use case is as follows:

I want to control the sorting field of the table through a dropdown menu. Suppose I choose to sort based on col_1. I will first sort the DataFrame (df), then pass the sorted df to gr.Dataframe. However, if I click on another column header in the table to sort it, the sorting by the dropdown becomes meaningless. This is because, no matter how I sort the df, once it is passed to gr.Dataframe, it will sort according to the column header selected on the interface.

Is there a parameter in gr.Dataframe that allows controlling the sorting field and the order (ascending or descending)?

Additional Info: I am using Gradio version 4.20.0.

[abidlabs]

Hi @q275343119, I'm not sure I understand the question, you are already sorting the dataframe and passing the result to the gr.DataFrame component, right? So it is already being displayed in the correct order? Are you trying to prevent users from being able to sort the gr.DataFrame by clicking on a different column?

cc @hannahblair for visibility

[q275343119]

Hi @q275343119, I'm not sure I understand the question, you are already sorting the dataframe and passing the result to the gr.DataFrame component, right? So it is already being displayed in the correct order? Are you trying to prevent users from being able to sort the gr.DataFrame by clicking on a different column?

cc @hannahblair for visibility

Apologies, I didn't express myself clearly. I have attached the demo code for your reference:

import gradio as gr
import pandas as pd

# Sample DataFrame
data = {
    "Name": ["Alice", "Bob", "Charlie", "David"],
    "Age": [25, 45, 35, 40],
    "Score": [88, 92, 95, 85]
}
df = pd.DataFrame(data)

# Function to sort the DataFrame based on the selected column
def sort_dataframe(df, column_name):
    sorted_df = df.sort_values(by=column_name)
    return sorted_df

# Gradio Interface
def update_dataframe(column_name):
    sorted_df = sort_dataframe(df, column_name)
    return sorted_df

iface = gr.Interface(
    fn=update_dataframe,
    inputs=[gr.Dropdown(choices=df.columns.tolist(), label="Sort by")],
    outputs=gr.DataFrame(),
    live=True
)

iface.launch()

Let me now describe my scenario. First, I select age from the dropdown to sort, then click on the header of name to sort by that column. After this, no matter whether I try to sort by age or score, it doesn't work as expected.
The GIF is shown below:

[q275343119]

Hi @q275343119, I'm not sure I understand the question, you are already sorting the dataframe and passing the result to the gr.DataFrame component, right? So it is already being displayed in the correct order? Are you trying to prevent users from being able to sort the gr.DataFrame by clicking on a different column?

I want users to be able to sort by clicking on the column headers as well as by selecting the sorting field through the dropdown menu.

[abidlabs]

I see, I've renamed the issue so that we can tackle this!

[q275343119]

I see, I've renamed the issue so that we can tackle this!

That's cool, thank you!