problem with csv reader - changing data types

[Aldemir]

The CSV writer is changing the data types I set. How do I keep the data types and the selected columns?"

When I reset the workflow and run the CSV reader again, it changes all the data types I set. How do I prevent this from happening?"

[JPollet]

Hello,
What happens if you “enforce types” at the top of this panel ?
Joel

[Aldemir]

I’ve already done that, and it didn’t work.

[mlauber71]

@Aldemir one option could be to import them all as strings and the n convert them later

Force KNIME to Read CSV Columns As Strings

@ricardo_martins , @mwiegand another approach could be to use the bundled Python version and tell pandas to import all columns as strings: import knime.scripting.io as knio import pandas as pd import pyarrow.parquet as pq # ASCII 164 as a delimiter: ¤ df = pd.read_csv(var_csv_file, dtype=str, sep = '¤', engine='python') df.to_parquet(var_parquet_file, compression='gzip') I use the way via the parquet file from Python since the import directly into a KNIME table seems to have some problems.

[Aldemir]

“I tried running Python and it’s showing this message. What could it be?”

[Aldemir]

[mlauber71]

@Aldemir you could, just use the integrated Python extension. And you might want to check the path.

How to Set Up Your Python Extensions | KNIME