필터 지우기
필터 지우기

how to filter a table by the dataset of another table

조회 수: 5 (최근 30일)
mor zarfati
mor zarfati 2015년 5월 3일
답변: Peter Perkins 2015년 5월 5일
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

답변 (2개)

Image Analyst
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.
  댓글 수: 1
mor zarfati
mor zarfati 2015년 5월 5일
편집: mor zarfati 2015년 5월 5일
Im actually new to MATLAB so Im not familliare with tis code. i believe i am working with cell arrays(except for the third table -double)

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


Peter Perkins
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.

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by