Info
이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.
Row selection from Cell contains 417 *11 elements
조회 수: 1 (최근 30일)
이전 댓글 표시
I have an excel file. I read using xlsread and the variable named alldata contains 417*11 in cell format. Here I want to select only 178 rows which depends on the first column of the cell contains 'OAS1_0001_MR1'
'OAS1_0002_MR1'
'OAS1_0003_MR1'
'OAS1_0004_MR1'
'OAS1_0005_MR1'
'OAS1_0006_MR1'
'OAS1_0007_MR1'
'OAS1_0009_MR1'
'OAS1_0010_MR1'
'OAS1_0011_MR1' etc.
Can anyone please help me to find a solution. Thanks in Advance.
댓글 수: 2
Jan
2015년 7월 22일
The question is not clear: How do you decide which rows are wanted and which are not? What is the pattern?
답변 (1개)
Walter Roberson
2015년 7월 23일
tf = ismember(DataFromExcel(:,1), 'OAS1_0001_MR1');
subset = DataFromExcel(tf,:);
댓글 수: 0
이 질문은 마감되었습니다.
참고 항목
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!