Comment on page
Return data to the sheet
Return the data from your Python code to the spreadsheet.
Quadratic is built to seamlessly integrate Python to the spreadsheet. This means being able to manipulate data in code and very simply output that data into the sheet.
By default, the last line of code is output to the spreadsheet. This should be one of the three basic types:
(you can expect to primarily use DataFrames as Quadratic is heavily built around Pandas DataFrames due to widespread Pandas adoption in almost all data science communities!)
Note the simplest possible example, where we set
x = 5and then return
xto the spreadsheet by placing
xin the last line of code.
In this example, note that we do a basic calculation to fill our list
result. Since we want that list output to the sheet, we put the result in the last line and its output to the sheet, starting with the $2,154,446,753 value you see in the sheet.
In this example, we query the Mercury Bank Sandbox API, manipulating our data into a DataFrame. Since the DataFrame is our last line of code, we output to the sheet. Note that the column headers are the column headers in our DataFrame. Supports up to millions of rows.