Share a clear and concise description of the issue. Aim for 2-3 sentences.
Hi everyone, Iām trying to detail my session.sql created- dataframe with columns and rows⦠Assume that the column names already exist as part of the sql query and weāre just calling them from there. The rows I want to make will be made up.
Appreciate the supportā¦
I would recommend adding a column for row_name, and making that the index of the dataframe, and either filtering down to the columns you want in the query itself, or filtering the dataframe afterwards with pandas.
You can set the row names with liq_df.index = row_names.
For showing only certain columns, just donāt include any other columns in your query. Or if you relly need columns that you donāt want to show: st.dataframe(liq_df[columns_to_show]).