Based on Column 3 values how to get specific column 1 values?

1 次查看（过去 30 天）

raghavendra kandukuri 2018-10-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/425702-based-on-column-3-values-how-to-get-specific-column-1-values

评论： jonas 2018-10-24

sample.txt

I have 3 columns of data coming from excel, Please find attached txt file, for instance in the attached txt file when column C is '0', i would like to get the value of column A at that point and the two more values above it i.e 2301,2300,2244 in the attached file.

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

请先登录，再进行评论。

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

采纳的回答

jonas 2018-10-23

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/425702-based-on-column-3-values-how-to-get-specific-column-1-values#answer_343023

编辑：jonas 2018-10-24

在 MATLAB Online 中打开

fid = fopen('sample.txt')
out = textscan(fid,'%f%f%f','headerlines',1);
fclose(fid)
A = cell2mat(out);
id0 = find(A(:,3) == 0);
idc = [id0,id0-1,id0-2];
idc = unique(idc) 
idc(idc<1) = [];
A(idc, 1)