ML.DATA.QUERY¶
Executes a DuckDB SQL query against the DataFrame and returns the result as a DataFrame.
Syntax¶
Arguments¶
| Name | Type | Default | Description |
|---|---|---|---|
| data | object | The DataFrame to query. | |
| query | str | The DuckDB SQL query to execute. Reference the DataFrame as 'df' in the query (e.g. 'SELECT * FROM df WHERE col > 0'). |
Examples¶
Examples coming soon
Working Excel formula examples for this function are not yet written.