清空筛选条件
清空筛选条件

How to extract the certain range of values from array?

27 次查看（过去 30 天）
Yanjika O
Yanjika O 2020-5-17
编辑： Yanjika O 2020-5-18
Hello, I have imported two column of data from excel which also had several other columns as follows:
T=readtable('safe_1.xlsx','Sheet','safe_1','Range','H1:H23026');
t=table2array(T)';
And now I would like to have certain range of data from the imported columns. However, I could apply this when I import the data from excel, it is very time consuming when I come to repeat it 10 times in order to extract 10 ranges of data from the column.
So, I wonder is there any other way to achieve this like binning?

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2020-5-17
% Extract rows from t if value in column1 is between value1 and value2
rows = t{:, 1} > value1 & t{:, 1} < value2;
t2 = t(rows, :)

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by