- edited description
Savwriter gives this value when I export Sav to Csv 1.#QNAN
Issue #79
resolved
Should we do any additional steps after I assign np.nan ? Or is there any other way to make the value to sysmis and still Excel or CSV export give empty cell ?
df.loc[(~df['q23a'].between(1,2 )), 'q23a'] = np.nan
The SavWriter output (sav file) when imported back to CSV has 1.#QNAN
I am using MacOS 10.13.3 and Python 3.6
Comments (3)
-
reporter -
reporter - edited description
-
reporter - changed status to resolved
I understand now the issues is more to do with SPSS "Save as" to Excel
- Log in to comment