Icon

kn_​forum_​38842_​py_​gtrends_​try_​catch

use a try catch construct to capture errors in Python or an empty table (when the RowIDs are all identical)
conda install -c conda-forge pytrends create a dummy table that would stand in if something goes wrong use a try catch construct to capture errors in Python or an empty table (when the RowIDs are all identical)(forum: https://forum.knime.com/t/python-problems-with-input-column-values-missing-values/38842/4?u=mlauber71) Try-Catch # https://bitbucket.org/KNIME/knime-python/src/master/org.knime.python2.envconfigs/envconfigs/# KNIME official Python integration guide# https://docs.knime.com/latest/python_installation_guide/index.html#_introduction# Meta collection about KNIME and Python# https://kni.me/w/AvjrddXKOIoZYLV3# use Miniconda and install a basic version (https://docs.conda.io/en/latest/miniconda.html)# Manage Conda environments:# https://docs.conda.io/projects/conda/en/latest/user-guide/tasks/manage-environments.html# conda remove --name py37_knime --all# KNIME Python Integration - envconfigs# overview of KNIME conda environment configurations (where this YAML file has been adapted from):# https://forum.knime.com/t/an-error-occured-during-training-of-the-keras-deep-learning-network-when-using-knime/38581/15?u=mlauber71# create a conda environment from scratch with this curated yaml file for MacOSX systems - you might have to adapt the path :-)# create new Conda environment under MacOSX (change the location of the YAML file!)# conda env create -f="/Users/m_lauber/Dropbox/knime-workspace/hub/kn_example_python_iris_2021/data/py37_knime_2022.yaml"# create new Conda environment under Windows (change the location of the YAML file!)# conda env create -f="C:\Users\user1234567\knime-workspace\forum\2022\kn_forum_38842_py_gtrends_try_catch\data\py37_knime_2022.yaml"# conda activate py37_knime# conda update -n py37_knime --update-all# conda config --get channels# conda deactivate# conda env list# start jupyter notebook (https://jupyter-notebook-beginner-guide.readthedocs.io/en/latest/execute.html)# py37_knime>jupyter notebook# KNIME and Deep Learning integration# https://forum.knime.com/t/an-error-occured-during-training-of-the-keras-deep-learning-network-when-using-knime/38581/7?u=mlauber71# overview of KNIME conda environment configurations (where this YAML file has been adapted from):name: py37_knime # Name of the created environmentchannels: # Repositories to search for packages- conda-forgedependencies: # List of packages that should be installed- python>=3.7,<3.8 # Python- py4j # used for KNIME <-> Python communication- nomkl # Prevents the use of Intel's MKL- pandas # Table data structures- jedi # Python script autocompletion- python-dateutil # Date and Time utilities- numpy # N-dimensional arrays- cairo # SVG support- pillow # Image inputs/outputs- pyarrow=6.0 # Arrow serialization- IPython # Notebook support- nbformat # Notebook support- scipy # Notebook support- jpype1 # Databases- h5py<3.0 # must be < 3.0 because they changed whether str or byte is returned- libiconv # MDF Reader node- asammdf=5.19.14 # MDF Reader node# ----------------------------------------------------- openpyxl # Excel Reader- scikit-learn # Machine Learning# Visualization- matplotlib- bokeh- seaborn- pytrends PytrendSTARTENDconda.environmentpy37_knimeMacOSXfirst linePytrendNode 110removeall columnsexcept RowIDdummy_row_id.tabledummy_row_id.tableuse existing RowIDs=> in case something goes wrongthe dummy tabel would providethe rows for the Loop End(wothout actually sending columns)result.tableconda.environmentpy37_knimewindows Python Source Table Row ToVariable Loop Start Loop End (ColumnAppend) Table Creator Conda EnvironmentPropagation Try (VariablePorts) Row Filter Python Source Table Rowto Variable Column Filter Table Writer Table Reader Catch Errors(Data Ports) Empty Table Switch Table Writer Conda EnvironmentPropagation conda install -c conda-forge pytrends create a dummy table that would stand in if something goes wrong use a try catch construct to capture errors in Python or an empty table (when the RowIDs are all identical)(forum: https://forum.knime.com/t/python-problems-with-input-column-values-missing-values/38842/4?u=mlauber71) Try-Catch # https://bitbucket.org/KNIME/knime-python/src/master/org.knime.python2.envconfigs/envconfigs/# KNIME official Python integration guide# https://docs.knime.com/latest/python_installation_guide/index.html#_introduction# Meta collection about KNIME and Python# https://kni.me/w/AvjrddXKOIoZYLV3# use Miniconda and install a basic version (https://docs.conda.io/en/latest/miniconda.html)# Manage Conda environments:# https://docs.conda.io/projects/conda/en/latest/user-guide/tasks/manage-environments.html# conda remove --name py37_knime --all# KNIME Python Integration - envconfigs# overview of KNIME conda environment configurations (where this YAML file has been adapted from):# https://forum.knime.com/t/an-error-occured-during-training-of-the-keras-deep-learning-network-when-using-knime/38581/15?u=mlauber71# create a conda environment from scratch with this curated yaml file for MacOSX systems - you might have to adapt the path :-)# create new Conda environment under MacOSX (change the location of the YAML file!)# conda env create -f="/Users/m_lauber/Dropbox/knime-workspace/hub/kn_example_python_iris_2021/data/py37_knime_2022.yaml"# create new Conda environment under Windows (change the location of the YAML file!)# conda env create -f="C:\Users\user1234567\knime-workspace\forum\2022\kn_forum_38842_py_gtrends_try_catch\data\py37_knime_2022.yaml"# conda activate py37_knime# conda update -n py37_knime --update-all# conda config --get channels# conda deactivate# conda env list# start jupyter notebook (https://jupyter-notebook-beginner-guide.readthedocs.io/en/latest/execute.html)# py37_knime>jupyter notebook# KNIME and Deep Learning integration# https://forum.knime.com/t/an-error-occured-during-training-of-the-keras-deep-learning-network-when-using-knime/38581/7?u=mlauber71# overview of KNIME conda environment configurations (where this YAML file has been adapted from):name: py37_knime # Name of the created environmentchannels: # Repositories to search for packages- conda-forgedependencies: # List of packages that should be installed- python>=3.7,<3.8 # Python- py4j # used for KNIME <-> Python communication- nomkl # Prevents the use of Intel's MKL- pandas # Table data structures- jedi # Python script autocompletion- python-dateutil # Date and Time utilities- numpy # N-dimensional arrays- cairo # SVG support- pillow # Image inputs/outputs- pyarrow=6.0 # Arrow serialization- IPython # Notebook support- nbformat # Notebook support- scipy # Notebook support- jpype1 # Databases- h5py<3.0 # must be < 3.0 because they changed whether str or byte is returned- libiconv # MDF Reader node- asammdf=5.19.14 # MDF Reader node# ----------------------------------------------------- openpyxl # Excel Reader- scikit-learn # Machine Learning# Visualization- matplotlib- bokeh- seaborn- pytrends PytrendSTARTENDconda.environmentpy37_knimeMacOSXfirst linePytrendNode 110removeall columnsexcept RowIDdummy_row_id.tabledummy_row_id.tableuse existing RowIDs=> in case something goes wrongthe dummy tabel would providethe rows for the Loop End(wothout actually sending columns)result.tableconda.environmentpy37_knimewindowsPython Source Table Row ToVariable Loop Start Loop End (ColumnAppend) Table Creator Conda EnvironmentPropagation Try (VariablePorts) Row Filter Python Source Table Rowto Variable Column Filter Table Writer Table Reader Catch Errors(Data Ports) Empty Table Switch Table Writer Conda EnvironmentPropagation

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: saure
Created at: 2022-01-17
On NodePit since: 2022-01-18
Last update: 2024-04-26
Created with KNIME version: v4.5.0
Tags: pythontrycatchemptytableswitch

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

Try NodePit Runner!