I need code for processing of table data

I have a table of values I need in it only those rows of values for which the values of the number in the second column are at a distance of 0.0001 (plus or minus 0.00009) from each other. How to implement this in matlab?

[Walter Roberson]

That is not clear. Should the 2.1169 on row 7 be grouped with the 2.1168's on row 8 and 9, and should the group also include the 2.1167 of row 10, on the basis that each row in the group would be within the specific distance from at least one other row in the group ?

So should the groups be divided into distinct subsets each of which exclude all entries that are more than the specified distance from some member of the group?

Or is the grouping to be such that the members of any one group are all within the specified distance from each other? And if so, then what should you do with A B C if B is within the specified distance from A, and B is within the specified distance from C but C is too far from A? Should that lead to the creation of two groups, [A, B] and [B,C] ??

[Dmitry]

I will try to explain with an example:

we start from B2, if mod(B2 - B3) < 0.404 we delete A3B3 and continue to compare B2 with B(i), if B2 - B(i) >= 0.404 we leave this element (A(i)B(i)) fixed on it and similarly move down the table.

I attached the table to the comment

[Dmitry]

Walter Roberson, as a result, we should get a shortened table, as I wrote above.

Answer 1

[Oguz Kaan Hancioglu]

After reading the excel, you can use the diff command to find the difference between elements of an array. Please note that since diff (diff(x)) finds the difference the array length is equal = length(x) -1. You may need to add 1 to find the real location. You can see the result. You can arrange your condition for your problem.

load('Data_vector.mat')
diffVec = abs(diff(c(:,2))) ;
find(diffVec <= 0.0001)

ans = 1770×1

2 3 4 5 6 7 8 9 10 11

[Dmitry]

Why does your code output prime numbers? Where there is a function for deleting elements in it.

[Walter Roberson]

4, 6, 8, 9, 10 are not prime numbers??

Or are you saying that you expect that the mathematics work out such that 2, 3, 7, and 11 will never be detected by the algorithm ?

[Walter Roberson]

Index the data at the result of find() to get the shorter table.

[Oguz Kaan Hancioglu]

In addition you can create custom conditions for your needs. For example, in order to find the values between 0.00009 and 0.0001 you can imply following code,

load('Data_vector.mat')
diffVec = abs(diff(c(:,2))) ;
xVector = diffVec <= 0.0001;
yVector = diffVec > 0.00009;
desiredVector = and(xVector,yVector);
for i = 1:length(desiredVector)
    if (desiredVector(i))
        fprintf('%d \t index: %f \t %f table element distance smaller than previous one.\n',i,c(i,1),c(i,2));
    end
end

139 	 index: 1.482164 	 2.240678 table element distance smaller than previous one.
140 	 index: 1.478357 	 2.240587 table element distance smaller than previous one.
141 	 index: 1.474549 	 2.240497 table element distance smaller than previous one.
142 	 index: 1.470741 	 2.240406 table element distance smaller than previous one.
143 	 index: 1.466934 	 2.240315 table element distance smaller than previous one.
144 	 index: 1.463126 	 2.240224 table element distance smaller than previous one.
145 	 index: 1.459319 	 2.240133 table element distance smaller than previous one.
146 	 index: 1.455511 	 2.240042 table element distance smaller than previous one.
147 	 index: 1.451703 	 2.239952 table element distance smaller than previous one.
148 	 index: 1.447896 	 2.239861 table element distance smaller than previous one.
150 	 index: 1.440281 	 2.253001 table element distance smaller than previous one.
151 	 index: 1.436473 	 2.252908 table element distance smaller than previous one.
152 	 index: 1.432665 	 2.252815 table element distance smaller than previous one.
153 	 index: 1.428858 	 2.252723 table element distance smaller than previous one.
154 	 index: 1.425050 	 2.252630 table element distance smaller than previous one.
155 	 index: 1.421242 	 2.252537 table element distance smaller than previous one.
156 	 index: 1.417435 	 2.252444 table element distance smaller than previous one.
157 	 index: 1.413627 	 2.252351 table element distance smaller than previous one.
158 	 index: 1.409820 	 2.252258 table element distance smaller than previous one.
159 	 index: 1.406012 	 2.252165 table element distance smaller than previous one.
161 	 index: 1.398397 	 2.264796 table element distance smaller than previous one.
162 	 index: 1.394589 	 2.264701 table element distance smaller than previous one.
163 	 index: 1.390782 	 2.264606 table element distance smaller than previous one.
164 	 index: 1.386974 	 2.264511 table element distance smaller than previous one.
165 	 index: 1.383166 	 2.264416 table element distance smaller than previous one.
166 	 index: 1.379359 	 2.264321 table element distance smaller than previous one.
167 	 index: 1.375551 	 2.264227 table element distance smaller than previous one.
168 	 index: 1.371743 	 2.264132 table element distance smaller than previous one.
169 	 index: 1.367936 	 2.264037 table element distance smaller than previous one.
171 	 index: 1.360321 	 2.276192 table element distance smaller than previous one.
172 	 index: 1.356513 	 2.276095 table element distance smaller than previous one.
173 	 index: 1.352705 	 2.275998 table element distance smaller than previous one.
174 	 index: 1.348898 	 2.275901 table element distance smaller than previous one.
175 	 index: 1.345090 	 2.275804 table element distance smaller than previous one.
176 	 index: 1.341283 	 2.275707 table element distance smaller than previous one.
177 	 index: 1.337475 	 2.275610 table element distance smaller than previous one.
178 	 index: 1.333667 	 2.275513 table element distance smaller than previous one.
180 	 index: 1.326052 	 2.287223 table element distance smaller than previous one.
181 	 index: 1.322244 	 2.287124 table element distance smaller than previous one.
182 	 index: 1.318437 	 2.287025 table element distance smaller than previous one.
183 	 index: 1.314629 	 2.286926 table element distance smaller than previous one.
184 	 index: 1.310822 	 2.286828 table element distance smaller than previous one.
185 	 index: 1.307014 	 2.286729 table element distance smaller than previous one.
186 	 index: 1.303206 	 2.286630 table element distance smaller than previous one.
187 	 index: 1.299399 	 2.286531 table element distance smaller than previous one.
1249 	 index: 0.594990 	 3.841536 table element distance smaller than previous one.
1251 	 index: 0.587375 	 3.844851 table element distance smaller than previous one.
1253 	 index: 0.579760 	 3.848118 table element distance smaller than previous one.
3340 	 index: 0.914830 	 7.358595 table element distance smaller than previous one.
3341 	 index: 0.918637 	 7.358505 table element distance smaller than previous one.
3352 	 index: 0.960521 	 7.367455 table element distance smaller than previous one.
3354 	 index: 0.968136 	 7.372911 table element distance smaller than previous one.
3365 	 index: 1.010020 	 7.382609 table element distance smaller than previous one.
3366 	 index: 1.013828 	 7.382519 table element distance smaller than previous one.
3367 	 index: 1.017635 	 7.382428 table element distance smaller than previous one.
3370 	 index: 1.029058 	 7.385957 table element distance smaller than previous one.
3371 	 index: 1.032866 	 7.385867 table element distance smaller than previous one.
3375 	 index: 1.048096 	 7.389418 table element distance smaller than previous one.
3378 	 index: 1.059519 	 7.392784 table element distance smaller than previous one.
3379 	 index: 1.063327 	 7.392694 table element distance smaller than previous one.
3381 	 index: 1.070942 	 7.396562 table element distance smaller than previous one.
3382 	 index: 1.074749 	 7.396471 table element distance smaller than previous one.
3383 	 index: 1.078557 	 7.396381 table element distance smaller than previous one.
3384 	 index: 1.082365 	 7.396290 table element distance smaller than previous one.
3385 	 index: 1.086172 	 7.396200 table element distance smaller than previous one.
3387 	 index: 1.093788 	 7.400193 table element distance smaller than previous one.
3388 	 index: 1.097595 	 7.400103 table element distance smaller than previous one.
3389 	 index: 1.101403 	 7.400013 table element distance smaller than previous one.
3394 	 index: 1.120441 	 7.407750 table element distance smaller than previous one.
3395 	 index: 1.124248 	 7.407659 table element distance smaller than previous one.
3396 	 index: 1.128056 	 7.407568 table element distance smaller than previous one.
3397 	 index: 1.131864 	 7.407477 table element distance smaller than previous one.
3398 	 index: 1.135671 	 7.407387 table element distance smaller than previous one.
3399 	 index: 1.139479 	 7.407296 table element distance smaller than previous one.
3401 	 index: 1.147094 	 7.411583 table element distance smaller than previous one.
3402 	 index: 1.150902 	 7.411493 table element distance smaller than previous one.
3403 	 index: 1.154709 	 7.411402 table element distance smaller than previous one.
3404 	 index: 1.158517 	 7.411312 table element distance smaller than previous one.
3409 	 index: 1.177555 	 7.419615 table element distance smaller than previous one.
3410 	 index: 1.181363 	 7.419523 table element distance smaller than previous one.
3411 	 index: 1.185170 	 7.419432 table element distance smaller than previous one.
3412 	 index: 1.188978 	 7.419341 table element distance smaller than previous one.
3413 	 index: 1.192786 	 7.419251 table element distance smaller than previous one.
3415 	 index: 1.200401 	 7.423869 table element distance smaller than previous one.
3416 	 index: 1.204208 	 7.423778 table element distance smaller than previous one.
3417 	 index: 1.208016 	 7.423687 table element distance smaller than previous one.
3418 	 index: 1.211824 	 7.423597 table element distance smaller than previous one.
3419 	 index: 1.215631 	 7.423506 table element distance smaller than previous one.
3420 	 index: 1.219439 	 7.423416 table element distance smaller than previous one.
3423 	 index: 1.230862 	 7.428111 table element distance smaller than previous one.
3424 	 index: 1.234669 	 7.428021 table element distance smaller than previous one.
3428 	 index: 1.249900 	 7.432087 table element distance smaller than previous one.
3429 	 index: 1.253707 	 7.431996 table element distance smaller than previous one.
3431 	 index: 1.261323 	 7.436989 table element distance smaller than previous one.
3432 	 index: 1.265130 	 7.436898 table element distance smaller than previous one.
3433 	 index: 1.268938 	 7.436807 table element distance smaller than previous one.
3434 	 index: 1.272745 	 7.436716 table element distance smaller than previous one.
3435 	 index: 1.276553 	 7.436625 table element distance smaller than previous one.
3436 	 index: 1.280361 	 7.436535 table element distance smaller than previous one.
3437 	 index: 1.284168 	 7.436444 table element distance smaller than previous one.
3438 	 index: 1.287976 	 7.436354 table element distance smaller than previous one.
3440 	 index: 1.295591 	 7.441538 table element distance smaller than previous one.
3441 	 index: 1.299399 	 7.441447 table element distance smaller than previous one.
3442 	 index: 1.303206 	 7.441357 table element distance smaller than previous one.
3443 	 index: 1.307014 	 7.441266 table element distance smaller than previous one.
3449 	 index: 1.329860 	 7.451088 table element distance smaller than previous one.
3450 	 index: 1.333667 	 7.450997 table element distance smaller than previous one.
3451 	 index: 1.337475 	 7.450906 table element distance smaller than previous one.
3452 	 index: 1.341283 	 7.450815 table element distance smaller than previous one.
3453 	 index: 1.345090 	 7.450724 table element distance smaller than previous one.
3454 	 index: 1.348898 	 7.450633 table element distance smaller than previous one.
3455 	 index: 1.352705 	 7.450542 table element distance smaller than previous one.
3456 	 index: 1.356513 	 7.450452 table element distance smaller than previous one.
3458 	 index: 1.364128 	 7.456091 table element distance smaller than previous one.
3459 	 index: 1.367936 	 7.456001 table element distance smaller than previous one.
3460 	 index: 1.371743 	 7.455910 table element distance smaller than previous one.
3461 	 index: 1.375551 	 7.455819 table element distance smaller than previous one.
3462 	 index: 1.379359 	 7.455729 table element distance smaller than previous one.
3463 	 index: 1.383166 	 7.455639 table element distance smaller than previous one.
3473 	 index: 1.421242 	 7.465977 table element distance smaller than previous one.
3474 	 index: 1.425050 	 7.465886 table element distance smaller than previous one.
3475 	 index: 1.428858 	 7.465795 table element distance smaller than previous one.
3476 	 index: 1.432665 	 7.465704 table element distance smaller than previous one.
3477 	 index: 1.436473 	 7.465614 table element distance smaller than previous one.
3479 	 index: 1.444088 	 7.471779 table element distance smaller than previous one.
3480 	 index: 1.447896 	 7.471688 table element distance smaller than previous one.
3481 	 index: 1.451703 	 7.471598 table element distance smaller than previous one.
3482 	 index: 1.455511 	 7.471507 table element distance smaller than previous one.
3483 	 index: 1.459319 	 7.471417 table element distance smaller than previous one.
3484 	 index: 1.463126 	 7.471326 table element distance smaller than previous one.
3490 	 index: 1.485972 	 7.477401 table element distance smaller than previous one.
3491 	 index: 1.489780 	 7.477311 table element distance smaller than previous one.
3502 	 index: 1.531663 	 7.488926 table element distance smaller than previous one.
3503 	 index: 1.535471 	 7.488835 table element distance smaller than previous one.
3504 	 index: 1.539279 	 7.488744 table element distance smaller than previous one.
3505 	 index: 1.543086 	 7.488653 table element distance smaller than previous one.
3506 	 index: 1.546894 	 7.488563 table element distance smaller than previous one.
3507 	 index: 1.550701 	 7.488472 table element distance smaller than previous one.
3508 	 index: 1.554509 	 7.488382 table element distance smaller than previous one.
3515 	 index: 1.581162 	 7.495025 table element distance smaller than previous one.
3827 	 index: 0.796794 	 8.525060 table element distance smaller than previous one.
3836 	 index: 0.831062 	 8.533875 table element distance smaller than previous one.
3838 	 index: 0.838677 	 8.536929 table element distance smaller than previous one.
3839 	 index: 0.842485 	 8.536838 table element distance smaller than previous one.
3840 	 index: 0.846293 	 8.536746 table element distance smaller than previous one.
3842 	 index: 0.853908 	 8.539876 table element distance smaller than previous one.
3843 	 index: 0.857715 	 8.539784 table element distance smaller than previous one.
3845 	 index: 0.865331 	 8.542993 table element distance smaller than previous one.
3847 	 index: 0.872946 	 8.545219 table element distance smaller than previous one.
3849 	 index: 0.880561 	 8.549736 table element distance smaller than previous one.
3850 	 index: 0.884369 	 8.549642 table element distance smaller than previous one.
3851 	 index: 0.888176 	 8.549549 table element distance smaller than previous one.
3852 	 index: 0.891984 	 8.549456 table element distance smaller than previous one.
3854 	 index: 0.899599 	 8.552848 table element distance smaller than previous one.
3855 	 index: 0.903407 	 8.552755 table element distance smaller than previous one.
3856 	 index: 0.907214 	 8.552661 table element distance smaller than previous one.
3858 	 index: 0.914830 	 8.556144 table element distance smaller than previous one.
3860 	 index: 0.922445 	 8.558272 table element distance smaller than previous one.
3863 	 index: 0.933868 	 8.563330 table element distance smaller than previous one.
3864 	 index: 0.937675 	 8.563235 table element distance smaller than previous one.
3865 	 index: 0.941483 	 8.563141 table element distance smaller than previous one.
3867 	 index: 0.949098 	 8.566834 table element distance smaller than previous one.
3868 	 index: 0.952906 	 8.566739 table element distance smaller than previous one.
3869 	 index: 0.956713 	 8.566645 table element distance smaller than previous one.
3870 	 index: 0.960521 	 8.566550 table element distance smaller than previous one.
3872 	 index: 0.968136 	 8.570348 table element distance smaller than previous one.
3874 	 index: 0.975752 	 8.572343 table element distance smaller than previous one.
3875 	 index: 0.979559 	 8.572250 table element distance smaller than previous one.
3877 	 index: 0.987174 	 8.576085 table element distance smaller than previous one.
3879 	 index: 0.994790 	 8.577962 table element distance smaller than previous one.
3880 	 index: 0.998597 	 8.577865 table element distance smaller than previous one.
3882 	 index: 1.006212 	 8.581908 table element distance smaller than previous one.
3883 	 index: 1.010020 	 8.581811 table element distance smaller than previous one.
3884 	 index: 1.013828 	 8.581715 table element distance smaller than previous one.
3885 	 index: 1.017635 	 8.581619 table element distance smaller than previous one.
3886 	 index: 1.021443 	 8.581523 table element distance smaller than previous one.
3888 	 index: 1.029058 	 8.585686 table element distance smaller than previous one.
3889 	 index: 1.032866 	 8.585590 table element distance smaller than previous one.
3891 	 index: 1.040481 	 8.587410 table element distance smaller than previous one.
3893 	 index: 1.048096 	 8.591615 table element distance smaller than previous one.
3894 	 index: 1.051904 	 8.591520 table element distance smaller than previous one.
3895 	 index: 1.055711 	 8.591426 table element distance smaller than previous one.
3897 	 index: 1.063327 	 8.593824 table element distance smaller than previous one.
3899 	 index: 1.070942 	 8.598274 table element distance smaller than previous one.
3900 	 index: 1.074749 	 8.598176 table element distance smaller than previous one.
3901 	 index: 1.078557 	 8.598079 table element distance smaller than previous one.
3902 	 index: 1.082365 	 8.597981 table element distance smaller than previous one.
3903 	 index: 1.086172 	 8.597884 table element distance smaller than previous one.
3905 	 index: 1.093788 	 8.602475 table element distance smaller than previous one.
3906 	 index: 1.097595 	 8.602378 table element distance smaller than previous one.
3907 	 index: 1.101403 	 8.602281 table element distance smaller than previous one.
3908 	 index: 1.105210 	 8.602183 table element distance smaller than previous one.
3910 	 index: 1.112826 	 8.603768 table element distance smaller than previous one.
3912 	 index: 1.120441 	 8.608404 table element distance smaller than previous one.
3913 	 index: 1.124248 	 8.608309 table element distance smaller than previous one.
3914 	 index: 1.128056 	 8.608213 table element distance smaller than previous one.
3915 	 index: 1.131864 	 8.608118 table element distance smaller than previous one.
3917 	 index: 1.139479 	 8.611163 table element distance smaller than previous one.
3919 	 index: 1.147094 	 8.616092 table element distance smaller than previous one.
3920 	 index: 1.150902 	 8.615994 table element distance smaller than previous one.
3921 	 index: 1.154709 	 8.615895 table element distance smaller than previous one.
3922 	 index: 1.158517 	 8.615797 table element distance smaller than previous one.
3923 	 index: 1.162325 	 8.615699 table element distance smaller than previous one.
3924 	 index: 1.166132 	 8.615601 table element distance smaller than previous one.
3926 	 index: 1.173747 	 8.620698 table element distance smaller than previous one.
3927 	 index: 1.177555 	 8.620599 table element distance smaller than previous one.
3928 	 index: 1.181363 	 8.620501 table element distance smaller than previous one.
3929 	 index: 1.185170 	 8.620403 table element distance smaller than previous one.
3931 	 index: 1.192786 	 8.621670 table element distance smaller than previous one.
3933 	 index: 1.200401 	 8.626817 table element distance smaller than previous one.
3934 	 index: 1.204208 	 8.626721 table element distance smaller than previous one.
3935 	 index: 1.208016 	 8.626625 table element distance smaller than previous one.
3936 	 index: 1.211824 	 8.626529 table element distance smaller than previous one.
3937 	 index: 1.215631 	 8.626434 table element distance smaller than previous one.
3938 	 index: 1.219439 	 8.626338 table element distance smaller than previous one.
3939 	 index: 1.223246 	 8.626243 table element distance smaller than previous one.
3941 	 index: 1.230862 	 8.635791 table element distance smaller than previous one.
3942 	 index: 1.234669 	 8.635692 table element distance smaller than previous one.
3943 	 index: 1.238477 	 8.635592 table element distance smaller than previous one.
3944 	 index: 1.242285 	 8.635493 table element distance smaller than previous one.
3945 	 index: 1.246092 	 8.635394 table element distance smaller than previous one.
3946 	 index: 1.249900 	 8.635295 table element distance smaller than previous one.
3947 	 index: 1.253707 	 8.635196 table element distance smaller than previous one.
3949 	 index: 1.261323 	 8.640900 table element distance smaller than previous one.
3950 	 index: 1.265130 	 8.640800 table element distance smaller than previous one.
3951 	 index: 1.268938 	 8.640701 table element distance smaller than previous one.
3952 	 index: 1.272745 	 8.640602 table element distance smaller than previous one.
3953 	 index: 1.276553 	 8.640504 table element distance smaller than previous one.
3954 	 index: 1.280361 	 8.640405 table element distance smaller than previous one.
3956 	 index: 1.287976 	 8.641245 table element distance smaller than previous one.
3958 	 index: 1.295591 	 8.647003 table element distance smaller than previous one.
3959 	 index: 1.299399 	 8.646906 table element distance smaller than previous one.
3960 	 index: 1.303206 	 8.646810 table element distance smaller than previous one.
3961 	 index: 1.307014 	 8.646714 table element distance smaller than previous one.
3962 	 index: 1.310822 	 8.646619 table element distance smaller than previous one.
3963 	 index: 1.314629 	 8.646523 table element distance smaller than previous one.
3964 	 index: 1.318437 	 8.646428 table element distance smaller than previous one.
3965 	 index: 1.322244 	 8.646333 table element distance smaller than previous one.
3967 	 index: 1.329860 	 8.652309 table element distance smaller than previous one.
3969 	 index: 1.337475 	 8.657400 table element distance smaller than previous one.
3970 	 index: 1.341283 	 8.657300 table element distance smaller than previous one.
3971 	 index: 1.345090 	 8.657200 table element distance smaller than previous one.
3972 	 index: 1.348898 	 8.657100 table element distance smaller than previous one.
3973 	 index: 1.352705 	 8.657001 table element distance smaller than previous one.
3974 	 index: 1.356513 	 8.656901 table element distance smaller than previous one.
3976 	 index: 1.364128 	 8.663341 table element distance smaller than previous one.
3977 	 index: 1.367936 	 8.663241 table element distance smaller than previous one.
3978 	 index: 1.371743 	 8.663142 table element distance smaller than previous one.
3979 	 index: 1.375551 	 8.663042 table element distance smaller than previous one.
3980 	 index: 1.379359 	 8.662943 table element distance smaller than previous one.
3981 	 index: 1.383166 	 8.662843 table element distance smaller than previous one.
3982 	 index: 1.386974 	 8.662744 table element distance smaller than previous one.
3983 	 index: 1.390782 	 8.662646 table element distance smaller than previous one.
3984 	 index: 1.394589 	 8.662547 table element distance smaller than previous one.
3986 	 index: 1.402204 	 8.669499 table element distance smaller than previous one.
3987 	 index: 1.406012 	 8.669403 table element distance smaller than previous one.
3988 	 index: 1.409820 	 8.669306 table element distance smaller than previous one.
3989 	 index: 1.413627 	 8.669210 table element distance smaller than previous one.
3990 	 index: 1.417435 	 8.669114 table element distance smaller than previous one.
3991 	 index: 1.421242 	 8.669019 table element distance smaller than previous one.
3992 	 index: 1.425050 	 8.668923 table element distance smaller than previous one.
3993 	 index: 1.428858 	 8.668828 table element distance smaller than previous one.
3994 	 index: 1.432665 	 8.668732 table element distance smaller than previous one.
3995 	 index: 1.436473 	 8.668637 table element distance smaller than previous one.
3997 	 index: 1.444088 	 8.675404 table element distance smaller than previous one.
3998 	 index: 1.447896 	 8.675309 table element distance smaller than previous one.
3999 	 index: 1.451703 	 8.675213 table element distance smaller than previous one.
4000 	 index: 1.455511 	 8.675118 table element distance smaller than previous one.
4001 	 index: 1.459319 	 8.675022 table element distance smaller than previous one.
6048 	 index: 1.310822 	 15.326468 table element distance smaller than previous one.
7688 	 index: 1.219439 	 24.340953 table element distance smaller than previous one.
9098 	 index: 1.105210 	 35.738420 table element distance smaller than previous one.
9802 	 index: 0.987174 	 42.516263 table element distance smaller than previous one.
10522 	 index: 0.918637 	 52.732367 table element distance smaller than previous one.
10817 	 index: 0.964329 	 56.696563 table element distance smaller than previous one.
11005 	 index: 0.960521 	 59.399446 table element distance smaller than previous one.
11475 	 index: 0.971944 	 66.320228 table element distance smaller than previous one.
11804 	 index: 0.941483 	 71.803363 table element distance smaller than previous one.
11956 	 index: 1.036673 	 74.213479 table element distance smaller than previous one.
12768 	 index: 0.960521 	 89.079289 table element distance smaller than previous one.
12911 	 index: 1.002407 	 91.751503 table element distance smaller than previous one.
12912 	 index: 1.002405 	 91.751599 table element distance smaller than previous one.
13224 	 index: 0.990982 	 98.150281 table element distance smaller than previous one.
13400 	 index: 0.930051 	 75.254509 table element distance smaller than previous one.

Answer 2

[Image Analyst]

This is a perfect situation for dbscan, if you have the Statistics and Machine Learning Toolbox. Use dbscan to find collections of points that are all within some specified distance of each other. Then you can extract the different classes that were found into new variables containing only the numbers from those classes where all the numbers are close to each other. Give it a try.

Answer 3

[Voss]

"we start from B2, if mod(B2 - B3) < 0.404 we delete A3B3 and continue to compare B2 with B(i), if B2 - B(i) >= 0.404 we leave this element (A(i)B(i)) fixed on it and similarly move down the table."

Assuming that mod(B2 - B3) means abs(B2 - B3), try this:

format longG
S = load('Data_vector');
c = S.c;

d = 0.404;
ii = 2;
while ii < size(c,1)
    if abs(c(ii+1,2) - c(ii,2)) < d
        c(ii+1,:) = [];
    else
        ii = ii + 1;
    end
end

disp(c)

                         0                       874
                         2          2.11720602320851
         0.735871743486974           2.5217086702088
          1.74869739478958          2.92603749911282
                         0                       856
                         2          3.19165165021604
            1.025250501002          3.60216524206979
         0.606412825651303          4.00667273307903
                         0                       616
                         2          4.28115304395541
          1.19659318637275          4.69862662310897
                         0                     10948
                         2          5.30183213946769
          1.23466933867735          5.71142154466949
         0.758806656795153          6.12424849699399
          1.52785571142285          6.54751942633208
          1.02905811623246          6.95179358048678
         0.914829659318637          7.35859538449461
          1.29178356713427          7.77727534261792
          0.92625250501002          8.18695170418768
          1.04809619238477          8.59161482076668
          1.16993987975952          9.00287568951791
         0.861523046092184          9.42260601546063
          1.39839679358717          9.84693292817287
          1.04809619238477          10.2660423858507
         0.899599198396794          10.6736981990686
          1.25751503006012          11.0988268144203
         0.983366733466934          11.5306047839989
          1.12044088176353          11.9405803321538
          1.15470941883768          12.3644081154567
         0.941482965931864          12.7700285522133
          1.26132264529058          13.1824258788438
          1.11672442693585          13.5871743486974
         0.930060120240481          13.9940950951889
          1.25751503006012          14.4027438765563
          1.04428857715431          14.8356388729866
           1.0937875751503           15.254307702293
          1.16993987975952          15.6767352082544
         0.983366733466934          16.1191624981288
          1.26132264529058           16.532959652051
          1.08997995991984           16.968021737327
         0.895791583166333          17.3930555795949
          1.19659318637275          17.8138166305903
           1.0062124248497          18.2242239250233
         0.834869739478958          18.6440431940055
          1.14328657314629          19.0668192290107
         0.966024708224667          19.4789579158317
          1.25751503006012           19.918643485359
          1.08997995991984          20.3417004366163
          0.92625250501002          20.7712950829121
          1.16993987975952          21.1909957415409
          1.00240480961924           21.623556697683
         0.895791583166333          22.0276739096574
          1.11663326653307          22.4685053121419
         0.964328657314629          22.9103320066389
           1.0062124248497          23.3167229726902
          1.06713426853707          23.7654337458429
         0.926573488501555          24.1923847695391
          1.16993987975952          24.6259473928065
            1.025250501002          25.0494707980332
          1.04809619238477          25.4617561719141
          1.11663326653307          25.9019697726354
         0.983366733466934          26.3307434079025
          1.12044088176353          26.7383853665268
          1.04428857715431          27.2058786899506
         0.933867735470942          27.6104368405056
          1.08997995991984          28.0492051458027
         0.964328657314629          28.5037771185699
         0.865330661322645          28.9151904635095
          1.04428857715431          29.3566776886207
          0.92625250501002           29.817530567361
          1.11663326653307           30.255651454339
          1.00275821122773          30.6733466933868
         0.914829659318637           31.084455603783
          1.08997995991984          31.4973236701083
         0.983366733466934          31.9119360899277
          0.96813627254509          32.3173749243314
          1.06332665330661          32.7245914894093
         0.964328657314629          33.1752899720655
          1.07094188376754          33.5840167168353
          1.02784888051695          34.0120240480962
         0.949098196392785          34.4208753183793
          1.11663326653307          34.8253168145223
          1.00240480961924          35.2851770526269
          1.04809619238477          35.6925755300022
          1.06713426853707          36.1407554668142
         0.966925311777651           36.565130260521
          1.14328657314629          37.0106338554092
            1.025250501002          37.4817508610529
          0.92625250501002          37.9067206790402
           1.0900579495055          38.3326653306613
          1.00240480961924           38.744435754514
         0.914829659318637          39.1497351538883
          1.05571142284569          39.5569420415063
         0.983366733466934          39.9963005507543
          1.14328657314629          40.4188366849905
          1.04428857715431          40.8312846529885
         0.945859483074498          41.2785571142285
          1.08997995991984          41.7427463263307
          1.00240480961924          42.2032788002544
          1.07094188376754          42.6084113896733
          1.04597387311875          43.0460921843687
         0.983366733466934          43.4654662422508
          1.11663326653307          43.8926681444734
            1.025250501002           44.355437745534
          1.12044088176353          44.7707013459511
          1.06941275384993          45.2064128256513
          1.00240480961924          45.6294741280088
           1.0937875751503          46.0477343225803
          1.04428857715431          46.5577921031761
         0.964328657314629          46.9736982293634
          1.02905811623246          47.4438977350823
           1.0062124248497          47.8489122575484
         0.990981963927856           48.310035972897
         0.974595181859493          48.7414829659319
         0.960521042084168          49.2155663525613
         0.983366733466934           49.706265476134
         0.922048215372188          50.1162324649299
          1.04428857715431          50.5532597492978
         0.964328657314629          50.9990572316938
         0.895791583166333           51.428252072188
          1.00348014749607          51.8837675350701
          0.92625250501002          52.3933692915681
         0.987174348697395          52.8233630473498
         0.966958323561267          53.2585170340681
         0.911022044088176          53.6710893026631
          1.01763527054108          54.0895052576459
         0.945290581162325          54.6039531309095
          1.02905811623246          55.0098753620867
         0.983865259161301          55.4188376753507
          0.92625250501002          55.8921196301644
            1.025250501002           56.327795823501
         0.946869038498476          56.7935871743487
         0.911022044088176          57.2110538302644
         0.983366733466934          57.7439395610648
         0.913357161534123          58.1683366733467
            1.025250501002          58.6117979094731
         0.964328657314629          59.0581812806355
           1.0062124248497          59.4762996704228
          1.00240480961924          59.9110232893609
         0.945290581162325          60.3170212113234
          1.04686835650093          60.7214428857715
         0.983366733466934          61.2132687696425
         0.911381518657846          61.7034068136273
          1.00240480961924           62.209068724539
         0.945290581162325          62.6681225279227
          1.02905811623246          63.0760429146227
         0.983366733466934          63.5080916671845
          0.92625250501002          63.9182106233393
           1.0062124248497          64.3413731844444
         0.964328657314629          64.8274482797271
          1.04641047986553          65.2384769539078
         0.983366733466934          65.7096155814402
         0.945290581162325          66.1285446557822
            1.025250501002           66.542596723352
         0.965137625757755          67.0060120240481
         0.918637274549098          67.4204409625321
         0.998597194388777          67.8320391229307
         0.945290581162325          68.3528446470821
           1.0062124248497          68.7585657656635
         0.983473403102848          69.1663326653307
         0.930060120240481          69.5734621221638
            1.025250501002          70.0026332423529
         0.964328657314629          70.5036466591349
          1.02905811623246          70.9119996052883
         0.998597194388777          71.3244133220797
         0.945290581162325          71.8067087453569
            1.025250501002          72.2728673401644
         0.966964050046812          72.7014028056112
         0.930060120240481          73.1319492923244
          1.00240480961924            73.57386744428
         0.956713426853707           73.989189023912
          1.04428857715431          74.4381476654227
         0.984300126959534          74.8617234468938
         0.949098196392785          75.2883035415837
            1.025250501002          75.7320699987814
         0.964672993174945          76.2364729458918
          1.04428857715431          76.7061687754459
         0.983972589246051          77.2184368737475
         0.930060120240481           77.627516657321
          1.00240693023471          78.2004008016032
         0.945290581162325          78.6857290677175
          1.02548291384415          79.1823647294589
         0.964328657314629          79.7148697174807
          1.03667334669339           80.123373509922
         0.987195761749882          80.5571142284569
         0.949098196392785          80.9639210567045
            1.025250501002           81.429398409286
         0.965786880872181          81.9318637274549
            1.025250501002          82.3895310195515
          0.98442989663804          82.9138276553106
         0.941482965931864          83.3188627986257
          1.00240480961924          83.7303630542135
         0.964485191796694          84.2885771543086
            1.025250501002          84.7090756409256
         0.964359826110867          85.2705410821643
          1.04428857715431          85.6828053422345
          0.98357180830001            86.25250501002
         0.930060120240481          86.6572295518191
          1.00240480961924          87.1682018727355
         0.964328657314629          87.6081772451371
          1.02822204218389          88.0200400801603
         0.983366733466934          88.5337914136343
          0.92625250501002          88.9887042646511
          1.00436564950659          89.3947895791583
         0.964328657314629          89.8918556192766
            1.025250501002          90.3758767108971
         0.983366733466934          90.8766398920704
           1.0062124248497          91.3159283128163
            1.002406558182           91.751503006012
         0.964328657314629          92.2081027714669
            1.025250501002          92.6645809488758
         0.983366733466934           93.107851449935
          0.92955298696769          93.5190380761523
          1.00240480961924          94.0244291312831
         0.964328657314629          94.4684826831915
          1.02616623567068          94.8937875751503
         0.983366733466934          95.3921717455547
           1.0062124248497           95.821513021288
          1.00338111149972          96.2685370741483
         0.964328657314629          96.7355130914092
          1.02537777092241           97.250501002004
         0.983366733466934          97.7172249714305
         0.987174348697395          98.1497815974063
          1.00283975011769           98.625250501002
         0.964328657314629          99.0741887073207
            1.025250501002          99.5732526132204
         0.983876700342624                       100
                         0                         5
         0.754711301301035          6.12424849699399
                         0                        13
          1.92927214249325          6.32064128256513
                         0                         9
         0.805938446698719          11.8196392785571
                         0                         5
          1.24846420122134          17.7114228456914
                         0                        17
          1.20225497758016          18.8897795591182
                         0                         5
         0.904037401509304          26.5490981963928
                         0                        11
          1.18482308523358          30.0841683366733
                         0                         5
         0.888032089838607          32.2444889779559
                         0                         9
          1.12149227697163          42.6533066132264
                         0                         7
          1.13918311806814          42.6533066132264
                         0                         9
         0.940492199535513          75.2545090180361