How can I find a corresponding data value to a text value?

Question

Quinty van der Heijden 2022-2-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1646535-how-can-i-find-a-corresponding-data-value-to-a-text-value

评论： dpb 2022-2-15

采纳的回答： dpb

在 MATLAB Online 中打开

I read an Excel file which contains text and numerical data. It looks like this:

For each trial I have to see whether there is a looking ('yes') and eventually add up the durations of all the yesses for each trial.

I found the correct trial with the following code:

T = readcell(BehDataParticipant2);
T_trial1 = strcmp(T, 'Trial 1');

It resulted in zeros and ones throughout the whole table. But now I don't know how to find a 'yes' and the corresponding duration in those corresponding rows. Can you help me? Thanks!

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

dpb 2022-2-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1646535-how-can-i-find-a-corresponding-data-value-to-a-text-value#answer_892450

在 MATLAB Online 中打开

tToy=readtable(BehDataParticipant2,'ReadVariableNames',1,'VariableNamingRule','preserve');
tToy.LookLeftToy=categorical(tToy.LookLeftToy);
tToySummary=groupsummary(tToy,tToy.LookLeftToy,'sum',tToy.("Duration - msec"))

6 个评论
显示 4更早的评论隐藏 4更早的评论

Quinty van der Heijden 2022-2-15

I'm sorry, was thinking too difficult. But I get it now, thanks!

dpb 2022-2-15

Understand...is easy to do when still learning one's way around in MATLAB.

I've observed it is the penchant to also want to create new, external variables from the table containing the data to work with instead of using the table reference to the data in the table directly. As a general practice, try to avoid making unneccessary copies of data you already have; there's an extensive section in the documentation on tables on how to reference table data that is invaluable and mandatory reading to use tables effectively -- and for disparate data types and convenience in higher-level coding abstraction, the table is about the alpha dog in the pack of tools available in MATLAB.

请先登录，再进行评论。

Answer 2

DGM 2022-2-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1646535-how-can-i-find-a-corresponding-data-value-to-a-text-value#answer_892430

编辑：DGM 2022-2-9

在 MATLAB Online 中打开

Create the masks only over the relevant columns. Then use a logical combination of the masks to select the entries from the first column.

T = {1180, 'Trial 1', 'yes';
     1150, 'Trial 1', [];
     860, 'Trial 1', 'yes';
     1350, 'Trial 2', 'yes';
     940, 'Trial 2', 'yes'};
maskt1 = strcmpi(T(:,2),'trial 1');
maskt2 = strcmpi(T(:,2),'trial 2');
maskyn = strcmpi(T(:,3),'yes');
maskedvalues1 = cell2mat(T(maskt1 & maskyn,1))
maskedvalues1 = 2×1
        1180
         860
maskedvalues2 = cell2mat(T(maskt2 & maskyn,1))
maskedvalues2 = 2×1
        1350
         940