|
Post by lourenco on May 18, 2020 14:01:37 GMT
Hello
I've done a pilot study recently and got some data to work on.
The first problem I've encountered is the data in CSV comes already compiled on mean, median, etc.
The individual participant data comes only as a TXT file. I know is possible to convert in Excel tables, but it's being very difficult, because on the TXT file the spaces between information is not always the same. So when I import data on the Excel the collums don't stay neat (eg, reaction times come spread on collum 5, 6 and 7, depending on how many spaces the TXT file had on that line).
Since is only 5 participants data right now, I'm correcting manually, but when I have 100 participants data, this will be impossible.
Any thoughts about what can I do to fix this issue?
Isn't possible to download the individual data also in CSV? (because with the CSV file, it seams Excel understands better and make all the collums correctly)
thank you
|
|
|
Post by PsyToolkit on May 18, 2020 14:36:21 GMT
Can you give me an example of what you have in your data file that makes this difficult?
|
|
|
Post by lourenco on May 18, 2020 14:49:01 GMT
So I've found some solution, with the help of my senior programer roomate.
I was able to import the individual data on the Excel with the neat collums.
Still, I have to do it manually, it would be a lot easier if all the individual participant data come on a single CSV file.
Is it possible?
|
|
|
Post by lourenco on May 18, 2020 14:54:30 GMT
I've tried to upload a image of the resulting table. Don't know if it's readable.
The data file on TXT is coming with different spaces between data on the same line. Sometimes is 1 space, sometimes is 2 and others are 3.
I've correct that using the "substitute" command on the windows text editor, substituing 2 and 3 spaces to 1. It has worked fine, but I wonder if there is any possible easier solution.
Can you give me an example of what you have in your data file that makes this difficult?
|
|
|
Post by PsyToolkit on May 18, 2020 23:40:42 GMT
I wonder why there are "empty" cells after "comp"?
Ultimately, this seems a problem with what you put in the "save" line. Using CSV would not solve your problem, it is more that you do not have exactly the same format for different trials.
The solution for your situation would be to write your own "script" to analyse the data files offline on your computer (for example in R or in the ruby or in python).
|
|