query_manual_evaluation

separate_by_line(query)

Formats a SQL query string for better readability by adding newlines before keywords.

Parameters:

query (str) – The input SQL query string.

Returns:

The formatted query string.

Return type:

str

clean(elmnt)

Removes set notation characters from a string.

Parameters:

elmnt (str) – The input string.

Returns:

The cleaned string.

Return type:

str

evaluate_queries_in_workbook(init_file_open_dir=None, init_filename=None)

Opens a GUI window to evaluate SQL queries stored in an Excel workbook.

Parameters:

• init_file_open_dir (str, optional) – Initial directory to open the workbook from. Defaults to None.

• init_filename (str, optional) – Initial filename of the workbook to open. Defaults to None.

Returns:

The annotated workbook as a pandas DataFrame.

Return type:

pd.DataFrame

class DfVariable(tk.Variable)

A Tkinter variable subclass to store and manage pandas DataFrames.

Parameters:

value (pd.DataFrame, optional) – The initial DataFrame value. Defaults to None.

get()

Returns the stored DataFrame.

Returns:

The DataFrame.

Return type:

pd.DataFrame

set(value)

Sets the DataFrame value.

Parameters:

value (pd.DataFrame) – The new DataFrame.