Skip to content

ML.DATA

Function Description
ML.DATA.CONVERT_TO_DF Converts an Excel table or range to a DataFrame object in the workbook.
ML.DATA.DESCRIBE Returns a description of the DataFrame.
ML.DATA.DROP_MISSING_ROWS Drops missing values from the DataFrame.
ML.DATA.INFO Returns the information about "data" as a DataFrame
ML.DATA.QUERY Executes a DuckDB SQL query against the DataFrame and returns the result as a DataFrame.
ML.DATA.SAMPLE Returns a sample of the DataFrame or the complete dataframe if n=-1.
ML.DATA.SELECT_COLUMNS Selects the specified columns from the DataFrame.
ML.DATA.SHAPE Returns the shape of the DataFrame as a tuple [n_rows, n_columns].