Feature requests: Delete cases and spreadsheet display
Posted: Sun May 05, 2019 6:46 pm
Hi,
I'm starting to work on step-by-step guides for jamovi, both in order to create the material itself but also to see whether I can convince the psychology team to make a wholesale switch from SPSS to jamovi in September.
The first guide I'm working on is about opening and cleaning Qualtrics data. I'm using version 9.6.9 and I'm pleased to see that the variable descriptions and value labels are being correctly imported from the legacy SPSS file downloaded from Qualtrics. However, for ethical reasons, data from participants who do not complete the questionnaire should not be used, Simply adding a filter is not sufficient, since it can easily be turned off at a later date. Such data would not, for example, be suitable for sharing on an open data platform, or indeed with anyone outside the immediate research team.
I would therefore like to be able to remove deselected cases, either with a switch in the filter options or as a save option.
In order to get around this problem, I did try exporting a template file and the data to a csv file. However, when I deleted the appropriate cases in Excel and imported the edited csv file into a new jamovi file created from the template, the value labels had gone.
There are also a few other aspects which make SPSS far easier to use than jamovi at this point, so here is a list of interconnected things I would like to be able to do:
1) Delete cases based on a filter (as above).
2) Sort cases based on the value of a variable. This could help with 1 by grouping all of the cases to be deleted together which would allow them to be deleted manually.
3) Toggle between value labels and the underlying numbers. It is good to be able to see the value labels, but information can be parsed more quickly as digits. This also helps with checking value label errors (which can easily occur in Qualtrics if the questionnaire is edited or copied after it is activated.
4) Preserve value labels in the template file, so that new data can be imported.
5) Paste new variable names from a spreadsheet into multiple data variables. Copying variable names and descriptions from jamovi to Excel would be nice too, but that information could come from a separate csv download of the data from Qualtrics.
Best wishes,
Wakefield
Wakefield Morys-Carter
ATSiP Treasurer and Membership Secretary
Senior Psychology Demonstrator and Teaching Fellow
Oxford Brookes University
I'm starting to work on step-by-step guides for jamovi, both in order to create the material itself but also to see whether I can convince the psychology team to make a wholesale switch from SPSS to jamovi in September.
The first guide I'm working on is about opening and cleaning Qualtrics data. I'm using version 9.6.9 and I'm pleased to see that the variable descriptions and value labels are being correctly imported from the legacy SPSS file downloaded from Qualtrics. However, for ethical reasons, data from participants who do not complete the questionnaire should not be used, Simply adding a filter is not sufficient, since it can easily be turned off at a later date. Such data would not, for example, be suitable for sharing on an open data platform, or indeed with anyone outside the immediate research team.
I would therefore like to be able to remove deselected cases, either with a switch in the filter options or as a save option.
In order to get around this problem, I did try exporting a template file and the data to a csv file. However, when I deleted the appropriate cases in Excel and imported the edited csv file into a new jamovi file created from the template, the value labels had gone.
There are also a few other aspects which make SPSS far easier to use than jamovi at this point, so here is a list of interconnected things I would like to be able to do:
1) Delete cases based on a filter (as above).
2) Sort cases based on the value of a variable. This could help with 1 by grouping all of the cases to be deleted together which would allow them to be deleted manually.
3) Toggle between value labels and the underlying numbers. It is good to be able to see the value labels, but information can be parsed more quickly as digits. This also helps with checking value label errors (which can easily occur in Qualtrics if the questionnaire is edited or copied after it is activated.
4) Preserve value labels in the template file, so that new data can be imported.
5) Paste new variable names from a spreadsheet into multiple data variables. Copying variable names and descriptions from jamovi to Excel would be nice too, but that information could come from a separate csv download of the data from Qualtrics.
Best wishes,
Wakefield
Wakefield Morys-Carter
ATSiP Treasurer and Membership Secretary
Senior Psychology Demonstrator and Teaching Fellow
Oxford Brookes University