Read .sav files in dataiku

shiniyag
Level 1
Read .sav files in dataiku

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?

 

0 Kudos
4 Replies
KimmyC
Dataiker

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.

0 Kudos
shiniyag
Level 1
Author

this is the error for the plugin:

 
 

 

0 Kudos
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

0 Kudos
shiniyag
Level 1
Author
0 Kudos