Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Supported by

Converting JATOS Results with Multiple Components to csv/xlsx

Hi y'all,

We have programmed a JATOS experiment that contains an OSWeb component, as well as 3 other components (i.e., consent form, pre-task questionnaire, and post-task questionnaire).

We are preparing to begin data collection and are planning our data preprocessing pipeline. We are using the "Convert JATOS results to csv/ xlsx" function in OSWeb. However, it does not seem to be converting the non-OSWeb components properly. I have attached a screenshot of the text file produced from JATOS for one test session, as well as the xlsx file produced by OSWeb. In the text file, each component is in a separate dictionary.

Please advise.

Thank you,



  • Hi @byos ,

    I would start by deciding for yourself how you would like to organize the data. Basically, you have data from questionnaires and data from a trial-based experiment. These are fundamentally different forms of data, and so you have to decide on how you want to combine them so that you can analyze them easily. One option that comes to mind is:

    • Have one spreadsheet with the questionnaire data for all participants. Here, one row would be one question for one participant. (Other forms are possible, but this seems the easiest.)
    • And have another spreadsheet with the trial-based data. Here, one row would be one trial for one participant.

    Another option would be to have a column for each question from the questionnaires, and then repeat the response for all rows that belong to one participant. (Just like subject_nr , say.)

    Once you've decided on a format, you can think of how to actually transform it. But first things first!

    -- Sebastiaan

    Buy Me A Coffee

  • Hi @byos,

    If you're using different components collecting different types of data, the best option is to save the data in separate files using some information that allows you to cross-reference the data to know what data belong to what subject, and then recombine the data in the format that suits your analysis in Excel using functions like "match", "vlookup" etc., or some other program. The obvious piece of information would be the subject's id.

    The alternative that Sebastiaan is highlighting can be very useful if your other components are fairly simple. It would consist in passing to the OS task the responses from the consent form and prequestionnaire and saving these on every trial by including it in the logger. Note that, obviously, the post-questionnaire data would not be part of task's output. Hence, if you're planning to condition the analysis of the data from the OS task on variables from the questionnaires, the first option (separate output files) is best, I think.

    Not sure what your program your other components in, but I understand they all work under JATOS. I guess you can get generate a unique random subject id at the start and then pass it on to the different components in JATOS. Otherwise, an alternative that also work is to pass key information through the URL of your different components (some people use this method, for example, to pass info from Qualtrics to OSWeb and back, for example).

    Hope this helps.


    Buy Me A Coffee

Sign In or Register to comment.

agen judi bola , sportbook, casino, togel, number game, singapore, tangkas, basket, slot, poker, dominoqq, agen bola. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 50.000 ,- bonus cashback hingga 10% , diskon togel hingga 66% bisa bermain di android dan IOS kapanpun dan dimana pun. poker , bandarq , aduq, domino qq , dominobet. Semua permainan bisa dimainkan hanya dengan 1 ID. minimal deposit 10.000 ,- bonus turnover 0.5% dan bonus referral 20%. Bonus - bonus yang dihadirkan bisa terbilang cukup tinggi dan memuaskan, anda hanya perlu memasang pada situs yang memberikan bursa pasaran terbaik yaitu Bola168. Situs penyedia segala jenis permainan poker online kini semakin banyak ditemukan di Internet, salah satunya TahunQQ merupakan situs Agen Judi Domino66 Dan BandarQ Terpercaya yang mampu memberikan banyak provit bagi bettornya. Permainan Yang Di Sediakan Dewi365 Juga sangat banyak Dan menarik dan Peluang untuk memenangkan Taruhan Judi online ini juga sangat mudah . Mainkan Segera Taruhan Sportbook anda bersama Agen Judi Bola Bersama Dewi365 Kemenangan Anda Berapa pun akan Terbayarkan. Tersedia 9 macam permainan seru yang bisa kamu mainkan hanya di dalam 1 ID saja. Permainan seru yang tersedia seperti Poker, Domino QQ Dan juga BandarQ Online. Semuanya tersedia lengkap hanya di ABGQQ. Situs ABGQQ sangat mudah dimenangkan, kamu juga akan mendapatkan mega bonus dan setiap pemain berhak mendapatkan cashback mingguan. ABGQQ juga telah diakui sebagai Bandar Domino Online yang menjamin sistem FAIR PLAY disetiap permainan yang bisa dimainkan dengan deposit minimal hanya Rp.25.000. DEWI365 adalah Bandar Judi Bola Terpercaya & resmi dan terpercaya di indonesia. Situs judi bola ini menyediakan fasilitas bagi anda untuk dapat bermain memainkan permainan judi bola. Didalam situs ini memiliki berbagai permainan taruhan bola terlengkap seperti Sbobet, yang membuat DEWI365 menjadi situs judi bola terbaik dan terpercaya di Indonesia. Tentunya sebagai situs yang bertugas sebagai Bandar Poker Online pastinya akan berusaha untuk menjaga semua informasi dan keamanan yang terdapat di POKERQQ13. Kotakqq adalah situs Judi Poker Online Terpercayayang menyediakan 9 jenis permainan sakong online, dominoqq, domino99, bandarq, bandar ceme, aduq, poker online, bandar poker, balak66, perang baccarat, dan capsa susun. Dengan minimal deposit withdraw 15.000 Anda sudah bisa memainkan semua permaina pkv games di situs kami. Jackpot besar,Win rate tinggi, Fair play, PKV Games