Hi,
I was wondering whether there is a function to filter duplicates within a column in jamovi? For example checking ID numbers if someone has taken a survey twice.
Note: I've already checked my data set for duplicates in Excel but I'm hoping to show all my working in one file.
Thanks!
Filtering duplicates?
Re: Filtering duplicates?
Hi @elleplume,
a question similar to yours asked me some time ago a colleague who could not find in Data-> Filters the possibility to apply a filter on an ID variable to exclude the possible presence of duplicates from the analysis.
The duplicated () function (which is under the hood of jamovi), is not present among the functions available and callable by Filters, so I suggested him to do a "dirty thing" with the use of the Rj module.
A line of code in Rj that reports the output do duplicate () to be copied and pasted as a new variable for use with Filters.
I am attaching a screenshot, which I hope you find useful. Cheers,
Maurizio.
a question similar to yours asked me some time ago a colleague who could not find in Data-> Filters the possibility to apply a filter on an ID variable to exclude the possible presence of duplicates from the analysis.
The duplicated () function (which is under the hood of jamovi), is not present among the functions available and callable by Filters, so I suggested him to do a "dirty thing" with the use of the Rj module.
A line of code in Rj that reports the output do duplicate () to be copied and pasted as a new variable for use with Filters.
I am attaching a screenshot, which I hope you find useful. Cheers,
Maurizio.