Removing missing data

General help and assistance with jamovi. Bug reports can be made at our issues page: https://github.com/jamovi/jamovi/issues . (If you're unsure feel free to discuss it here)
Post Reply
User avatar
Aime
Posts: 1
Joined: Wed Jan 31, 2024 9:41 pm

Removing missing data

Post by Aime »

I have a big data set and I am wanting to delete data that is missing across all variables, how do I do this so it deletes the full row and I will only have participants data who have answered all the questions?

thanks :)
User avatar
reason180
Posts: 257
Joined: Mon Jul 24, 2017 4:56 pm

Re: Removing missing data

Post by reason180 »

It may not be possible to do this strictly within jamovi.
In R you could execute the expression:
data <- data[complete.cases(data), ]

(The above assumes that you already have a data frame named: data)

Using jamovi's Rj+ you could execute:
df<- data[complete.cases(data), ]
but then you would need to properly set R's working directory, then write df to a csv file in that working directory. Then you could open the new csv file in jamovi.
User avatar
reason180
Posts: 257
Joined: Mon Jul 24, 2017 4:56 pm

Re: Removing missing data

Post by reason180 »

Or: If your large data set has a manageable number of variables, you could just write a command in the jamovi filter that has the effect of filtering-in only complete rows. Then you could export the data as a csv file (any rows not-filtered-in will be dropped), and then open the csv in jamovi.
Post Reply