Convert file from long format to wide format
Is it possible to do this in JASP?
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Categories
Supported by
It looks like you're new here. If you want to get involved, click one of these buttons!
Is it possible to do this in JASP?
Comments
I have a dataset in long format and I would like to reshape it into wide format so that each subject appears in a single row with repeated measures in separate columns. Is there a way to do this directly in JASP, or do I need to prepare the data in another program before importing?v
I don't think this is possible in JASP no. In some cases you can get around this by using a different analysis (for example, mixed modeling in long format instead of repeated-measures ANOVA or latent growth curve in wide format), but you're often better off reshaping your data first and importing the reshaped data into JASP.
Okay, thanks. The idea is that I’m going to apply a linear mixed model. Would I then also be able to leave it as it is with a linear mixed model? It’s all very new to me, I know very little about statistics anyway...
so I’ll first look into how I can reshape it somewhere else.
for a mixed model the data need to be in long format, so it sounds like your data might already be in the correct format
The easy transformation between different formats has been on our radar for a long time. The reason why we haven't gotten to it yet is because in order to do this properly, other features needed to be in place. We are nearing completion on those, so I hope we can then focus on these important data-wrangling problems.
In general, I think it's helpful to be familiar with at least two statistical processsing platforms. That way, if one is missing something, the other may have it.
R
Hi All
It would seem that this Shiny app will do the job if you feed it a CSV file. You will find the functionality you need under the data management tab. I can't take any credit for the functionality here, the app is not mine, but it certainly seems to fill a niche!
Experimenters' Toolbox