Hey boys and girls,
does anyone know a good workaround for filtering many variables (> 50) with the same filter? For example, I want to exclude all values that are outside 3 standard deviations from further analysis. So far I have used the following as a filter: -3 <= Z(Variable_A) <= 3. However, it is quite impractical to create a separate filter for each variable or Jamovi becomes quite slow and often crashes if I have set more than six filter layers.
Thanks for your help!
Best regards,
Fabian
Filtering large datasets with the same filter
Re: Filtering large datasets with the same filter
hi,
if you can provide us a data set which runs very slowly and crashes, we'd be keen to take a look.
here's a few options for formulas (you can use `or`):
-3 < Z(Variable_A) < 3 or -3 < Z(Variable_B) < 3 or -3 < Z(Variable_C) < 3
ABS(Z(Variable_A)) < 3 or ABS(Z(Variable_B)) < 3 or ABS(Z(Variable_C)) < 3
MAX(ABS(Z(Variable_A)), ABS(Z(Variable_B)), ABS(Z(Variable_C))) < 3
it seems like we should add a ABSZ() function, maybe i'll do that for the next release. then you could go:
MAX(ABSZ(Variable_A), ABSZ(Variable_B), ABSZ(Variable_C)) < 3
and perhaps a MAXABSZ formula isn't a terrible idea either:
MAXABSZ(Variable_A, Variable_B, Variable_C) < 3
cheers
jonathon
if you can provide us a data set which runs very slowly and crashes, we'd be keen to take a look.
here's a few options for formulas (you can use `or`):
-3 < Z(Variable_A) < 3 or -3 < Z(Variable_B) < 3 or -3 < Z(Variable_C) < 3
ABS(Z(Variable_A)) < 3 or ABS(Z(Variable_B)) < 3 or ABS(Z(Variable_C)) < 3
MAX(ABS(Z(Variable_A)), ABS(Z(Variable_B)), ABS(Z(Variable_C))) < 3
it seems like we should add a ABSZ() function, maybe i'll do that for the next release. then you could go:
MAX(ABSZ(Variable_A), ABSZ(Variable_B), ABSZ(Variable_C)) < 3
and perhaps a MAXABSZ formula isn't a terrible idea either:
MAXABSZ(Variable_A, Variable_B, Variable_C) < 3
cheers
jonathon