Python Script (Labs) – Execute failed: Duplicate key detected: "0"

[Christian_Essen]

Hello,

When running my Python script, I get the following error message:
ERROR Python Script (Labs) 5:7 Execute failed: org.knime.core.util.DuplicateKeyException: Duplicate key detected: “0”

In PyCharm the script works without problems and also the execution (“Execute script”) in the node configuration window works without problems. My guess is that there is a problem with the output table, since I call it in a function:

def main():
     ....
     complete_results = pd.concat(complete_results)
     knio.output_tables[0] = knio.write_table(complete_results)*

main()

Any ideas?
I am thankful for any help!

Christian

[mlauber71]

@Christian_Essen could it be that you might have duplicate IDs (RowIDs) in your data set. You might have to reset the data frame index within the Python node:

Error in Python script node

Hello @mohini1329 and welcome to the KNIME forum. Have you tried to reset the index values to your DF? df = pd.concat([df.reset_index(drop=True)], axis=1).copy() BR

KNIME and Python - handle index columns and row_id – mlauber71

[Christian_Essen]

Hi Martin,

Thank you very much – tackling the duplicate IDs (RowIDs) did the trick. I did this directly in the Python script and inserted ignore_index=True.
The script now looks like this

> def main():
>      ....
>      complete_results = pd.concat(complete_results, ignore_index=True)
>      knio.output_tables[0] = knio.write_table(complete_results)
> 
> main()

Thank you again and best regards
Christian