How to have multiple result sets in Python from different SQL queries
On the documentation I found:
"If the code outputs another dataframe (named df2) to be used by Periscope Data's charting functionality, the dataframe can be passed to periscope.table with the following syntax:"
But how can I make the SQL section of the exploration produce two dataframes?
I have also been looking for a way to output two dataframes in the SQL section, but I'm not sure that it is possible. I think that portion of the documentation refers to generating another dataframe in Python. For example, the dataframe generated by the SQL section can be modified or reshaped into a second dataframe that is used for the actual chart display.Reply