Page 1 of 1

Split dataset

Posted: Fri Mar 23, 2018 2:41 am
by halfmoonangel
Hi!
Thanks for this neat software!

My apologies if this suggestion has already been made, but might it be possible to include an option to split the dataset along one variable for analyses. It is already possible to split the file in the Descriptives tab, but it would be great to have this option elsewhere too, for example when running one-sample t-tests (to give a specific example, I'm trying to test performance against chance level for each one of several experimental groups).

Thanks very much in advance for your comments!
H

Re: Split dataset

Posted: Fri Mar 23, 2018 2:47 am
by jonathon
hi,

splitting data is a little way off yet, but there are some ways you can achieve the same thing.

you can compute a new variable, with the FILTER(). something like:

= FILTER(group, group == 'group1')

in this way, you can create a new variable for each group, and analyse them separately.

it's not quite as slick as being able to 'split' the dataset, but it will get you there at a pinch.

cheers

jonathon

Re: Split dataset

Posted: Fri Mar 23, 2018 1:28 pm
by halfmoonangel
Thanks for the suggestion! I will try that.

Excellent work overall on that software :)

Re: Split dataset

Posted: Tue Apr 10, 2018 5:50 am
by Nem2k
jonathon wrote: in this way, you can create a new variable for each group, and analyse them separately.
My dataset already contains a 'group' variable, but I dont understand how to analyze the groups separately. For example how do you subset the data so that analysis is only performed on group==1?

Re: Split dataset

Posted: Tue Apr 10, 2018 10:14 am
by jonathon
hi,

in the following example, we run an ANOVA on *only* the `dose == 'VC'` rows. we do this by creating a computed variable called `len (only VC)`:
Screen Shot 2018-04-10 at 20.10.11.png
Screen Shot 2018-04-10 at 20.10.11.png (431.17 KiB) Viewed 10723 times
makes sense?

cheers

Re: Split dataset

Posted: Tue Apr 10, 2018 10:18 am
by Nem2k
ah gotcha. So theres no direct way to subset the data without creating new variables? That would be pretty useful if you're testing out models using different variables. It seems that currently you'd have to recreate a new variable(s) whenever you 1) want to work with a different subset or 2) want to test out different variables in the model

Re: Split dataset

Posted: Tue Apr 10, 2018 10:27 am
by jonathon
we're working on filtering at the moment, so hang tight.