Identify first instance of something in a .dat file

Question

Victoria Lawlor 2015-10-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/250428-identify-first-instance-of-something-in-a-dat-file

评论： TastyPastry 2015-10-27

I have a data file where one tab contains the picture that was presented on the screen another tab has the timestamp. Below is a really short version of what it looks like.

Dog   1ms
Dog   2ms
Dog   3ms
Cat   4ms
Cat   5ms
Cat   6ms
Dog   7ms
Dog   8ms
Dog   9ms
Cat   10ms
Cat   11ms
Cat   12ms

I need to get the rows with the first instance in the grouping (?) of that picture with the timestamp. Below is what I want to have:

Dog 1ms
Cat 4ms
Dog 7ms
Cat 10ms

I'm not sure how to go about doing this; any help would be appreciated!

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

请先登录，再进行评论。

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

Answer 1

TastyPastry 2015-10-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/250428-identify-first-instance-of-something-in-a-dat-file#answer_196997

在 MATLAB Online 中打开

fid = fopen('test.txt');
data = textscan(fid,'%s %s');
data = [data{1} data{2}];
out = data(1,:);
for i=2:numel(data(:,1))
    if ~strcmpi(data{i-1,1},data{i,1})
        out = [out;data(i,:)];
    end
end

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

Victoria Lawlor 2015-10-23

hmm thanks for replying, I'm getting an error that the index exceeds matrix dimensions. I also kind of oversimplified it when I posted the questions, there are actually four columns that I have and would need be displayed but I thought if I figured out how to do it with two I could figure out how to do it with 4, could that be the issue?

TastyPastry 2015-10-27

Did you run the test.m with test.txt? I just the script and it's working fine. I doubt it's an issue with more than 1 column, since the code limits the data it pulls to the first two.

请先登录，再进行评论。