problem reading .csv file


I have a simple CSV file called ship_V6.

I have a simple workflow. CSV reader and Python script
The script fails to print a column it is not able to find it.
I have attached the images.

  1. workflow

    I have attached the input file. CSV
    ship_V6.csv (3.6 KB)
    the reader .csv node configuration

  2. the simple Python script in the node of Python with the error after executing the Python node.

I do not understand what is happening. It is something simple.

I appreciate any help.

Thank you in advance



Hi @Mary_lea welcome to KNIME forum

Where is column L in your data? I only see column1 to column22 in your data.

Gr. Hans

1 Like

@Mary_lea your Python node has a data port configured but you do not provide one:

Import CSV File - KNIME Forum (75783).knwf (124.5 KB)

1 Like

Hello Gr. Hans.

If you download the ship_V6 has 119 columns and L is column 50.



Hello mlauber 71,

I thank you for all the long workflow and the advice.

But I do not understand why a simple statement like this
import as knio

Leer la tabla de entrada

df = knio.input_tables[0].to_pandas()

Imprimir la columna ‘L’

print(df[‘Sales Area’])
It is worked perfectly well with another file

I can not attache the other file because it is not allowed by the size bigger than 4MB and it does not work with ship V_6

And with ship_V6 the same does not work.

I know that more complicated things can be done. But for now, I am interested in this simple script.

Why is not working?

I appreciate any help in this specific matter.



@Mary_lea as I have mentioned. Your Python nodes have a data port (the small black triangle) configured but in the code there is no line that would create this data.

Such an output would look like this assuming df is a pandas dataframe (you might want to check the links provided above)

# bring the dataframe back to KNIME
knio.output_tables[0] = knio.Table.from_pandas(df)

If you do not want any output you can remove this port. Then you would have to take care about the output yourself.


You can read more about how the Python integration works here:


I manage to solve the problem

Thank you,

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.