Filtering duplicates?

Discuss the jamovi platform, possible improvements, etc.

by elleplume » Mon Aug 10, 2020 5:37 am

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!
elleplume
 
Posts: 1
Joined: Mon Aug 10, 2020 5:29 am

by MAgojam » Mon Aug 10, 2020 9:18 am

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 292 times


Cheers,
Maurizio.
User avatar
MAgojam
 
Posts: 93
Joined: Thu Jun 08, 2017 2:33 pm
Location: Parma (Italy)


Return to General