Savwriter gives this value when I export Sav to Csv 1.#QNAN

[Syam MP]

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

[Syam MP]

I understand now the issues is more to do with SPSS "Save as" to Excel