Page 1 of 1

Removing missing data

Posted: Fri Feb 09, 2024 2:08 pm
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 :)

Re: Removing missing data

Posted: Sun Feb 11, 2024 7:14 pm
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.

Re: Removing missing data

Posted: Tue Feb 13, 2024 10:43 pm
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.