Extracting a particular data from the original data

Question

sam moor 2016-11-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/312175-extracting-a-particular-data-from-the-original-data

编辑： Star Strider 2016-11-14

rd.txt

I have a data file named rd.txt attached below. 1st column data refers to time and all other columns refers the corresponding distance. Now I want to extract the data for 0.02,0.04,0.06,...60.00 sec (at a difference of 0.02) from 1st column and corresponding distances. Is there a way to extract data from the original data for a particular values? Your answer is highly appreciated. Thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-11-14

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/312175-extracting-a-particular-data-from-the-original-data#answer_243249

在 MATLAB Online 中打开

You may not be reading your data correctly.

This works for me without error:

fidi = fopen('sam moor rd.txt','rt');
Dcell = textscan(fidi, repmat('%f',1,9), 'CollectOutput',1, 'Delimiter',' ');
D = cell2mat(Dcell);
L = size(D,1);
t = D(:,1);
q = length(t > 0)/L;
ti = 0 : 0.02 : max(t);                                 % Interpolation Vector
Di = interp1(t, D(:,2:end), ti, 'linear');              % Interpolated Data

2 个评论
显示无隐藏无

sam moor 2016-11-14

roof-disp.zip

i am getting time 0,0,0...0 it should be 0.02,0.04....60 You can used this original roof-disp.out file. Its same file as rd.txt

Star Strider 2016-11-14

编辑：Star Strider 2016-11-14

在 MATLAB Online 中打开

I eliminated the first column from the ‘Di’ matrix, because that is the time vector to use for the interpolation.

Adding the ‘rd_new’ assignment will give you the complete, interpolated ‘rd’ matrix:

fidi = fopen('sam moor rd.txt','rt');
Dcell = textscan(fidi, repmat('%f',1,9), 'CollectOutput',1, 'Delimiter',' ');
D = cell2mat(Dcell);
L = size(D,1);
t = D(:,1);
ti = 0.02 : 0.02 : max(t);                              % Interpolation Vector
Di = interp1(t, D(:,2:end), ti, 'linear');              % Interpolated Data
rd_new = [ti' Di];                                      % Complete Interpolated ‘rd’ Matrix

EDIT — Corrected to begin ‘ti’ at 0.02 rather than 0.00.

请先登录，再进行评论。

Answer 2

Image Analyst 2016-11-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/312175-extracting-a-particular-data-from-the-original-data#answer_243250

I suggest you read the the FAQ on comparing floating point numbers and then use that or try a new function called ismembertol() to find out which rows match your desired times. One might think intersect() might work but because of the FAQ I referred you to, I have my doubts.