how to filter a table by the dataset of another table
조회 수: 5 (최근 30일)
이전 댓글 표시
I have 3 tables/one with names of genes that i want to learnabout their level of expression. a second table with the names of all the different genes(many that i dont need) and a third table that acourding to the same order of my second table(same value) shows the level of expression in different rats(rows of numbers). how do I make a new table with only the rows i need in the third table(of the list og genes in the first table)? thanks
댓글 수: 0
답변 (2개)
Image Analyst
2015년 5월 3일
What form do these tables have? Are they official "Table" class variables in MATLAB? Numbers in a regular double numerical array, or cell array? Data stored in a text file or Excel workbook?
Do you know how to make a logical vector to select rows:
rowsIWant = data(:, columnToLookAt) < someNumber;
extractedData = data(rowsIWant, :); % Extract rows meeting criteria.
Peter Perkins
2015년 5월 5일
You probably need to give a concrete example of your data and your desired result, but in general terms, you can use the intersect function. This will work on strings, on doubles, and most particularly on tables, if by "I have 3 tables" you mean, "I have three variables whos class is 'table'".
Hope this helps.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Tables에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!