Read pupil data from excel

[hanyf-psych]

Hi,

I was wondering if it could directly read pupil size data in the excel file. I recorded the pupil size data using MATLAB, and exported the data as excel file. But when I used the merge_gazer_files function, it reported an error. I have tried several methods, but I still can't solve it. The column "RECORDING_SESSION_LABEL" exist in the excel file. When I tried to use another function (read_fixation_report), it reported the same error.

[jgeller112]

Hi,

gazeR requires specific column names. You can use the make_gazer function to change the column names to match the naming conventions used by gazeR.

new_df <- make_gazer(data, subject="RECORDING_SESSION_LABEL", trial="TRIAL_INDEX", time="time", x="PUPIL_X", y="PUPIL_Y", pupil=PUPIL_SIZE)

Alternatively, you can just change these columns in the Excel spreadsheet.

[hanyf-psych]

Ok, thanks a lot for your help.

Hi,

gazeR requires specific column names. You can use the make_gazer function to change the column names to match the naming conventions used by gazeR.

new_df <- make_gazer(data, subject="RECORDING_SESSION_LABEL", trial="TRIAL_INDEX", time="time", x="PUPIL_X", y="PUPIL_Y", pupil=PUPIL_SIZE)

Alternatively, you can just change these columns in the Excel spreadsheet.

[hanyf-psych]

Hi,

I met another problem when using the make_gazer function and the baseline_correction_pupil_msg function. I'd like to know how to add a column to decribe the stimulus onset message. Thanks a lot.

[jgeller112]

The message column is something you would get from SR Data Viewer or from the EDF files themselves.

If you know the relative onset of events and know what your baseline period is then you can use the baseline_correlation_pupil function and indicate a baseline_window (eg., 500,1000) which would take the median ps between 500 ms and 1000 ms.

[jgeller112]

An earlier version of my paper (attached) covers what you would without the message column.

GazeR_final (2).pdf

[hanyf-psych]

Hi, thanks a lot, I have solved the problem by changing the column "EVENT" in the excel into "message".

[jgeller112]

I am going to close the issue but feel free to reopen it if you have other issues.