How to convert sav files

Datasets can be saved as .sav file (which is usually the case if SPSS is used).

To convert these files into .csv or .xlsx just use this jupyter notebook: sav_to_csv.ipynb
(fyi: it might take a few seconds to convert larger datasets, especially to xlsx)

Or use this python code snippet (and adapt path and file names if necessary) sav_2_csv.py:

import pandas as pd
import openpyxl

df_encoded = pd.read_spss('./pone.0179415.s004.sav', convert_categoricals=False)
df_decoded = pd.read_spss('./pone.0179415.s004.sav')

# df_encoded.head()
# df_decoded.head()

df_encoded.to_csv('./dataset_anxiety_encoded.csv', index=0)
df_decoded.to_csv('./dataset_anxiety_decoded.csv', index=0)

df_encoded.to_excel('./dataset_anxiety_encoded.xlsx', index=0)
df_decoded.to_excel('./dataset_anxiety_decoded.xlsx', index=0)

(pandas, openpyxl has to be installed)