duckdb
, a library that allows SQL queries to be executed on pandas
DataFrames.
In essence, when querying a particular sheet, the entire sheet is first pulled into a pandas
DataFrame using the Google Visualization API. Once this is done, SQL queries can be run on the DataFrame using duckdb
.
spreadsheet_id
is the unique ID of the Google Sheet.sheet_name
is the name of the sheet within the Google Sheet.sheet_name
parameter.
SELECT
statemet is allowed to be executed through duckdb
. This, however, has no restriction on running machine learning algorithms against your data in Google Sheets using the CREATE PREDICTOR
statement.