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

@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: [image] Error in Python script node KNIME Analytics Platform 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 [image] KNIME and Python - handle index columns and row_id – mlauber71 KNIME and Python - handle index columns and row_id Python script would convert the KNIME RowID to pandas data frame index

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

KNIME Analytics Platform

mlauber71 May 12, 2022, 4:22pm 2

@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:

3 Likes

Python output to a dataframe