cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
The .describe() function in Python is really handy for exploratory analysis! Sometimes, you would want to display this as a table on a dashboard, but how? The output is typically printed out as text, not as a dataframe.

Fear not, getting this into a dataframe is fairly painless!

Before we go on, note that using Python requires the Python/R Integration.

Let's say this is the first 10 rows of your SQL output / starting dataframe (the data below is the User IDs and number of gameplays they made for a fictional gaming company)
print(df['gameplay_number'].describe()) gives you the following output
To get this in a table of its own (rather than a printout), use the code below! Note, the key in the dictionary used as an argument for pd.DataFrame is what we want to name the column of summary values in our final output. I chose to name this 'gameplays.'
df2 = pd.DataFrame({'gameplays': df['gameplay_number'].describe()})
df2 = df2.reset_index()

# Use Sisense for Cloud Data Teams to visualize a dataframe by passing the data to periscope.output()
periscope.output(df2)
And there you have it!
Version history
Last update:
‎03-02-2023 09:28 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

Sisense Privacy Policy