Adding data from table into struct

3 次查看（过去 30 天）
DavidL88
DavidL88 2021-2-6
编辑： DavidL88 2021-2-11
Hi
I'm looking for a way to sum data in a table with data in a struct. The data in the table has to be matched with the data in the struct. I have data from a cognitive task stored in a 1x59 struct 'sFiles' (there were 59 subjects who completed the task). This task has 4 categories (original_11, original_12, original_21 & original_22), each with a timestamp of when it occurred (100 trials per category so a total of 400 trials per subject). The Subject IDs are listed under sFiles.SubjectName. In the script below, the 4 variables beginning with 'original' are each 1x100 doubles, extracted from struct sFiles, and contain the timestamps for each event for one subject. The timestamps within each one are listed sequentially in the 1x100 doubles, so first column is first trial, fifth column is fifth trial, etc.
The timestamps for these trials need to be corrected for a delay, so I need to add on a small amount of time to each one. This delay varies from trial/timestamp to trial/timestamp. I have the delay for each trial for each subject stored in a table 'T'. T.Subject has all subject IDs (400 rows for each subject), T.Conditions has the event category (11, 12, 21 & 22 (100 rows per category per subject)), T.Trial lists the number of the trial in each category (1-100) and T.Delay has all the delays that the 'original' in the struct has to corrected for (by summing them).
sFiles = bst_process('CallProcess', 'process_select_search', sFiles, [], ...
'search', '(([name CONTAINS "resample"]))');
for iFile = 1:length(sFiles)
DataMat = in_bst_data(sFiles(iFile).FileName);
original_11 = DataMat.F.events(1).times
original_12 = DataMat.F.events(2).times
original_21 = DataMat.F.events(5).times
original_22 = DataMat.F.events(6).times
end
This is an example of a few rows from the table
T =
Subject Conditions Trial Delay
"Subject008" 11 95 83
"Subject121" 12 96 84
"Subject156" 21 97 67
"Subject356" 22 98 67
Is there a way to match Subject, Conditions and Trials between the struct and Table so I can add the delays to the timestamps correctly?

请先登录，再回答此问题。

回答（1 个）

Image Analyst
Image Analyst 2021-2-6
I didn't delve in your data (we don't even have any of it) or your code but you might want to look at grpstats() or splitapply() to do computations by groups. You might also find the functions vertcat(), struct2table(), table2struct(), or findgroups() useful.
  3 个评论
显示 1更早的评论
Image Analyst
Image Analyst 2021-2-7
Can you attach a small sample of the structure and table in a .mat file with the paper clip icon so we have something to work with? Make it easy for us to help you , not hard.
save('answers.mat', 'myTable', 'myStructure');
TUTORIAL: How to ask a question (on Answers) and get a fast answer
DavidL88
DavidL88 2021-2-8
编辑：DavidL88 2021-2-11
I attach a sample struct (A) and table (t).
In A.events.times, the 1x100 double in rows 1, 2, 5, 6 each contain the timestamps for 100 trials across 4 conditions to be altered, corresponding with conditions 11, 12, 21, and 22 listed under 'ConditionsWhole_sample' in the table. So row 1 is 11 list in the table, row 2 is 12, row 5 is 21 and row 6 is 22. The 100 timestamps are entered sequentially in these 1x100 doubles and they correspond with the 1-100 trials which are listed sequentially under 'trial' in the table.
I need to add the values listed under 'delay' in the table to the values listed in these 1x100 double and so correct the timestamps saved here but matched for Subject (ID), Condition (11, 12, 21, 22) and trial (1-100).
Please let me know if any further information is needed.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by