Skip to content

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 with n/a (1).
  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.