Hello,
I have a question about the data that I’ve got from Pavlovia.
One of the questions I created (Q1_6) uses checkboxes, allowing participants to select two answers. After I completed a test run and converted the Excel file into SPSS, I noticed that the answers were split across two columns (Q1_6 and Q1_7). However, the column for Q1_7 should contain a different answer for the next question, which in this case is “Micky04.” As a result, the subsequent columns are shifted incorrectly, one by one.
Does anyone know how to fix this issue? I could manually adjust the data once I have all the answers, but if there’s an easier way to resolve it, I would be happy to learn and apply it!
It looks like opening the CSV file in Excel has broken the fact that [5,3] should be in the same cell instead of being comma separated.
Try a different way of opening the file – e.g. whichever of “from the Excel file menu” and “by double-clicking on the file in Explorer” you didn’t do.
To extract the data you could use something like
IF(ISNUMBER(SEARCH("5", E2)),1,0)
to check to for the 5 response, etc.
I converted the CSV file into SPSS and encountered the issue with the awkward answer. When I opened the file in Excel, I received this message: “Some features might be lost if you save this workbook in the comma-delimited (CSV) format. To preserve these features, save it in an Excel file format.” Following this advice, I saved the file as an Excel workbook. When I opened the newly formatted file in SPSS, everything was resolved. I hope this solution won’t cause any problems during analysis.
I truly appreciate your kind help—it was very helpful!