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
Removing missing data
Re: Removing missing data
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.
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
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.