Designate missing values

Discuss the jamovi platform, possible improvements, etc.
Post Reply
hejhej
Posts: 4
Joined: Tue Jan 30, 2018 11:46 am

Designate missing values

Post by hejhej »

First of all, thank you for a great piece of software!

I have a suggestion: make it possible to assign some values as missing in the "Data" view. This would be very useful, espacially when importing large data files from other programs that have discrete values as missing.
User avatar
jonathon
Posts: 2609
Joined: Fri Jan 27, 2017 10:04 am

Re: Designate missing values

Post by jonathon »

hi,

can you describe what you mean by "that have discrete values as missing"?

with thanks
User avatar
superyms
Posts: 23
Joined: Fri Sep 29, 2017 6:54 pm
Location: Algeria

Re: Designate missing values

Post by superyms »

I think he is proposing to populate missing data with NA, like we could do when importing csv files in R using na.strings=NA

That would be nice to be done in Jamovi.
User avatar
jonathon
Posts: 2609
Joined: Fri Jan 27, 2017 10:04 am

Re: Designate missing values

Post by jonathon »

hi yes,

a basic version of this is in the latest release (0.8.1.17) (currently available for macOS and linux, and the windows version should arrive in the next couple of hours).

you can set the 'default missings' in the app menu. you can specify NA, or -999999, and this will be treated as a missing value. however, this only applies at import time -- once the data is imported this has no effect.

we'll add the ability to change the missing value value on an *existing* data set in the future.

cheers

jonathon
hejhej
Posts: 4
Joined: Tue Jan 30, 2018 11:46 am

Re: Designate missing values

Post by hejhej »

Thanks, the kind of feature I was looking for! I have an SPSS file where missing is set as 9, 99 or in some cases 999 and that is giving me a bit of a headache when trying to do analysis in Jamovi.
User avatar
jonathon
Posts: 2609
Joined: Fri Jan 27, 2017 10:04 am

Re: Designate missing values

Post by jonathon »

hmmm,

at present, there's only provision for a single missing value value :/

but you could use the new `IFELSE` compute function:

IFELSE(colName == 9, NA, colName)

jonathon
User avatar
jonathon
Posts: 2609
Joined: Fri Jan 27, 2017 10:04 am

Re: Designate missing values

Post by jonathon »

In the next release you'll be able to use FILTER, which is almost the same:

FILTER(colName, colName != 9)

it's just a bit more "descriptive"

jonathon
Post Reply