how to store data based on range?

Question

sivalogan satchithanandamoorthy 2017-6-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/346281-how-to-store-data-based-on-range

评论： Jan 2017-6-27

I have 25by1000 matrix in excel file. i want plot cyclic stress strain graph based on time range . example, I want to check using loop between time 10 to 100 and plot stress and strain in those range. time does not have regular increment parent. time value in sec (ex) 2.146 2.1505 2.1545 2.159 2.163 2.167 2.1715 2.1755 2.1795 2.184 2.188 2.192 2.1965 2.2005 2.2045 2.209. Any help would be much appreciated.

siva

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jan 2017-6-26

The question is not clear. Did you import the data to Matlab already, or is this a part of the problem?

请先登录，再进行评论。

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

Answer 1

Jan 2017-6-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/346281-how-to-store-data-based-on-range#answer_271984

编辑：Jan 2017-6-26

在 MATLAB Online 中打开

Assuming that the time is stored in the 1st column and the value in the 2nd:

Index = Num(:, 1) > 10 & Num(:, 1) < 100;
Time  = Num(Index, 1);
Value = Num(Index, 2);

But I'm not sure if this solves your problem.

2 个评论
显示无隐藏无

sivalogan satchithanandamoorthy 2017-6-27

I could use the comment to solve the problem, but could you explain your code to me? when i used your code, what happening is between the range 10 to 100, if the values fall between them then it assign 1, if not 0. explanation would be wonderful. thank you

Jan 2017-6-27

Num(:, 1) > 10 is a logical index vector, which is TRUE if the corresüponding value of Num is greater than 10.
Num(:, 1) < 100 the same, with TRUR if Num is greater smaller than 100.
The & combines the logical vectors. Now it is TRUE, if both conditions are TRUE.
Num(Index, 1) is the subvector of Num(:,1), which contains only the elements, which are inside the searched range.
Same foe Value.