@pt2501 I see several points.
One is that there seems to be a problem with the date and time conversion. The Python Labs node is struggling with that somewhat (Error with pandas in the Labs Python Integration - #9 by mlauber71). I imported the table first as PyArrow file and then converted specifically the Date columns to a pandas date time variable. It seems to work
table = knio.input_tables[0].to_pyarrow()
df = table.to_pandas(date_as_object=False)
df['Creation date'] = pd.to_datetime(df['Creation date'])
Then you append some data frames and so you will most likely produce double index entries which the conversion back to KNIME does not like (Error in Python script node - #6 by gonhaddock) - so:
df7.reset_index(inplace=True)
would reset the index. To be honest the whole syntax seems quite messy and I had to remove a part in order to make it work so there is no guarantee that this will work but I think you have a framework of how to deal with this.
@carstenhaubold you might want to continue checking the arrow/pandas and date and timestamp issues between KNIME and Python (Labs).
kn_forum_46899_python_type_data.knwf (62.1 KB)