Howdy, Stranger!

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

Supported by

Problem with JATOS result conversion

Hello,

I am trying to use OpenSesame to convert the results exported from JATOS, but the converted file turns out to be empty (both in .csv and .xlsx format).

For completeness, I am trying to convert results from online experiments run on JATOS, but which I did not create using OpenSesame (I used lab.js in this particular case). Could that be the issue?

Any help would be greatly appreciated.

Thanks

Comments

  • Hi, yes. The OS converter probably expects results in a very specific format.

    What do your exported results look like? Depending on the software you use to analyze data, maybe the best is to use an R package (like jsonlite) to read your data in

  • Thank you for your help, Elisa.

    So far, I have run just a couple of trials to test data export and conversion.

    If I export the single trial from JATOS, I am able to access it without issues using python's pandas.read_json function. However, when I looked the file which I get when I click "export all", it seems to me that each trial is reported sequentially, with a newline as separator. When I tried opening it in python as described above, I got "ValueError: Trailing data".

    I am unfamiliar with R, so I was trying to look for alternatives. Since I plan to collect a lot of trials per participant, I was hoping to analyse the data using python, and processing each raw output individually would be unfeasible.

  • I have attached the output file I am currently having trouble with, maybe it can help you find the issue more easily.

    It contains the results of 3 trials.

  • Hi, I have to run and can look at this later but yes, the problem is most likely that you have the following:

    ]

    [{"url":{},"meta":{"labjs_version":"20.2.4","labjs_build":

    etc. That's not a valid json.

    In the evening I can send you a solution, now I have to run

  • Hi again,

    Sorry for the chaotic reply sooner :)

    I don't use python, I use R. However, I was wrong: the format where each line is a valid JSON is apparently called jsonlines, and there's a library for that in Python. Have you tried this already?

    https://jsonlines.readthedocs.io/en/latest/

    If that doesn't work, what I've done in the past in R is to turn the separate lines into a single json string, like this

    data <- readtext(here("jatos_results_20221111092210.txt"))
    #This is wrong and reproduces your error
    fromJSON(data$text)
    
    data_better <- str_replace(data$text, fixed("}]\n[{"), "},{")   
    
    

    In your case that doesn't do it, not sure why. I'm sure I/you can figure it out, let me know if that python library doesn't help


    Best

  • edited November 12

    Thank you, I was able to load the JSON file as pandas dataframes using the jsonlines package as you suggested. Here is the code I used:

    import jsonlines
    import pandas as pd
    
    json_filename = #name of json file (as a string)
    
    with jsonlines.open(json_filename) as reader:
        for line in reader:
            display(pd.DataFrame(line))
    

    This allows you to display all individual JSON outputs as tables. I then came up with a quick solution to concatenate all files in a single dataframe using the following code.

    import jsonlines
    import pandas as pd
    
    i = 0
    
    with jsonlines.open(json_filename) as reader:
        for line in reader:
            if i == 0:
                df = pd.DataFrame(line)
                i += 1
            else:
                df = pd.concat([df, pd.DataFrame(line)])
                i += 1
    
    display(df)
    

    I am sure someone will come up with a better solution for this, but for now this works well enough for me. Thanks again for your help!

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 http://45.77.173.118/ 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