DataFrameQueryUtil

DataFrameQueryUtil provides utility methods for executing database queries on DataFrame objects.

Methods

queryValue(query: String)

Description: Executes a SQL query on a DataFrame object..

Parameters:

• query (type: String): The SQL query to execute.

Returns: A string containing the result of the query in the first row and first column.

Example: Get the email address of a user based on their username.

Use Case: Useful for retrieving user contact information from a dataframe

var userEmail = DataFrameQueryUtil.queryValue("SELECT email from VisualQuery_1 where username like 'Samuel'")

---