# Performance / speed issue with pandas 1.5.0

**URL:** <https://forum.knime.com/t/performance-speed-issue-with-pandas-1-5-0/47457>\
**Category:** KNIME Analytics Platform\
**Created:** [September 22, 2022, 11:19am UTC](https://forum.knime.com/t/performance-speed-issue-with-pandas-1-5-0/47457 "2022-09-22T11:19:23Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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 23, 2022, 7:55am UTC](https://forum.knime.com/t/performance-speed-issue-with-pandas-1-5-0/47457/2 "2022-09-23T07:55:01Z")

</div>

@kormoczi you might want to try the Columnar Storage to communicate between KNIME and Python.

> **[KNIME Columnar Table Backend Boosts Performance | KNIME](https://www.knime.com/blog/improved-performance-with-new-table-backend)**
>
> This article talks about the new table backend extension in KNIME Labs and the performance advantages it brings: columnar vs row-based data representation.

Other option would be to use an external file (database) to bring data in and out (maybe not that elegang but still possible).

> [@Export data from KNIME for processing in Python (externaly)](https://forum.knime.com/t/export-data-from-knime-for-processing-in-python-externaly/47495/2):
>
> @TheLeo you could use [Parquet](https://kni.me/n/jita8ax2pW9UyCI8) to keep the column types. Or SQLite database: [https://kni.me/w/G1kX4pbOlCeq56cH](https://kni.me/w/G1kX4pbOlCeq56cH) ORC could also be an option but it might be more complicated. Both ORC and Parquet would allow to read and write data in chunks. [https://kni.me/w/uW1d55taxEotKFHO](https://kni.me/w/uW1d55taxEotKFHO) If you absolutely must have a text only file. [ARFF](https://datahub.io/blog/attribute-relation-file-format-arff) is another option: [https://kni.me/w/mp7Pv607rD0biVI5](https://kni.me/w/mp7Pv607rD0biVI5) If you want to explore more about exchange between KNIME and Python you might have a look here: [https://forum.knim…](https://forum.knime.com/t/unicodeencodeerror-charmap-codec-cant-encode-characters/39199/2)

---

_[View the full topic](https://forum.knime.com/t/performance-speed-issue-with-pandas-1-5-0/47457)._
