How to read a file using Python Pandas
hey,
I’m trying to read a IBM SPSS file format into Knime. From what I’ve found, it should be possible using python and the pandas library.
I have python 3.9 installed but and I use the
Python Source (legacy)with the script
import pandas as pd
df = pd.read_spss('/Users/jan/Downloads/spss-test.sav')
output_table = dfHowever, even before running the node, I get the error
The external Python process crashed for unknown reasons while KNIME set up the Python environment. See log for details.The installation of python3 seems to be fine:
I checked the log file in
.metadata/knime/knime.logbut there is nothing logged when the error is occurs.
I also tried to use the Python non-legacy extension but did not find a way to read a file into a table.
what am I missing?
thanks