Basic PsychoPy Data Processing in Excel (Part 1) -- PsychoPy Tutorial

In this PsychoPy tutorial we look at data output from our simple PsychoPy memory experiment in Excel and deal with our first pivot table. We examine how to summarize data and explore merging data files from multiple participants. We also encounter the PsychoPy loop bug one more time...

This tutorial is part of a series for the Human Cognition and Memory Lab at SUNY Geneseo by Dr. Jason Ozubko

[MaxnniProg]

Hi jason, just wanted to post a thanks as your series has been incredibly helpful in putting together some research projects. People like you making open science more accessible and easy are top loons.

[mojganehsanifard]

Hey Jason,
I just wanted to THANK YOU for making my life much easier!
Thank you for sharing your knowledge with us and I will, one day, do the same.

[mehranzare-bidoky]

Hi Jason, So many thanks for your perfect tutorials. They helped me a lot.
BTW, your intentional mistakes make what I learn much more memorable.

[timtech]

Thank you so much! You saved my dissertation

[realkhranyewest]

i don't get how this looks so clean and organized.. when i look at my data it looks like my cat ran over my keyboard and its not even the keyresponses for every trial in it

[luciamercogliano]

Hello,
when I open the exile files my values ​​are confused, not ordered like yours. Why? Thanks you

[nydiaayala]

Hello! Thank you so much for creating these videos! I was wondering if you have any tips for handling data where branching occurred (depending on participants' responses at one trial, certain loops were skipped)? Because loops were skipped, these columns are missing from the CSV files rather than being present but blank. Again, the missing columns differ across participants depending on their decision at a previous trial, which makes copying and pasting rows difficult. Thank you!

[wangxinyue]

Hi, Jason. A useful and detailed tutorial. But when I execute the code in Geany, it says "Syntax Error: Missing parentheses in call to 'print'". Is there somthing wrong with line 33? Thank you!

[marieley]

Hi Jason,

I was wondering if pivot table is the only function that can be used to analyze the data of psychoPy?
Are there other functions beside of pivot table that do basically the same?

Thank you very much!