Python Script unsupported DataType issue.

[gonhaddock]

Hello @JaeHwanChoi

A solution using KNIME 4.7; You can alternatively take a look to this post:

Python Script node. How to work with output table?

@Maya Thanks for the additional information. If you want to bring the response into KNIME as a JSON object then you can convert the dictionary to a JSON string and return that as a cell in the KNIME table as follows. Note, you will need to import json and pandas as pd. I’ve included a dummy dictionary to demonstrate the workflow. Note: If you have the response as a JSON you do not need to convert it to a dictionary, you could just return it in the dataframe by changing json_string to response. …

Py Script node:

import json
import knime.scripting.io as knio

import pandas as pd

dict_df = {'model_1': {'indicator_1': 0.65
            , 'indicator_2': 0.63
            , 'indicator_3': 0.88}
        , 'model_2': {'indicator_1': 0.83
            , 'indicator_2': 0.76
            , 'indicator_3': 0.93}}

json_string = json.dumps(dict_df)

df = pd.DataFrame([{"dict_detail": json_string}])

knio.output_tables[0] = knio.Table.from_pandas(df)

Adapted @DiaAzul 's solution…

BR