How to convert .sav file into csv file

Question

How do you convert .sav into .csv, or .sav into pandas DataFrame? Is there a direct way or doing this or a package that can do this?

Which .sav format are you asking about? Which program or library was used to create the .sav file? — Warren Weckesser, Sep 11 '19 at 20:51
It's an old SPSS file, I just want to manipulate it with Pandas — , Sep 11 '19 at 20:56

score 6 · Answer 1 · answered Sep 11 '19 at 20:43

GNU PSPP project (replacement for the proprietary program SPSS) has a helper tool to do this online - https://pspp.benpfaff.org/

To do this locally 1. Download GNU PSPP - http://www.gnu.org/software/pspp/get.html 2. Use command line to do the conversion

pspp-convert <input.sav> <output.csv>

score 0 · Accepted Answer · answered Sep 11 '19 at 20:46

0

You are probably looking for the pyreadstat module, you can find some code snippet to start on the github page.

answered Sep 11 '19 at 20:46

mucio

I've followed the code and get an error, "from .pyreadstat import read_sas7bdat, read_xport, read_dta, read_sav, read_por, read_sas7bcat ImportError: DLL load failed: The specified module could not be found." – Sep 11 '19 at 21:34
did you install the module using `pip`? – mucio Sep 11 '19 at 21:37
Why would this make a difference? I just use Pycharm interface and manually install these libraries from there – Sep 13 '19 at 05:38
maybe [this](https://github.com/Roche/pyreadstat/issues/33) can help you – mucio Sep 13 '19 at 10:17

2 Answers2