Hello,
I have a matrix of items from a psychological test that I would to convert to a dataset format, for instance .csv.
The format of the matrix is:
1: 2 2: 2 3: 2 4: 1 5: 2 6: 1 7: 2 8: 2 9: 1 10: 1, etc. The numbers before the ":" correspond to the item number, the number following corresponds to the response (1=yes; 2=no).
I need to create a csv file with two rows, the first being the item number, the second being the response. So it would be a really wide dataset since there are 567 items.
Anyone could give suggestions about the software that I could use to do this (or code, package, etc) ? I am adding the file as an attachment.
It's quite easy to do it in R, Python, or even Excel. Anyway, here is your csv file.
[I put two version of the dataframe, row and column wise]
Thank you for this. Do you have R code I could use to do the work myself?
Or a particular package you use?
If you don't have to update your dataset and are not used to programming tools, try Text to Columns in Excel: https://support.microsoft.com/en-us/office/split-text-into-different-columns-with-the-convert-text-to-columns-wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7
Set the delims including colon (:) and space.
- Badges
- Science topic
- Similar topics
- Geoscience
- Asia
- India