Allows executing a Python script in a local Python environment. The environment has to be configured under
File → Preferences → KNIME → Python or via flow variable, as described in the
KNIME Python Integration Installation Guide
.
This node supports Python 2 and 3. It also allows to import Jupyter notebooks as Python modules via the
knime_jupyter
module that is available in the node's Python workspace.
Multiple input and output ports of various types can dynamically be added to the node and used in the script.
See section Ports below for a description of all available inputs and outputs, and how they can be
addressed in the Python script.
Options
Script
Executable Selection
Templates
Flow Variables
Input Ports
- No description for this port available.
…- An input object. Input objects are automatically unpickled and made available to the Python script as variables whose names follow the scheme: input_object_<index>. For example, variable input_object_1 refers to the object at the first inbound Pickled object port.
- …
- An input table. In the Python script, input tables are available as variables of type pandas.DataFrame. The names of the variables follow the scheme: input_table_<index>. For example, variable input_table_1 refers to the table at the first inbound Table port.
Output Ports
- No description for this port available.
- …
- An output table. The corresponding variable must be defined in the Python script. It must be of type pandas.DataFrame and its name must follow the scheme: output_table_<index>. For example, in order to populate the first outbound Table port, variable output_table_1 must be defined as described.
…- An output image. The corresponding variable must be defined in the Python script. It must be either a string describing an SVG image or a byte array encoding a PNG image. Its name must follow the scheme: output_image_<index>. For example, in order to populate the first outbound Image port, variable output_image_1 must be defined as described.
- …
- An output object.The corresponding variable must be defined in the Python script. It can be of any type that can be pickled. Its name must follow the scheme: output_object_<index>. For example, in order to populate the first outbound Pickled object port, variable output_object_1 must be defined as described.
Popular Predecessors
- Python Script (legacy)5 %
Row Filter (deprecated)4 %- Column Filter4 %
- GroupBy3 %
- Joiner2 %
- Table Creator2 %
- Excel Reader2 %
- Excel Writer2 %
- String Manipulation2 %
Column Rename1 %- Missing Value1 %
- Concatenate1 %
- Python Source (legacy)1 %
- String to Date&Time1 %
- CSV Reader< 1 %
- Math Formula< 1 %
- Chunk Loop Start< 1 %
- Conda Environment Propagation< 1 %
- String to Number< 1 %
Row Splitter (deprecated)< 1 %- Sorter< 1 %
- Duplicate Row Filter< 1 %
- Rule-based Row Filter< 1 %
- Merge Variables< 1 %
- Column Resorter< 1 %
- Top k Row Filter< 1 %
- Loop End< 1 %
- Variable Creator< 1 %
- Constant Value Column< 1 %
- Rule Engine< 1 %
- RowID< 1 %
- Row Sampling< 1 %
- Excel Cell Updater< 1 %
- Logistic Regression Predictor< 1 %
- DB Insert< 1 %
- CSV Writer< 1 %
- Value Counter< 1 %
- R Snippet< 1 %
- Try (Data Ports)< 1 %
- Cell Splitter< 1 %
- Rule-based Row Splitter< 1 %
- Python Predictor (legacy)< 1 %
- Group Loop Start< 1 %
Cell Replacer< 1 %- DB Query Reader< 1 %
- Path to String (Variable)< 1 %
- File Reader< 1 %
- Number to String< 1 %
- Column Renamer (Dictionary)< 1 %
- Document Data Extractor< 1 %
- Line Plot (JavaScript)< 1 %
Flow Variable IF Switch< 1 %- Table Row to Variable Loop Start< 1 %
- Read Images< 1 %
- Single Selection Configuration< 1 %
- Image Properties< 1 %
Regex Extractor< 1 %- Parquet Writer< 1 %
Generic Loop Start< 1 %- Column Splitter< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer< 1 %
- Create File/Folder Variables< 1 %
- RDKit Descriptor Calculation< 1 %
- Normalizer (PMML)< 1 %
- Regression Predictor< 1 %
- Numeric Scorer< 1 %
- Create Table Structure< 1 %
- TimeDelay Loop Start< 1 %
- Line Plot (Plotly)< 1 %
- Column Expressions< 1 %
- External Tool< 1 %
- Math Formula (Variable)< 1 %
- Path to String< 1 %
- Boolean Configuration< 1 %
- Value Selection Configuration< 1 %
- String Widget< 1 %
- Container Input (Table)< 1 %
XML Reader< 1 %- HTML Parser< 1 %
- Column Renamer< 1 %
- Catch Errors (Var Ports)< 1 %
- Table Column to Variable< 1 %
- Variable to Table Row< 1 %
- Table Reader< 1 %
- Case Converter< 1 %
- Category to Number< 1 %
- Row Filter (Labs)< 1 %
- Row Splitter (Labs)< 1 %
- Pivot< 1 %
- Data Explorer< 1 %
- String to Path< 1 %
- Double Configuration< 1 %
- Parameter Optimization Loop Start< 1 %
- RDKit Substructure Filter< 1 %
- SHAP Loop End< 1 %
- Load SD-Files (SDF)< 1 %
- PDB Saver< 1 %
- Binary Objects to Strings< 1 %
Loop End< 1 %- Column Appender< 1 %
- Lag Column< 1 %
- Domain Calculator< 1 %
- Double to Integer< 1 %
- Rule Engine Variable< 1 %
- Color Manager< 1 %
- Parallel Chunk End< 1 %
- Parallel Chunk Start< 1 %
- Math Formula (Multi Column)< 1 %
- Sentence Extractor< 1 %
- Nominal Row Filter Configuration< 1 %
- List Box Input (legacy)< 1 %
- Multiple Selection Widget< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
JSON Reader< 1 %- Image to DataRow< 1 %
- Python Learner (legacy)< 1 %
- RDKit From Molecule< 1 %
- RDKit Fingerprint< 1 %
- One-way ANOVA< 1 %
- Image Writer (Port)< 1 %
- Split Collection Column< 1 %
- URL to File Path< 1 %
- Inject Variables (Data)< 1 %
- Table Writer< 1 %
- Java Edit Variable< 1 %
- Loop End (Column Append)< 1 %
- Recursive Loop End< 1 %
- Recursive Loop Start< 1 %
- Variable Loop End< 1 %
- X-Aggregator< 1 %
- PCA< 1 %
- Column Aggregator< 1 %
- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Cross Joiner< 1 %
- Reference Row Filter< 1 %
- Reference Row Splitter< 1 %
- Table Manipulator< 1 %
- Normalizer< 1 %
- String Manipulation (Multi Column)< 1 %
- Renderer to Image< 1 %
- Numeric Outliers< 1 %
- Keras Network Executor< 1 %
- RegEx Filter< 1 %
- Tika Parser< 1 %
- List Files/Folders< 1 %
- String to Path (Variable)< 1 %
- Integer Input (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Columns to JSON< 1 %
- Create Date&Time Range< 1 %
Extract Date&Time Fields< 1 %- Window Loop Start< 1 %
- Single Selection (legacy)< 1 %
- Transfer Files (Table)< 1 %
- Canonical SMILES< 1 %
- Load Local PDB Files< 1 %
- Shapefile Point Reader< 1 %
- Python Source< 1 %
- Binary Objects to Files< 1 %
- URL to File Path (Variable)< 1 %
- Create File Name (legacy)< 1 %
- Table Row to Variable< 1 %
Table Reader< 1 %- Java Snippet< 1 %
- Generic Loop Start< 1 %
- One to Many< 1 %
- Table Validator< 1 %
- Nominal Value Row Filter< 1 %
- Partitioning< 1 %
- End IF< 1 %
CASE Switch Data (Start)< 1 %- DB Reader< 1 %
- DB Writer< 1 %
- OpenBabel< 1 %
- PDF Parser< 1 %
Transfer Files< 1 %- Column Filter (legacy)< 1 %
- Date&Time Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- File Upload Widget< 1 %
- List Box Widget< 1 %
- Refresh Button Widget< 1 %
- Column Selection Widget< 1 %
- Single Selection Widget< 1 %
- Value Selection Widget< 1 %
- JSON Path< 1 %
- Date&Time to String< 1 %
- Date&Time-based Row Filter< 1 %
- Moving Average< 1 %
- RDKit Generate Coords< 1 %
- RDKit To Molecule< 1 %
- Weka Predictor (3.7)< 1 %
- XGBoost Predictor< 1 %
- Extract Text< 1 %
- XGBoost Predictor (Regression)< 1 %
- CIR< 1 %
- Silhouette Coefficient< 1 %
- Collection to String< 1 %
- PDB Loader< 1 %
- Shapefile Polygon Reader< 1 %
- Python Snippet< 1 %
- IDTextReader< 1 %
- Advanced MolConverter< 1 %
- logD< 1 %
- MolConverter< 1 %
- Create Collection Column< 1 %
- Copy/Move Files (legacy)< 1 %
- String to URI< 1 %
- Breakpoint< 1 %
- Wait...< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Variable Ports)< 1 %
- Variable to Table Column< 1 %
Database Reader< 1 %- Extract Context Properties< 1 %
- File Reader (Complex Format)< 1 %
- Line Reader< 1 %
- Model Reader< 1 %
File Reader< 1 %- Counting Loop Start< 1 %
Counting Loop Start< 1 %- Column List Loop Start< 1 %
Recursive Loop Start< 1 %- X-Partitioner< 1 %
- Naive Bayes Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Linear Regression Learner< 1 %
- Polynomial Regression Learner< 1 %
- Scorer< 1 %
- Random Forest Predictor (Regression)< 1 %
- Expand Bit Vector< 1 %
- Column Auto Type Cast< 1 %
- Column Combiner< 1 %
- Column Name Extractor< 1 %
- Reference Column Filter< 1 %
- Filter Apply< 1 %
- Missing Value Column Filter< 1 %
Joiner< 1 %- Missing Value (Apply)< 1 %
- Rank< 1 %
- Number Rounder< 1 %
- Table Difference Finder< 1 %
- Table Transposer< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Statistics< 1 %
- CASE Switch End< 1 %
- CASE Switch Start< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Data Generator< 1 %
- Parquet Reader< 1 %
- Spark to Table< 1 %
- Capture Workflow Start< 1 %
- Workflow Executor< 1 %
- Molecule Type Cast< 1 %
- SDF Reader< 1 %
- Counter Generation< 1 %
- Empty Table Creator< 1 %
- Variable Expressions< 1 %
- Read Excel Sheet Names< 1 %
- Java Snippet (simple)< 1 %
- Java Snippet Row Filter< 1 %
- Tika Language Detector< 1 %
- Strings to Document< 1 %
- Create Folder< 1 %
- Path to URI< 1 %
- Create Temp Folder< 1 %
- Transfer Files< 1 %
- Google Sheets Reader< 1 %
- Column Filter Configuration< 1 %
- Credentials Configuration< 1 %
- Date&Time Configuration< 1 %
- Local File Browser Configuration< 1 %
- Integer Configuration< 1 %
- List Box Configuration< 1 %
- String Configuration< 1 %
- Column Selection Configuration< 1 %
- Multiple Selection Configuration< 1 %
- File Chooser (legacy)< 1 %
- String Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Boolean Widget< 1 %
- Double Widget< 1 %
- Integer Widget< 1 %
Container Input (Variable)< 1 %- Container Output (Table)< 1 %
- JSON Reader< 1 %
- Container Input (JSON)< 1 %
- JSON Transformer< 1 %
- JSON to Table< 1 %
- Image Converter< 1 %
- Image Normalizer< 1 %
- Python Object Reader (legacy)< 1 %
- Python Object Writer (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- GET Request< 1 %
- POST Request< 1 %
- Webpage Retriever< 1 %
- Salesforce Simple Query< 1 %
- Test Data Generator< 1 %
- Date&Time Difference< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Date&Time Part Extractor< 1 %
- Date&Time Shift< 1 %
- String to Date/Time (legacy)< 1 %
- Workflow Service Output< 1 %
- XML Reader< 1 %
- XPath< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Molecule Substructure Filter< 1 %
- HTML Node to Text< 1 %
- HTTP Retriever< 1 %
- Wait< 1 %
- Table to HTML String< 1 %
- Denormalizer< 1 %
- RDKit Kekulizer< 1 %
- Interval Loop Start< 1 %
- PCA Apply< 1 %
- PDB Downloader< 1 %
- String Splitter (Regex)< 1 %
- SDF Writer< 1 %
- External SSH Tool< 1 %
- Term Vector< 1 %
Click< 1 %- Row to Column Names< 1 %
- File Upload (legacy)< 1 %
- Nominal Value Row Splitter< 1 %
IF Switch (Flow Variable Value)< 1 %- List Audio Files< 1 %
- Binary Objects to PNGs< 1 %
- PNGs to Binary Objects< 1 %
- Port to URI< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Auto-Binner< 1 %
- Linear Correlation< 1 %
- Normalizer (Apply)< 1 %
- Crosstab< 1 %
- Parameterized DB Query Reader< 1 %
- Random Number Assigner< 1 %
- JPython Function (Legacy)< 1 %
- Stop Word Filter< 1 %
- Boolean Input (legacy)< 1 %
- Nominal Row Filter Widget< 1 %
- JSON to XML< 1 %
- PNG Image to ImgPlus< 1 %
- Moving Aggregator< 1 %
- RDKit Chemical Transformation< 1 %
- XLS Formatter (apply)< 1 %
- Empty Collection to Missing< 1 %
- URL Encode< 1 %
- PDB Downloader (Source)< 1 %
- MarvinSketch< 1 %
- URI to String< 1 %
- Extract Variables (Data)< 1 %
- Image to Table< 1 %
Variable Condition Loop End< 1 %- Decision Tree Predictor< 1 %
- K Nearest Neighbor< 1 %
- Random Forest Predictor< 1 %
- Column to Grid< 1 %
- Mol2 Reader< 1 %
- Java IF (Table)< 1 %
- Decompress Files< 1 %
- Credentials Input (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Credentials Widget< 1 %
- Modify Time Zone< 1 %
- Set To List< 1 %
- PDB Sequence Extractor< 1 %
- Coordinate Row Filter< 1 %
- R Snippet< 1 %
- MzTabReader< 1 %
- R-group Decomposition< 1 %
- Elasticsearch Console (ES 6)< 1 %
- Fingerprints Expander< 1 %
- URL to Audio< 1 %
- Variable to Credentials< 1 %
Recursive Loop End< 1 %- SMOTE< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Column Comparator< 1 %
- Extract Missing Value Cause< 1 %
- Number to String (PMML)< 1 %
- String to Number (PMML)< 1 %
- Shuffle< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Data (End)< 1 %- Extract Color< 1 %
- ROC Curve (legacy)< 1 %
Parquet Writer< 1 %- k-Medoids< 1 %
- Model to Cell< 1 %
- Explorer Browser< 1 %
- Geo-Coordinate Row Filter< 1 %
- TF< 1 %
- Markup Tag Filter< 1 %
- Tag Filter< 1 %
- Repository File Chooser Configuration< 1 %
- Double Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Tile View (JavaScript)< 1 %
- Interactive Range Slider Filter Widget< 1 %
- XML to JSON< 1 %
- Workflow Service Input< 1 %
- 3D Coordinates< 1 %
- RDKit Remove Hs< 1 %
- URL Domain Extractor< 1 %
- Current URL< 1 %
- WAV Reader< 1 %
- Window Slider< 1 %
- List to FlowVariable< 1 %
Read PDB< 1 %- XLS Control Table Generator< 1 %
- Standardizer< 1 %
Input File< 1 %- Total Count< 1 %
Flow Variable End IF< 1 %- Read Variables< 1 %
- KNIME URI Resolver< 1 %
- Run Garbage Collector< 1 %
- Credential Variable Extractor< 1 %
- Load text-based files< 1 %
- Save File Locally< 1 %
- URL Decode< 1 %
- Outlier Removal< 1 %
- Python Snippet 2:2< 1 %
- Convert to Table< 1 %
- Naming< 1 %
- Topology Analysis< 1 %
- Create Directory (legacy)< 1 %
- Download (legacy)< 1 %
- Files to Binary Objects< 1 %
- List Remote Files (legacy)< 1 %
- Strings to Binary Objects< 1 %
Simple File Reader< 1 %Table Row To Variable Loop Start< 1 %- Fuzzy Rule Predictor< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- k-Means< 1 %
- Add Empty Rows< 1 %
- Category to Number (Apply)< 1 %
- Many to One< 1 %
- Equal Size Sampling< 1 %
- Filter Apply Row Splitter< 1 %
- Denormalizer (PMML)< 1 %
- Reference Column Resorter< 1 %
- Linear Discriminant Analysis Apply< 1 %
CASE Switch Variable (Start)< 1 %CASE Switch Model (End)< 1 %- Timer Info< 1 %
- Shape Manager< 1 %
Parquet Reader< 1 %- Workflow Summary Extractor< 1 %
- Rxn/RD Reader< 1 %
- Amazon Translate< 1 %
- Parallel Chunk End (multi port)< 1 %
- DB Delete (Table)< 1 %
- DB SQL Executor< 1 %
- One Row to Many< 1 %
- Time Series Generator< 1 %
- Visual 2D Data Generator< 1 %
- Distance Matrix Calculate< 1 %
- DL Python Network Executor< 1 %
- TensorFlow Network Executor< 1 %
- PMML to Cell< 1 %
- Cell to Model< 1 %
- Send to Power BI< 1 %
- SharePoint Online List Reader< 1 %
- Vocabulary Extractor (legacy)< 1 %
- IDF< 1 %
- StanfordNLP Open Information Extractor< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Dictionary Filter< 1 %
- Dictionary Replacer< 1 %
- N Chars Filter< 1 %
- Number Filter< 1 %
- Snowball Stemmer< 1 %
- Stanford Lemmatizer< 1 %
- Tag Stripper< 1 %
- Flat File Document Parser< 1 %
- Word Parser< 1 %
- Bag Of Words Creator< 1 %
- Term to String< 1 %
- Unique Term Extractor< 1 %
- Delete Files/Folders< 1 %
- CSS Editor< 1 %
- Value Filter Definition (legacy)< 1 %
- Value Filter (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Date&Time Widget< 1 %
- File Chooser Widget< 1 %
- Slider Widget< 1 %
- JSON Row Combiner and Writer< 1 %
- Container Input (Variable)< 1 %
JSON Writer< 1 %- Image Generator< 1 %
- Colorspace Converter< 1 %
- Projector< 1 %
- Don't Save Start< 1 %
- Parameter Optimization Loop End< 1 %
- Parameter Optimization Loop Start (Table)< 1 %
- Duration to String< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Modify Time< 1 %
Precision Checker (Event Log)< 1 %- RDKit Molecule Extractor< 1 %
- RDKit Optimize Geometry< 1 %
- RDKit R-Group Decomposition< 1 %
- RDKit Salt Stripper< 1 %
- RDKit Substructure Counter< 1 %
- BERT Classification Learner< 1 %
- Neo4j Reader< 1 %
- Base64 Encoder< 1 %
- HTTP Result Data Extractor< 1 %
- Extract Attribute< 1 %
Views
- Standard output
- The text sent by Python to its standard output during the execution of this node.
- Error output
- The text sent by Python to its error output during the execution of this node.
Workflows
(3D) Fragment library design workflowKNIME Hub- 00_R-PythonKNIME Hub
- 00_Visual_Analysis_of_Sales_Data(2)KNIME Forum
- 01_ClusteringKNIME Hub
- 01_Image_ReStyling_WebportalKNIME Hub
- Show all 420 workflows
Links
- Combination of math formula and rule engineby aworker on 2021-06-24forum.knime.com/p/127437
- PYTHON SCRIPT NODE WITH DYNAMIC PORTby danielesser on 2021-11-04forum.knime.com/p/138718
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.