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

1 次查看（过去 30 天）
Quinty van der Heijden
评论： dpb 2022-2-15
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!

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

采纳的回答

dpb
dpb 2022-2-9
tToy=readtable(BehDataParticipant2,'ReadVariableNames',1,'VariableNamingRule','preserve');
tToy.LookLeftToy=categorical(tToy.LookLeftToy);
tToySummary=groupsummary(tToy,tToy.LookLeftToy,'sum',tToy.("Duration - msec"))
  6 个评论
显示 4更早的评论
dpb
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.

请先登录，再进行评论。

更多回答（1 个）

DGM
DGM 2022-2-9
编辑：DGM 2022-2-9
Ran in:
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

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by