Filtering duplicates?

Discuss the jamovi platform, possible improvements, etc.
Post Reply
elleplume
Posts: 1
Joined: Mon Aug 10, 2020 5:29 am

Filtering duplicates?

Post by elleplume »

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!
User avatar
MAgojam
Posts: 421
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)

Re: Filtering duplicates?

Post by MAgojam »

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.
Screenshot_dup.PNG
Screenshot_dup.PNG (102.28 KiB) Viewed 2364 times
Cheers,
Maurizio.
Post Reply