# Export data from KNIME for processing in Python (externaly)

**URL:** <https://forum.knime.com/t/export-data-from-knime-for-processing-in-python-externaly/47495>\
**Category:** KNIME Analytics Platform\
**Tags:** python\
**Created:** [September 23, 2022, 7:17am UTC](https://forum.knime.com/t/export-data-from-knime-for-processing-in-python-externaly/47495 "2022-09-23T07:17:26Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![mlauber71](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mlauber71/32/73590_2.png) [@mlauber71](https://forum.knime.com/u/mlauber71)\
**Post date:** [September 26, 2022, 1:39pm UTC](https://forum.knime.com/t/export-data-from-knime-for-processing-in-python-externaly/47495/13 "2022-09-26T13:39:02Z")

</div>

@TheLeo there are some things to check when converting data with date and time variables between KNIME and Python (and Parquet). It should be possible to come up with a setting that should work for all your data variants. I might take a look at your example.

> [@Error with pandas in the Labs Python Integration](https://forum.knime.com/t/error-with-pandas-in-the-labs-python-integration/44473/9):
>
> @toscanomatheus this might be an interesting case. I will have to have a closer look at your specific file. I startet to look into the question pof the Python Labs nodes and Date and Time variables (again) and indeed there seems to be a problem with the handling of types. In a previous discussion I toyed around with several formats and then exported the data thru Parquet files and brought the data back to KNIME which worked (mostly): This time I tried two things with string formats exported …

> [@Error upon executing Python script (Rows can only be sliced by slice objects but got \<class 'type'\>)](https://forum.knime.com/t/error-upon-executing-python-script-rows-can-only-be-sliced-by-slice-objects-but-got-class-type/46899/3):
>
> @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](https://forum.knime.com/t/error-with-pandas-in-the-labs-python-integration/44473/9)). 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['…

> **[Check out Date and Datetime variable types between KNIME and Python – mlauber71](https://hub.knime.com/mlauber71/spaces/Public/kn_example_python_date_time~j65pBtLZ09q6ugO0/current-state)**
>
> Check out Date and Datetime variable types between KNIME and Python A Jupyter notebook to toy around with data variable is in the foler /data/kn\_example\_python…

---

_[View the full topic](https://forum.knime.com/t/export-data-from-knime-for-processing-in-python-externaly/47495)._
