how to filter a table by the dataset of another table
8 次查看(过去 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 中查找有关 Descriptive Statistics and Visualization 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!