Icon

kn_​example_​python_​if_​then

KNIME and Python - examples with if then else conditions

Three examples how to handel if then else functions with KNIME and Python

Three examples how to handel if then else functions with KNIME and Pythonhttps://forum.knime.com/t/error-when-create-a-simple-conditional-statement-in-python-node/14634/2?u=mlauber71 import knime.scripting.io as knioimport numpy as npfrom pandas import DataFramemydata = knio.input_tables[0].to_pandas()# https://datatofish.com/if-condition-in-pandas-dataframe/mydata['column'] = mydata['ClientNo'].apply(lambda x: 'hello world' if x =='T' else 'no T')knio.output_tables[0] = knio.Table.from_pandas(mydata) import knime.scripting.io as knioimport numpy as npfrom pandas import DataFramemydata = knio.input_tables[0].to_pandas()# https://datatofish.com/if-condition-in-pandas-dataframe/# https://stackoverflow.com/questions/19960077/how-to-implement-in-and-not-in-for-pandas-dataframevar_searchlist = ['T', 'B']mydata.loc[mydata['ClientNo'] == 'T', 'column'] = 'T' mydata.loc[mydata['ClientNo'] == 'B', 'column'] = 'B' mydata.loc[~mydata['ClientNo'].isin(var_searchlist), 'column'] = 'neither T nor B' knio.output_tables[0] = knio.Table.from_pandas(mydata) import knime.scripting.io as knioimport numpy as npfrom pandas import DataFramemydata = knio.input_tables[0].to_pandas()# https://datatofish.com/if-condition-in-pandas-dataframe/var_searchlist = ['T', 'B']mydata.loc[mydata['ClientNo'] == 'T', 'column'] = 'T' mydata.loc[mydata['ClientNo'] == 'B', 'column'] = 'B' mydata.loc[(mydata['ClientNo'] != 'T') & (mydata['ClientNo'] != 'B'), 'column'] = 'neither T nor B' knio.output_tables[0] = knio.Table.from_pandas(mydata) sample dataloc variant 2loc variant 1lambdaTable Creator Python Script Python Script Python Script Three examples how to handel if then else functions with KNIME and Pythonhttps://forum.knime.com/t/error-when-create-a-simple-conditional-statement-in-python-node/14634/2?u=mlauber71 import knime.scripting.io as knioimport numpy as npfrom pandas import DataFramemydata = knio.input_tables[0].to_pandas()# https://datatofish.com/if-condition-in-pandas-dataframe/mydata['column'] = mydata['ClientNo'].apply(lambda x: 'hello world' if x =='T' else 'no T')knio.output_tables[0] = knio.Table.from_pandas(mydata) import knime.scripting.io as knioimport numpy as npfrom pandas import DataFramemydata = knio.input_tables[0].to_pandas()# https://datatofish.com/if-condition-in-pandas-dataframe/# https://stackoverflow.com/questions/19960077/how-to-implement-in-and-not-in-for-pandas-dataframevar_searchlist = ['T', 'B']mydata.loc[mydata['ClientNo'] == 'T', 'column'] = 'T' mydata.loc[mydata['ClientNo'] == 'B', 'column'] = 'B' mydata.loc[~mydata['ClientNo'].isin(var_searchlist), 'column'] = 'neither T nor B' knio.output_tables[0] = knio.Table.from_pandas(mydata) import knime.scripting.io as knioimport numpy as npfrom pandas import DataFramemydata = knio.input_tables[0].to_pandas()# https://datatofish.com/if-condition-in-pandas-dataframe/var_searchlist = ['T', 'B']mydata.loc[mydata['ClientNo'] == 'T', 'column'] = 'T' mydata.loc[mydata['ClientNo'] == 'B', 'column'] = 'B' mydata.loc[(mydata['ClientNo'] != 'T') & (mydata['ClientNo'] != 'B'), 'column'] = 'neither T nor B' knio.output_tables[0] = knio.Table.from_pandas(mydata) sample dataloc variant 2loc variant 1lambdaTable Creator Python Script Python Script Python Script

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2019-03-29
On NodePit since: 2019-10-05
Last update: 2025-08-02
Created with KNIME version: v4.7.8
Tags: pythonknimeconditionifthenelse

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!