Reading multiple CSV and then evaluate with python

[Complicated]

Hello,

I have 12 Excel files, which I first read into Knime with a CSV reader.

The file contains the order number (NUM), article (NUM), quantity (NUM), cost per article (0.00€), order time (date and time), address (street, no., postal code and city).

Now I want to sort out and analyze faulty lines with Python, but I don’t know how to access this read csv file in my python code.

[mlauber71]

@Complicated welcome to the KNIME forum. Here you can see how to get information into a Python node and back to KNIME. Data as well as Flow Variables.

Help to use Python do insert variable in SQL code

@Aldemir you can export data from within the Python node as Flow Variables or as a dataframe (from a pandas dataframe). The code would look something like this: import knime.scripting.io as knio import numpy as np import pandas as pd # bring your string to a Flow Variable knio.flow_variables['var_txt_cbi'] = txt_cbi # bring your content to a pandas data frame output_table = pd.DataFrame({'column_txt_cbi': [txt_cbi]}) # bring the dataframe back to KNIME knio.output_tables[0] = knio.Table.f…

Python scripting node data input

@Bob_Nisbet the in and out syntax would look like this for pandas dataframes. import knime.scripting.io as knio import numpy as np import pandas as pd # data from KNIME to Python (pandas) df = knio.input_tables[0].to_pandas() # data from python (pandas) to KNIME knio.output_tables[0] = knio.Table.from_pandas(df) KNIME would work internally with Arrow format https://docs.knime.com/latest/python_installation_guide/index.html#usage-examples

The Python Script Space on the KNIME Hub has some basci examples:

Input Data Tables with Python Script – knime

Also I would recommend to read the:

https://docs.knime.com/latest/python_installation_guide/#_introduction