How to remove unwanted values from an array?
2 views (last 30 days)
Show older comments
I have one array which looks like the following:
'888888888888888888880001' -40 54 181.012758165326
'888888888888888888880002' -41 155 246.860345748422
'888888888888888888880003' -38 212 297.763557297433
'888888888888888888880004' -42 335 311.493634951638
'888888888888888888880005' -44 461 325.026011960126
'888888888888888888880006' -45 706 328.152463876203
'888888888888888888880007' -41 747 317.266004051673
'888888888888888888880008' -45 941 304.192311286292
'888888888888888888880009' -39 1084 283.163508794566
'888888888888888888880010' -38 1258 313.845862098729
'888888888888888888880011' -33 29 71.2819417558447
'888888888888888888880012' -37 106 187.141362685163
'888888888888888888880013' -31 190 205.110242402620
'888888888888888888880014' -40 301 228.931473501683
'888888888888888888880015' -36 427 336.367180334263
'888888888888888888880016' -35 560 299.892770765854
'888888888888888888880017' -35 656 292.262336479084
'888888888888888888880018' -37 799 285.905285953032
'888888888888888888880019' -40 966 288.908718886324
'888888888888888888880020' -37 1060 292.824547512183
'888888888888888888880021' -30 1209 256.883485018257
I have another array which contains the information in the attached file. A sample of a few rows for formatting are as follow:
'888888888888888888880001' -66 9
'888888888888888888880001' -52 10
'888888888888888888880001' -47 20
'888888888888888888880001' -56 26
'888888888888888888880001' -47 38
'888888888888888888880001' -51 42
'888888888888888888880001' -40 47
'888888888888888888880001' -40 54
'888888888888888888880001' -51 62
'888888888888888888880001' -46 80
'888888888888888888880001' -50 85
'888888888888888888880001' -41 94
'888888888888888888880001' -52 98
'888888888888888888880001' -52 109
'888888888888888888880001' -66 141
'888888888888888888880001' -59 143
'888888888888888888880001' -46 144
'888888888888888888880001' -48 150
'888888888888888888880001' -48 159
'888888888888888888880001' -48 166
'888888888888888888880001' -57 167
'888888888888888888880001' -57 170
'888888888888888888880001' -66 199
'888888888888888888880001' -66 204
'888888888888888888880001' -53 205
'888888888888888888880001' -57 218
'888888888888888888880001' -52 224
'888888888888888888880001' -50 272
'888888888888888888880001' -59 296
'888888888888888888880001' -56 303
'888888888888888888880001' -53 350
'888888888888888888880001' -53 371
'888888888888888888880001' -57 380
'888888888888888888880001' -53 448
'888888888888888888880001' -57 464
'888888888888888888880001' -55 620
'888888888888888888880001' -60 861
See file for full list.
I am wanting to go through each row in the first array, and remove elements in the second array that do not match a criteria. The logic is as follows:
1) For row 1 in the first array, find the row in the second array which has the same first 3 columns.
2) Remove the elements in the second array if the third column in the second array is between the third column in the first array +- the value from the fourth column in the first array.
Example for the provided data:
First Row in the first array:
'888888888888888888880001' -40 54 181.012758165326
Only keep elements in the second array if the third column in the second array is between (54 - 181.012758165326) and (54 + 181.012758165326)....between -127 and 235. The resulting array would be:
'888888888888888888880001' -66 9
'888888888888888888880001' -52 10
'888888888888888888880001' -47 20
'888888888888888888880001' -56 26
'888888888888888888880001' -47 38
'888888888888888888880001' -51 42
'888888888888888888880001' -40 47
'888888888888888888880001' -40 54
'888888888888888888880001' -51 62
'888888888888888888880001' -46 80
'888888888888888888880001' -50 85
'888888888888888888880001' -41 94
'888888888888888888880001' -52 98
'888888888888888888880001' -52 109
'888888888888888888880001' -66 141
'888888888888888888880001' -59 143
'888888888888888888880001' -46 144
'888888888888888888880001' -48 150
'888888888888888888880001' -48 159
'888888888888888888880001' -48 166
'888888888888888888880001' -57 167
'888888888888888888880001' -57 170
'888888888888888888880001' -66 199
'888888888888888888880001' -66 204
'888888888888888888880001' -53 205
'888888888888888888880001' -57 218
'888888888888888888880001' -52 224
Your help would be greatly appreciated.
2 Comments
Walter Roberson
on 13 Nov 2013
Should
1) For row 1 in the first array, find the row in the second array which has the same first 3 columns.
read
1) For row 1 in the first array, find the row in the second array which has the same first 2 columns.
??
Answers (1)
Andrei Bobrov
on 13 Nov 2013
Edited: Andrei Bobrov
on 13 Nov 2013
f = fopen('C:\OneArray.txt');
ca = textscan(f,'%s %f %f %f');
fclose(f);
f = fopen('C:\Example5.txt');
data = textscan(f,'%s %f %f');
fclose(f);
lm = [ca{:,3}-ca{:,4}, ca{:,3}+ca{:,4}];
[lgc,ii] = ismember(data{1},ca{1});
idx=ii(lgc);
funa = @(x){data{3}(x) >= lm(idx(x(1)),1) & data{3}(x) <= lm(idx(x(1)),2)};
p = accumarray(idx,(1:numel(data{1}))',[],funa);
idxout = cat(1,p{:});
d1 = cellfun(@num2cell,data(2:end),'un',0);
d1 = [data{1}, cat(2,d1{:})];
out = d1(idxout,:);
10 Comments
Walter Roberson
on 15 Nov 2013
Andrei will have to answer that; I am not sure what is is trying to do there.
See Also
Categories
Find more on Matrices and Arrays in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!