@Agi the import has been changed to:
import knime.scripting.io as knio
While the syntax about the to_pandas() should be correct. Not sure if this will affect the pickle thing.
Parquet might be another format you could use to transfer data. Where you can switch out the import in Spyder by the one you will use in knime.