Return rows (not just row number)

조회 수: 23 (최근 30일)
Snowfall
Snowfall 2016년 1월 29일
편집: Snowfall 2016년 2월 7일
Hello
I would be happy if anyone could help me with following problem.
I have an text (or excel) file which is in the following form (or course in reality it is in larger form but anyway the basic idea is):
And now I would like to find all the 'Cat'-rows and return that row and the following row.
So in the end my answer should be
And I don't even know how to begin. Could anyone help?

채택된 답변

Ingrid
Ingrid 2016년 1월 29일
just use strfind or strcmp to find the indices
varNames = var(:,1);
IndexC = strfind(varNames, 'Cat');
Index = find(not(cellfun('isempty', IndexC)));
Index = sort([Index; Index+1]);
extracted = var(Index,:);

추가 답변 (3개)

Walter Roberson
Walter Roberson 2016년 1월 29일
match = ismember(var(:,1), 'Cat');
extended_match = match | [true; match(1:end-1)]; %row and following row; and also header
extracted = var(extended_match, :);

Snowfall
Snowfall 2016년 1월 29일
편집: Snowfall 2016년 1월 29일
Thank you, these help me a lot :)
But it also raised a new question... What should I do if i want to find a word which contains word 'Cat'. For example in that table (above) I would have words 'TigerCat' and 'LionCat' instead of just 'Cat' (like in previous question) and I would like to return all rows which contains 'Cat'?
Is Matlab capable of doing that?
  댓글 수: 2
Walter Roberson
Walter Roberson 2016년 1월 30일
Ingrid's strfind solution will find 'Cat' anywhere in the string. It is, though, case sensitive. If you want a case-insensitive solution then you could use Ingrid's solution modified slightly to
IndexC = strfind(lower(varNames), lower('Cat'));
The function I used, ismember(), does not extend to locating strings within other strings. I would probably modify my solution to
match = ~cellfun(@isempty,regexpi(varNames,'Cat'));
Snowfall
Snowfall 2016년 2월 3일
Thank you for your answer. I begin to try these in practice.

댓글을 달려면 로그인하십시오.


Snowfall
Snowfall 2016년 2월 5일
How about a case where I would like to find all words which do not include 'Cat' or 'Guinea pig'?
  댓글 수: 2
Ingrid
Ingrid 2016년 2월 5일
it is better if you make a new question for this as this one already has an accepted answer so you are less likely to get an answer but here goes:
varNames = var(:,1);
IndexCat = strfind(varNames, 'Cat');
Index1 = find(not(cellfun('isempty', IndexCat)));
IndexPig = strfind(varNames,'Guinea pig');
Index2= find(not(cellfun('isempty',IndexPig)));
Index =~(Index1|Index2);
Index = sort([Index; Index+1]);
extracted = var(Index,:);
Snowfall
Snowfall 2016년 2월 7일
편집: Snowfall 2016년 2월 7일
Ok, thank you for your answer. Next time I'll write a new question :)

댓글을 달려면 로그인하십시오.

카테고리

Help CenterFile Exchange에서 Characters and Strings에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by