Step 1: Create a .tsv
file for an assessment tool
Prerequisite
It is assumed that the collected phenotypic data is available in .csv
format. Survey platforms like LimeSurvey provide export options for this.
If your .csv
file contains data for more than one assessment tool, create one .csv
file per assessment tool. Each .csv
file must contain a column with the participant_id
.
Example .csv
files
├── autism_quotient_10.csv
├── empathy_quotient_10.csv
├── light_triad.csv
├── psychopathy_personality_invertory_revised.csv
└── toronto_alexithymia_scale.csv
Naming convention
Please make sure that there is one .csv
file per questionnaire and the file name matches the questionnaire name.
Example content of <measurement_tool>.csv
participant_id | it[it01] | it[it02] | it[it03] | it[it04] | it[it05] | it[it06] | it[it07] | it[it08] | it[itN] |
---|---|---|---|---|---|---|---|---|---|
sub-001 | 2 | 3 | 5 | 5 | 5 | ||||
sub-002 | 2 | 3 | 5 | 5 | 5 | ||||
sub-003 | 2 | 3 | 5 | 5 | 5 | ||||
sub-004 | 2 | 3 | 5 | 5 | |||||
sub-005 | 2 | 3 | 5 | 5 | |||||
sub-006 | 2 | 3 | 5 | 5 |
Naming conventions
Please make sure to follow the following naming conventions:
- Each file contains the subject identifier in the
participant_id
column. - The name of the additional columns (i.e. the assessment tool items) can be chosen freely.
- All participants listed in the
participants.tsv
file must be listed in the<measurement_tool>.tsv
as well. If a participant did not take the questionnaire you can fill up the respective row withn/a
(1).
- More information about how to handle issues like drop-outs or the same questionnaires administered in different sessions can be found here.
When creating all the files according in line with the instruction above, save them as <measurement_tool>.tsv
files. If you need help with this, please have a look here for LibreOffice.