If(s) statement that will perform logical checks on data table
Function:
Ifs(table = string, new_col = string, if_statement = string)
Parameters:
Table: Table name on which to perform function
New Column Name: New name for the created column
Ifs Statement: Logical statement to perform on table. When using column names in the statement format them like the following - ['column name']
Examples:
Ifs(table = Budget5567, new_col = Updated Stage, if_statement =
if ['Stage'] == 'Closed Won':
return 'Won'
if ['Stage'] == 'Lost':
return 'Lost'
else:
return 'Do not care')