python tz_convert not working in KNIME

[thentangler]

I am trying to convert a timestamp from UTC to my local timezone (US/Eastern), however when i try to run the Python node I am getting the following error:

ERROR Python Script 0:15 Execute failed: An error occurred during deserialization. See log for details.

I am very new to KNIME and I dont know where to look for the log file.

When i execute script inside the node, it i showing the result correctly. However when I try executing my work flow, it is halting on the python node with the above error.

The code I used is

df2['FG_local_stop_time']=df2['FG_stop_time'].dt.tz_localize('UTC').dt.tz_convert('US/Eastern')

Can someone tell me what I am doing wrong or point me to the log file?

Thank You

[mlauber71]

@thentangler it seems for the transfer of data from python to KNIME not all data types are supported in all nodes. One option could be too convert to an older python time format.

Python Source: Extreme Slow Data Transfer to Knime

That is true, we still have better Timestamp support for the Python (Labs) node on our agenda but did not get to add that for KNIME 4.5.2. As for the slow data transfer with the Python Source node (non-Labs): I have tried it with KNIME versions back to 4.3 and it was also slow there, so I am curious what might have changed. Maybe the Pandas version is different? Can you tell us which Python/Pandas/NumPy versions you are using with the older KNIME installation?

One option could be to store the data as a text column and convert it later. Not the most elegant solution I know.

Next thing would be to export the data from within three python node to a file or local database like SQLite or H2 and see if they would support the time format.

Use functions and Python code from an external .PY file or a Juypter notebook...

use the new (KNIME 4.6+) Python Script node and bundled Python version to...