Read .sav files in dataiku

shiniyag

Hi,I have been trying to open .sav files in dataiku but it doesnt work , even with Plugin for SPSS. Tried using scipy, but cannot pass filename as filename is not found even though file was uploaded.

filename = 'customer_1.sav'

scipy.io.readsav(filename, idict=None, python_dict=False,uncompressed_file_name=None, verbose=False)

Error message-

FileNotFoundError: [ Errno 2 ] No such file or directory: customer_1.sav

Can anyone please help me with this?

KimmyC

Hi,

Are you encountering an error when using the SPSS plugin to load the .sav file? If so, can you please copy the error over?

For the filename, you would need to specify the full path to the filename and it's uploaded into DSS, then it'll be PATH_TO_DATADIR/uploads/your_project_id/datasets/your_dataset_name/your_dataset_name.sav. You might want to double check this by navigating into that specific path of the data directory.

shiniyag

this is the error for the plugin:

shiniyag

@KimmyC

Clément_Stenac

The plugin does not support compressed sav files, so you'll indeed need to use scipy, following @KimmyC
advice on using absolute paths