Support multi-column sort for `st.dataframe`

[lukasmasuch]

Checklist

• [x] I have searched the existing issues for similar feature requests.
• [x] I added a descriptive title and summary to this issue.

Summary

st.dataframe supports sorting a single column at a time. Allow sorting the dataframe by multiple columns at the same time, e.g. "col A" ascending + "col B" descending.

Why?

Other common data grids support sorting a dataframe by multiple columns at the same time which is useful for interactive data exploration tasks.

How?

This can be implemented purely as a frontend feature that doesn't require any API changes.

For example, this is how its implemented in Notion:

Additional Context

No response

[github-actions[bot]]

To help Streamlit prioritize this feature, react with a 👍 (thumbs up emoji) to the initial post.

Your vote helps us identify which enhancements matter most to our users.