Hi, I have some data with missing values which python returns as ‘NaN’ for data type Double, and ‘NaT’ for data type DateTime - see image below of sample output: [Raw] Since I want to output the data to the rest of the KNIME workflow I’ve tried to replace NaN/NaT using the following code (where my dataframe is called ‘df’): import numpy as np df = df.replace({np.nan: None}) Within the config section of the Python Script node this seems to work - see below: [ReplaceNaN] But when outputting to the next node as a table the NaNs remain on the column with data type Double. [TableOutput] Is this a bug, or am I using the wrong code to replace the NaNs? Thanks, Dom

Python behaving differently in config screen to output table

aworker October 12, 2021, 9:27am 4

Complementary to @mlauber71 last information, the following post may be of help:

Best

Ael

5 Likes