how to refer an element in a column to related a value in another cloumn?

Question

Nadeera Gunartna 2016-11-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/311044-how-to-refer-an-element-in-a-column-to-related-a-value-in-another-cloumn

编辑： Nadeera Gunartna 2016-11-13

text.txt

I have a data set as attached. 6th column represent the time. I want to find the value in the 2nd Column related to "GX" in 1st column at the time "11:49:29 " I appreciate if anyone can suggest a method for this?

Thanks in advance.

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

请先登录，再进行评论。

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

Answer 1

JESUS DAVID ARIZA ROYETH 2016-11-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/311044-how-to-refer-an-element-in-a-column-to-related-a-value-in-another-cloumn#answer_242328

在 MATLAB Online 中打开

fileID = fopen('text.txt');
C = textscan(fileID,'%s %s %s %s %s %s %s','Delimiter',',');
fclose(fileID);
C=[C{:}];
value=C{and(strcmp(C(:,1),'GX'),cell2mat(cellfun(@(x) ~isempty(strfind(x,'11-49-29')),C(:,6),'UniformOutput', false))),2};
disp(value)

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Nadeera Gunartna 2016-11-13

编辑：Nadeera Gunartna 2016-11-13

Thanks for the answer. but when I run it there is an error called "Error using horzcat Dimensions of matrices being concatenated are not consistent. " So, I have to separate numeric values and character values as follows for the calculations.

rawNumericColumns = raw(:, [2,3,4,5,6]);

rawCellColumns = raw(:, 1);

v = rawCellColumns(:, 1);

D1 = cell2mat(rawNumericColumns(:, 1));

D2 = cell2mat(rawNumericColumns(:, 2));

D3 = cell2mat(rawNumericColumns(:, 3));

D4 = cell2mat(rawNumericColumns(:, 4));

t = cell2mat(rawNumericColumns(:, 5));

now I can not combine these all as one ( like you suggest as "C"). so, is there anyway to refer the values in numeric columns related to that character array values?

请先登录，再进行评论。