Filter rows by string

Name: Filter rows by string

Description: This function filters rows in the dataframe based on the presence of a specified string or substring within the specified columns. It scans the columns for matches and retains only those rows that contain the specified string, allowing for targeted analysis or extraction of relevant data. This is useful for narrowing down datasets based on key terms or phrases

Input: Dataframe - The latest version of uploaded data

Output: Dataframe - Link to the saved Dataframe which is modified as per the function and Summary of the actions performed

Mandatory and Non-mandatory/Advanced hyperparameters required for the function are listed below

Mandatory	Non-mandatory/Advanced hyperparameters
search_string	columns
	case_sensitive
	exact_match
	match_in_all_columns
	Save As New Table

Details of Hyperparameters are provided below

Name	Description	Accepted range/ values	Display Name
columns	Columns to filter the rows containing given string	Columns in the Dataframe	Columns to select
search_string	String to search and filter the rows if it contains	String	Search string
case_sensitive	Handles the case in matching	TRUE,FALSE	Case sensitive
exact_match	Filter the row if string exactly matches the row	TRUE,FALSE	Exact match
match_in_all_columns	Filter the row if string exactly matches the row in all columns	TRUE,FALSE	Match in all columns
Save As New Table	Option to choose whether the dataframe is to be saved as a new table	-	Save As New Table