St.data_editor - Update via python

Summary

Hello, I am using the st.data editor + st.column_config.SelectboxColumn, to have a list from another dataframe shown as a selectbox in one of the column.
I want to update the visual st.data editor when choosing one of the select-options, based on another dataframe.

Is that possible?

For example, here is my app:

when choosing an event, I want to update the club/city columns with the appropriate club/city, grabbed from the “event dataframe” and for it to be represented in the st.data editor

One idea was to store the dataframe as st.session and re-render the whole page, but I’m not sure if that is the solution or there is a proper way.

Thanks a lot