data from user

ed5a8607-53c7-4697-95da-a51dc8727367 65 4 5 decimal

&[DATE] &[TIME] - &[FILENAME]

Unform ...  -1 < rnd < 1 n λ rnd μ n 11 line : λ μ Random * λ 2 / - 21 line :

'N' decimals ...Uniform ... -1 < rnd < 1 n λ N Nrnd i 1 n range r i el n λ rnd i el N round : for r 21 line :

Construct a matrix demo

data 1153 Nrnd 1143 Nrnd 1133 Nrnd 1123 Nrnd 1113 Nrnd augment :

data 2.464 - 0.386 - 0.522 0.202 - 0.037 0.184 - 0.106 - 1.13 0.933 - 0.379 1.517 - 0.712 1.175 0.236 0.006 0.189 1.791 0.132 - 0.419 0.313 1.868 - 1.766 1.047 0.511 - 0.29 - 0.753 - 0.704 1.247 0.279 0.469 - 1.757 1.611 - 0.79 0.869 0.47 2.415 - 0.949 - 0.854 0.649 - 0.334 0.016 1.79 - 0.46 - 0.058 - 0.169 - 1.982 - 0.375 - 0.581 0.065 - 0.37 - 0.749 1.94 - 1.491 0.374 0.081 - 115 mat

M key FindIndex r M rows : c M cols : 12 mat i 1 : j 1 : 12 mat j c ≤ (M i j el key ≠ (* i r < i i 1 + : i 1 : j j 1 + : 21 line if while j c ≤ i j 21 mat 0 if 41 line :

It may be wise to round the matrix so to recover exact key ≠ min_max. F9 to recalculate demo.

row
col data data 2 col Max FindIndex 4221 mat

data data 3 col Min FindIndex 9321 mat

Times Table n T i 1 n range j 1 n range M i j el i j * : for for M 21 line :

data 16 T eval :

Search repeated values in matrix ... [col_row] M lo hi locate k 0 : i 1 M rows range j 1 M cols range M i j el lo ≥ (M i j el hi ≤ (* 0 ≠ u k k 1 + : el i : v k k : el j : 12 mat k k 1 + : if for for strip paired 0's k 0 : i 1 u rows range u i el v i el * 0 ≠ R k k 1 + : el u i el v i el 12 mat : NOT in search lo/hi if 11 line for R transpose 31 line 41 line :

key 48 :

▄▄▄

lo key : hi lo : 12 mat

idx data lo hi locate :

col
row idx 31621 mat 41221 mat 6821 mat 8621 mat 12421 mat 16321 mat 16 mat

idx idx transpose :

▄▄▄

symbol is composite of 3 cursor RHS, backspace to delete

▄

data idx mark i 1 idx rows range data idx i el (1 el idx i el (2 el el ▄▄ : for data 21 line :

data idx mark 123456789101112131415162468101214161820222426283032369121518212427303336394245 ▄▄ 48121620242832364044 ▄▄ 5256606451015202530354045505560657075806121824303642 ▄▄ 5460667278849096714212835424956637077849198105112816243240 ▄▄ 566472808896104112120128918273645546372819099108117126135144102030405060708090100110120130140150160112233445566778899110121132143154165176122436 ▄▄ 6072849610812013214415616818019213263952657891104117130143156169182195208142842567084981121261401541681821962102241530456075901051201351501651801952102252401632 ▄▄ 6480961121281441601761922082242402561616 mat

Search in lo-hi range ... truth table

Altitude correction from source [1..4] data 1.2929 1.2469 1.2022 1.1588 1.1523 1.1113 1.0714 1.0327 1.0392 1.0022 0.9663 0.9314 0.9464 0.9127 0.88 0.8482 0.8688 0.8378 0.8078 0.7786 0.8029 0.7743 0.7466 0.7196 0.7464 0.7198 0.694 0.6689 0.6972 0.6724 0.6483 0.6249 0.6542 0.6309 0.6083 0.5863 0.6161 0.5942 0.5729 0.5522 0.5823 0.5615 0.5414 0.5219 0.5519 0.5323 0.5132 0.4947 0.5246 0.5059 0.4878 0.4702 0.4998 0.482 0.4648 0.448 0.4773 0.4603 0.4438 0.4278 0.4567 0.4405 0.4247 0.4094 0.4379 0.4223 0.4071 0.3924 0.4205 0.4055 0.391 0.3769 0.4044 0.39 0.376 0.3625 0.3896 0.3757 0.3622 0.3491 0.3757 0.3624 0.3494 0.3368 0.3629 0.3499 0.3374 0.3252 224 mat :

search range value
"truth" condition lo 0.6309 : hi 0.8688 : 12 mat x c lo x ≤ (x hi ≤ (* : 21 sys

index data lo hi locate :

index cols 18

index 4421 mat 5121 mat 5221 mat 5321 mat 5421 mat 6121 mat 6221 mat 6321 mat 6421 mat 7121 mat 7221 mat 7321 mat 7421 mat 8121 mat 8221 mat 8321 mat 9121 mat 9221 mat 118 mat

index index transpose :

data UnestV v data 1 el : j 2 data rows range v v data j el stack : for v 31 line :

veritas cnt 1 : j 1 index rows range n index j el (11 el : k index j el (12 el : value cnt el data n k el : cnt cnt 1 + : 41 line for value 31 line :

idx index UnestV : header row col value 13 mat : Project header idx veritas augment stack : 31 sys

Project row col value 44 0.8482 51 0.8688 52 0.8378 53 0.8078 54 0.7786 61 0.8029 62 0.7743 63 0.7466 64 0.7196 71 0.7464 72 0.7198 73 0.694 74 0.6689 81 0.6972 82 0.6724 83 0.6483 91 0.6542 92 0.6309 193 mat

Truth table T data c data * vectorize : 000000000000000 0.8482 0.8688 0.8378 0.8078 0.7786 0.8029 0.7743 0.7466 0.7196 0.7464 0.7198 0.694 0.6689 0.6972 0.6724 0.6483 0 0.6542 0.6309 000000000000000000000000000000000000000000000000000000224 mat

Bidirectional search in XY data set

data from user

User 6.5 2.5 6.5294 2.4502 6.5578 2.401 6.585 2.3522 6.6112 2.304 6.6362 2.2562 6.6602 2.209 6.683 2.1622 6.7048 2.116 6.7254 2.0702 6.745 2.025 6.7634 1.9802 6.7808 1.936 6.797 1.8922 6.8122 1.849 6.8262 1.8062 6.8392 1.764 6.851 1.7222 6.8618 1.681 6.8714 1.6402 6.88 1.6 6.8874 1.5602 6.8938 1.521 6.899 1.4822 6.9032 1.444 6.9062 1.4063 6.9082 1.369 6.909 1.3323 6.9088 1.296 6.9074 1.2603 6.905 1.225 6.9014 1.1903 6.8968 1.156 6.8911 1.1223 6.8842 1.089 6.8762 1.0563 6.8672 1.024 6.8571 0.9923 6.8458 0.961 6.8335 0.9303 6.82 0.9 6.8055 0.8703 6.7898 0.841 6.7731 0.8123 6.7552 0.784 6.7363 0.7563 6.7162 0.729 6.6951 0.7023 6.6728 0.676 6.6495 0.6503 6.625 0.625 6.5995 0.6003 6.5728 0.576 6.5451 0.5523 6.5162 0.529 6.4863 0.5063 6.4552 0.484 6.4231 0.4623 6.3898 0.441 6.3555 0.4203 6.32 0.4 6.2835 0.3803 6.2458 0.361 6.2071 0.3423 6.1672 0.324 6.1263 0.3063 6.0842 0.289 6.0411 0.2723 5.9968 0.256 5.9515 0.2403 5.905 0.225 5.8575 0.2103 5.8088 0.196 5.7591 0.1823 5.7082 0.169 5.6563 0.1563 5.6032 0.144 5.5491 0.1323 5.4938 0.121 5.4375 0.1103 5.38 0.1 5.3215 0.0903 5.2618 0.081 5.2011 0.0723 5.1392 0.064 5.0763 0.0563 5.0122 0.049 4.9471 0.0423 4.8808 0.036 4.8135 0.0303 4.745 0.025 4.6755 0.0203 4.6048 0.016 4.5331 0.0123 4.4602 0.009 4.3863 0.0063 4.3112 0.004 4.2351 0.0023 4.1578 0.001 4.0795 0.0003 411027 -^* 3.9204 0 3.8416 0 3.7636 0 3.6864 0 3.61 0 3.5344 0 3.4596 0 3.3856 0 3.3124 0 3.24 0 3.1684 0 3.0976 0 3.0276 0 2.9584 0 2.89 0 2.8224 0 2.7556 0 2.6896 0 2.6244 0 2.56 0 2.4964 0 2.4336 0 2.3716 0 2.3104 0 2.25 0 2.1904 0 2.1316 0 2.0736 0 2.0164 0 1.96 0 1.9044 0 1.8496 0 1.7956 0 1.7424 0 1.69 0 1.6384 0 1.5876 0 1.5376 0 1.4884 0 1.44 0 1.3924 0 1.3456 0 1.2996 0 1.2544 0 1.21 0 1.1664 0 1.1236 0 1.0816 0 1.0404 010 0.9604 0 0.9216 0 0.8836 0 0.8464 0 0.81 0 0.7744 0 0.7396 0 0.7056 0 0.6724 0 0.64 0 0.6084 0 0.5776 0 0.5476 0 0.5184 0 0.49 0 0.4624 0 0.4356 0 0.4096 0 0.3844 0 0.36 0 0.3364 0 0.3136 0 0.2916 0 0.2704 0 0.25 0 0.2304 0 0.2116 0 0.1936 0 0.1764 0 0.16 0 0.1444 0 0.1296 0 0.1156 0 0.1024 0 0.09 0 0.0784 0 0.0676 0 0.0576 0 0.0484 0 0.04 0 0.0324 0 0.0256 0 0.0196 0 0.0144 0 0.01 0 0.0064 0 0.0036 0 0.0016 0 0.0004 0 6.4 1027 -^* 02012 mat :

M key FindIndex r M rows : idx 1 : M idx el key ≠ idx r < idx idx 1 + : idx if while idx 41 line :

SX User 1 col : SY User 2 col : 12 mat

idx SX SX Max FindIndex : 28

SX idx row SY idx row 12 mat 6.909 11 mat 1.3323 11 mat 12 mat

6.91 1.332 + 20 blue 1 5 mat User 2 1 sys

Filter random negatives suggestive model

Unform ...  -1 < rnd < 1 n λ rnd μ n 11 line : λ μ Random * λ 2 / - 21 line :

'N' decimals ...Uniform ... -1 < rnd < 1 n λ N Nrnd i 1 n range r i el n λ rnd i el N round : for r 21 line :

N 1313 Nrnd :

N data i 1 N rows range N i el 0 N i el < N i el 0 if : for Strip 0's in vector k 0 : i 1 N rows range N i el 0 ≠ R k k 1 + : el N i el : End of strip if 11 line for N R 21 mat 41 line 21 line :

Work in progress ▼ ...

N N data 1 el N data 2 el 13 mat 0.491 - 0.463 0.291 - 0.225 - 0.307 0.279 0.096 - 0.292 - 0.385 - 0.053 - 0.495 0.01 0.409 - 131 mat 0 0.463 00 0.307 0.279 0000 0.495 0.01 0131 mat 0.463 0.307 0.279 0.495 0.01 51 mat 13 mat

◄ neg 0 ◄ strip 0 21 mat

Matched occurences between two data sets

data, want

want 0.4679 0.4542 0.4645 0.4520 0.4654 0.4524 0.4618 0.4503 0.4921 0.4799 0.4744 0.4622 0.4918 0.4799 0.4749 0.4626 0.4381 0.4251 0.4514 0.4400 0.4374 0.4258 0.4515 0.4416 0.4215 0.4121 0.4009 0.3925 0.4136 0.4048 0.3934 0.3861 0.4571 0.4443 0.4552 0.4419 0.4600 0.4483 0.4577 0.4457 0.4008 0.3903 0.3857 0.3753 0.4023 0.3903 0.3856 0.3739 0.4231 0.4093 0.4253 0.4132 0.4213 0.4077 0.4222 0.4103 78 mat :

data 0.4195 0.4099 0.4078 0.4001 0.4247 0.4163 0.4134 0.4074 0.5001 0.4884 0.4893 0.4777 0.5008 0.4910 0.4910 0.4818 0.4945 0.4802 0.4789 0.4659 0.4862 0.4723 0.4719 0.4585 0.4837 0.4692 0.4756 0.4615 0.4862 0.4729 0.4786 0.4662 0.4874 0.4786 0.4788 0.4699 0.4853 0.4765 0.4770 0.4682 0.4543 0.4443 0.4393 0.4309 0.4573 0.4486 0.4420 0.4357 0.4918 0.4798 0.4884 0.4769 0.4915 0.4800 0.4878 0.4768 0.4724 0.4167 0.4160 0.4050 0.4269 0.4171 0.4143 0.4047 0.4302 0.4125 0.4167 0.4000 0.4319 0.4132 0.4190 0.4015 0.4975 0.4861 0.5002 0.4875 0.4952 0.4851 0.4974 0.4864 0.4668 0.4525 0.4430 0.4299 0.4630 0.4495 0.4387 0.4264 0.4713 0.4563 0.4606 0.4462 0.4620 0.4464 0.4542 0.4381 0.4545 0.4433 0.4437 0.4332 0.4565 0.4467 0.4482 0.4392 0.5027 0.4848 0.5039 0.4855 0.5014 0.4839 0.5014 0.4834 0.5015 0.4863 0.4870 0.4728 0.4996 0.4834 0.4859 0.4719 0.4660 0.4569 0.4330 0.4246 0.4548 0.4464 0.4222 0.4126 0.4719 0.4592 0.4700 0.4598 0.4710 0.4588 0.4679 0.4584 0.4056 0.3927 0.3919 0.3833 0.4063 0.3914 0.3922 0.3820 0.4710 0.4584 0.4472 0.4361 0.4731 0.4611 0.4505 0.4406 0.5280 0.5138 0.5137 0.5008 0.5261 0.5121 0.5108 0.4983 0.5040 0.4946 0.5162 0.5072 0.5008 0.4929 0.5127 0.5056 0.3934 0.3872 0.3707 0.3654 0.3910 0.3817 0.3695 0.3611 0.4209 0.4076 0.4062 0.3945 0.4226 0.4104 0.4069 0.3965 0.4824 0.4718 0.4783 0.4683 0.4794 0.4681 0.4757 0.4663 0.4970 0.4869 0.4954 0.4855 0.5015 0.4905 0.5004 0.4901 258 mat :

truth table rectagular Array1 on descending deployed Array2
matched occurences collected wrt their [row/col] in Array1. Array1 Array2 Locate Unwrap an array in vector V Array2 1 col : i 2 Array2 cols range V V Array2 i col stack : for V locate matching occurences i 1 : match 0 : k 1 V rows range row 1 Array1 rows range col 1 Array1 cols range Array1 row col el V k el ≡ (1 ≡ match i 1 el row col 21 mat : i i 1 + : 21 line NO math occurences if for for for match 91 line :

data rows 25

want rows 7

Index data want Locate :

Index 17721 mat 12821 mat 12721 mat 6221 mat 9621 mat 7121 mat 22121 mat 16721 mat 81 mat

1. scan => coincidences data <=> want
2. zap => located in rows 'data' j 1 Index rows range scan j el data Index j el 1 el Index j el 2 el el : zap j el Index j el 1 el : 21 line for

This document . . . from confidential source

0. Source Mathcad 11, project done for Art.

1. want is complete

2. data is reduced in length.

Offered in Smath as a utilities tool .

]]>

Recover 'want' found in 'data' zap scan augment 17 0.4679 12 0.4381 12 0.4542 6 0.4443 9 0.4132 7 0.4918 22 0.3934 16 0.4222 82 mat

zap 171212697221681 mat

sanity individual matched jj 8 :

data Index jj el 1 el Index jj el 2 el el 0.4222

Strip repeated in 'zap' vector zap Strip zap zap sort : k 0 : i 1 zap rows 1 - (range zap i 1 + el zap i el - 0 ≠ R k k 1 + : el zap i el : 11 line if 11 line for R zap zap rows el stack 41 line :

Next objective is to delete rows marked '1' in data. We sort the "zap" vector, then strip from repeated rows indices.

delrow zap Strip :

indices of rows to 
be deleted in data delrow transpose 6791216172217 mat

'include'  rows of data not marked '1' include s 1 data rows range : y delrow : x y in x y ≡ vectorize max : 31 sys j 1 : t s w j el t : j j 1 + : 21 line t y in 0 ≡ Exclude cases for w 41 line :

on descending 's' rows(data),logical test
excludes indices  that are common between
's' and 'delrow' t y in logic test common [1/0] ≡

1. vec'r included data
2. data xcluded  'want'
3. length 'filtered' vr include : Medic data vr 18 range el : k 1 Medic rows range : 31 sys

vr 123458101113141518192021232425181 mat

data 0.4195 0.4099 0.4078 0.4001 0.4247 0.4163 0.4134 0.4074 0.5001 0.4884 0.4893 0.4777 0.5008 0.491 0.491 0.4818 0.4945 0.4802 0.4789 0.4659 0.4862 0.4723 0.4719 0.4585 0.4837 0.4692 0.4756 0.4615 0.4862 0.4729 0.4786 0.4662 0.4874 0.4786 0.4788 0.4699 0.4853 0.4765 0.477 0.4682 0.4543 0.4443 0.4393 0.4309 0.4573 0.4486 0.442 0.4357 0.4918 0.4798 0.4884 0.4769 0.4915 0.48 0.4878 0.4768 0.4724 0.4167 0.416 0.405 0.4269 0.4171 0.4143 0.4047 0.4302 0.4125 0.4167 0.4 0.4319 0.4132 0.419 0.4015 0.4975 0.4861 0.5002 0.4875 0.4952 0.4851 0.4974 0.4864 0.4668 0.4525 0.443 0.4299 0.463 0.4495 0.4387 0.4264 0.4713 0.4563 0.4606 0.4462 0.462 0.4464 0.4542 0.4381 0.4545 0.4433 0.4437 0.4332 0.4565 0.4467 0.4482 0.4392 0.5027 0.4848 0.5039 0.4855 0.5014 0.4839 0.5014 0.4834 0.5015 0.4863 0.487 0.4728 0.4996 0.4834 0.4859 0.4719 0.466 0.4569 0.433 0.4246 0.4548 0.4464 0.4222 0.4126 0.4719 0.4592 0.47 0.4598 0.471 0.4588 0.4679 0.4584 0.4056 0.3927 0.3919 0.3833 0.4063 0.3914 0.3922 0.382 0.471 0.4584 0.4472 0.4361 0.4731 0.4611 0.4505 0.4406 0.528 0.5138 0.5137 0.5008 0.5261 0.5121 0.5108 0.4983 0.504 0.4946 0.5162 0.5072 0.5008 0.4929 0.5127 0.5056 0.3934 0.3872 0.3707 0.3654 0.391 0.3817 0.3695 0.3611 0.4209 0.4076 0.4062 0.3945 0.4226 0.4104 0.4069 0.3965 238 mat

Explore graph col 4 :

Medic Medic :

Medicdata_1 k Medic 1 col augment : col Medicdata k Medic col col augment : 21 line

'Medic', is data stripped of the rows 'mark 1'... as determined by Locate(Array1,Array2).

Medicdata_1 col Medicdata 2 1 sys

Medicdata_1 sum col Medicdata sum 21 mat 179.6 179.2 21 mat

sanity individual 'mark' jj 8 :

data Index jj el 1 el Index jj el 2 el el 0.4222

▄▄▄

data Index markWant i 1 Index rows range data Index i el (1 el Index i el (2 el el ▄▄▄ : for data 21 line :

identify/visualize/locate
in data where 'want & data'
do coincide  ...
[kind of truth table] data Index markWant

data data Index markWant :

data mark " " ... Medic

rows marked "" are zapped for the resulting Medic data 0.4195 0.4099 0.4078 0.4001 0.4247 0.4163 0.4134 0.4074 0.5001 0.4884 0.4893 0.4777 0.5008 0.491 0.491 0.4818 0.4945 0.4802 0.4789 0.4659 0.4862 0.4723 0.4719 0.4585 0.4837 0.4692 0.4756 0.4615 0.4862 0.4729 0.4786 0.4662 0.4874 0.4786 0.4788 0.4699 0.4853 0.4765 0.477 0.4682 0.4543 ▄▄▄ 0.4393 0.4309 0.4573 0.4486 0.442 0.4357 ▄▄▄ 0.4798 0.4884 0.4769 0.4915 0.48 0.4878 0.4768 0.4724 0.4167 0.416 0.405 0.4269 0.4171 0.4143 0.4047 0.4302 0.4125 0.4167 0.4 0.4319 ▄▄▄ 0.419 0.4015 0.4975 0.4861 0.5002 0.4875 0.4952 0.4851 0.4974 0.4864 0.4668 0.4525 0.443 0.4299 0.463 0.4495 0.4387 0.4264 0.4713 0.4563 0.4606 0.4462 0.462 0.4464 ▄▄▄ ▄▄▄ 0.4545 0.4433 0.4437 0.4332 0.4565 0.4467 0.4482 0.4392 0.5027 0.4848 0.5039 0.4855 0.5014 0.4839 0.5014 0.4834 0.5015 0.4863 0.487 0.4728 0.4996 0.4834 0.4859 0.4719 0.466 0.4569 0.433 0.4246 0.4548 0.4464 ▄▄▄ 0.4126 0.4719 0.4592 0.47 0.4598 0.471 0.4588 ▄▄▄ 0.4584 0.4056 0.3927 0.3919 0.3833 0.4063 0.3914 0.3922 0.382 0.471 0.4584 0.4472 0.4361 0.4731 0.4611 0.4505 0.4406 0.528 0.5138 0.5137 0.5008 0.5261 0.5121 0.5108 0.4983 0.504 0.4946 0.5162 0.5072 0.5008 0.4929 0.5127 0.5056 ▄▄▄ 0.3872 0.3707 0.3654 0.391 0.3817 0.3695 0.3611 0.4209 0.4076 0.4062 0.3945 0.4226 0.4104 0.4069 0.3965 0.4824 0.4718 0.4783 0.4683 0.4794 0.4681 0.4757 0.4663 0.497 0.4869 0.4954 0.4855 0.5015 0.4905 0.5004 0.4901 258 mat

Medic 0.4195 0.4099 0.4078 0.4001 0.4247 0.4163 0.4134 0.4074 0.5001 0.4884 0.4893 0.4777 0.5008 0.491 0.491 0.4818 0.4945 0.4802 0.4789 0.4659 0.4862 0.4723 0.4719 0.4585 0.4837 0.4692 0.4756 0.4615 0.4862 0.4729 0.4786 0.4662 0.4874 0.4786 0.4788 0.4699 0.4853 0.4765 0.477 0.4682 0.4724 0.4167 0.416 0.405 0.4269 0.4171 0.4143 0.4047 0.4975 0.4861 0.5002 0.4875 0.4952 0.4851 0.4974 0.4864 0.4668 0.4525 0.443 0.4299 0.463 0.4495 0.4387 0.4264 0.4545 0.4433 0.4437 0.4332 0.4565 0.4467 0.4482 0.4392 0.5027 0.4848 0.5039 0.4855 0.5014 0.4839 0.5014 0.4834 0.5015 0.4863 0.487 0.4728 0.4996 0.4834 0.4859 0.4719 0.4056 0.3927 0.3919 0.3833 0.4063 0.3914 0.3922 0.382 0.471 0.4584 0.4472 0.4361 0.4731 0.4611 0.4505 0.4406 0.528 0.5138 0.5137 0.5008 0.5261 0.5121 0.5108 0.4983 0.504 0.4946 0.5162 0.5072 0.5008 0.4929 0.5127 0.5056 0.4209 0.4076 0.4062 0.3945 0.4226 0.4104 0.4069 0.3965 0.4824 0.4718 0.4783 0.4683 0.4794 0.4681 0.4757 0.4663 0.497 0.4869 0.4954 0.4855 0.5015 0.4905 0.5004 0.4901 188 mat

col(Medic ≤ 8) index 1 Medic rows range : plot index Medic 8 col augment : 21 sys

plot 1 0.4074 2 0.4818 3 0.4585 4 0.4662 5 0.4682 6 0.4047 7 0.4864 8 0.4264 9 0.4392 10 0.4834 11 0.4719 12 0.382 13 0.4406 14 0.4983 15 0.5056 16 0.3965 17 0.4663 18 0.4901 182 mat

Medic cols 8

plot plot 2 1 sys

vx plot 1 col : vy plot 2 col : 12 mat x s vx vy x ainterp : x λ 11 x ≤ (x 18 ≤ (& cases : ainterp renders X_Y spline 41 mat

plot x s x λ * 2 1 sys plot x s 2 1 sys

Replace range in matrix

value table col lookup index Clear k 1 : j k table rows range table j col el value ≡ vidx k el j : k k 1 + : 21 line No match if for vidx 41 line :

M 12345648933 mat :

6 M 3 lookup 211 mat

address/replace M 23 el 2 sqrt :

M 12345 1.414214 48933 mat

W 1.22 7.36 7.96 7.94 1.26 2.36 4.74 3.07 5.83 4.11 3.78 8.14 3.64 9.93 8.95 9.73 5.13 3.71 5.78 3.16 54 mat :

Truth table ...
locate elements in M within range [a, b] M a b Truth count 0 : i 1 M rows range j 1 M cols range M i j el a ≥ (M i j el b ≤ (* Z i j el M i j el : count count 1 + : if for for Z 31 line :

true W 24 Truth :

true 00000 2.36 0 3.07 00 3.78 0 3.64 0000 3.71 0 3.16 54 mat

x c x 2 ≥ (x 4 ≤ (* :

W c W * vectorize 00000 2.36 0 3.07 00 3.78 0 3.64 0000 3.71 0 3.16 54 mat

M a b m FindReplace count 0 : i 1 M rows range j 1 M cols range M i j el a ≥ (M i j el b ≤ (* found i j el M i j el : count count 1 + : if for for found 31 line count 0 : i 1 found rows range j 1 found cols range found i j el 0 ≡ replace i j el M i j el : replace i j el m : count count 1 + : 21 line if for for replace 31 line 21 line :

Objective W 24 FindReplace :

Highlight the replaced elements Objective 1.22 7.36 7.96 7.94 1.26 4.74 5.83 4.11 8.14 9.93 8.95 9.73 5.13 5.78 54 mat

Piecewise/global locate v in Q

Q 1.22 7.36 7.96 7.94 1.26 2.36 4.74 3.07 5.83 4.11 3.78 8.14 3.64 9.93 8.95 9.73 5.13 3.71 5.78 3.16 54 mat :

of any length
v ≤ length(Q)
in any order. v 5.13 4.74 9.93 9.73 3.16 2.36 61 mat :

Q length 20

M key FindIndex r M rows : c M cols : 12 mat i 1 : j 1 : 12 mat j c ≤ (M i j el key ≠ (* i r < i i 1 + : i 1 : j j 1 + : 21 line if while j c ≤ i j M i j el 31 mat end of scan if 41 line :

idx 2 :

key v idx el :

row
col
key idx Q key FindIndex (: 23 4.74 31 mat

global locate v ... in ... Q k 1 v rows range key k el v k el : idx k el Q key k el FindIndex : 21 line for

row/col/key idx transpose 51 5.13 13 mat 23 4.74 13 mat 42 9.93 13 mat 44 9.73 13 mat 54 3.16 13 mat 22 2.36 13 mat 16 mat

data idx mark i 1 idx rows range data idx i el (1 el idx i el (2 el el idx i el (3 el num2str : for data 21 line :

4 appVersion 0.98.6179.21440 ≡

M Q idx mark :

Distasteful "59/25" 
instead of "2.36" M 1.22 7.36 7.96 7.94 1.26 59/25 237/50 3.07 5.83 4.11 3.78 8.14 3.64 993/100 8.95 973/100 513/100 3.71 5.78 79/25 54 mat

Locate the 1rst occurence of a
specific element in matrix V x FindIdx j 1 : V j el x ≠ j j 1 + : while j V j el 12 mat 31 line :

M 123410 - 112181333 mat :

x 13 :

13 is on length 9 of M M x FindIdx 91312 mat

data 10 0.59 21 0.61 32 0.65 43 0.6 54862 0.55 7 0.3 0.6 - 8 0.4 0.62 - 9 0.4 0.6 10 0.38 6114 0.45 12 0.45 0.48 - 13 0.5 - 0.5 - 14 0.48 - 0.45 15 0.45 4166 0.38 17 0.6 0.4 18 0.62 - 0.4 19 0.6 - 0.3 20 0.55 2218422 0.6 323 0.65 224 0.61 125 0.59 0253 mat :

Locate 1rst exact value in vector V x col FindIdx j 1 : V j col el x ≠ j j 1 + : while j 0 ≡ inexistant j V j col el 12 mat if 31 line :

key 0.62 - : col 3 : 12 mat

idxkey data key col FindIdx :

idxkey 8 0.62 - 12 mat

data idxkey 11 el row 8 0.4 0.62 - 13 mat

Exclude a region from a data set

T1, T2

T1 00 0.038 - 0.022 0.075 - 0.046 0.112 - 0.072 0.15 - 0.099 0.188 - 0.128 0.225 - 0.16 0.262 - 0.193 0.3 - 0.229 0.338 - 0.269 0.375 - 0.312 0.412 - 0.359 0.45 - 0.413 0.488 - 0.476 0.525 - 0.555 0.525 - 0.846 0.488 - 0.872 0.45 - 0.88 0.412 - 0.876 0.375 - 0.864 0.338 - 0.844 0.3 - 0.817 0.262 - 0.783 0.225 - 0.74 0.188 - 0.69 0.15 - 0.629 0.112 - 0.554 0.075 - 0.46 0.038 - 0.33 00 0.067 0.036 0.133 0.068 0.2 0.096 0.267 0.121 0.333 0.141 0.4 0.158 0.467 0.17 0.533 0.179 0.6 0.184 0.667 0.184 0.733 0.178 0.8 0.166 0.867 0.145 0.933 0.109 1010 0.933 0.109 - 0.867 0.145 - 0.8 0.166 - 0.733 0.178 - 0.667 0.184 - 0.6 0.184 - 0.533 0.179 - 0.467 0.17 - 0.4 0.158 - 0.333 0.141 - 0.267 0.121 - 0.2 0.096 - 0.133 0.068 - 0.067 0.036 - 00 0.038 - 0.022 - 0.075 - 0.046 - 0.112 - 0.072 - 0.15 - 0.099 - 0.188 - 0.128 - 0.225 - 0.16 - 0.262 - 0.193 - 0.3 - 0.229 - 0.338 - 0.269 - 0.375 - 0.312 - 0.412 - 0.359 - 0.45 - 0.413 - 0.488 - 0.476 - 0.525 - 0.555 - 0.525 - 0.846 - 0.488 - 0.872 - 0.45 - 0.88 - 0.412 - 0.876 - 0.375 - 0.864 - 0.338 - 0.844 - 0.3 - 0.817 - 0.262 - 0.783 - 0.225 - 0.74 - 0.188 - 0.69 - 0.15 - 0.629 - 0.112 - 0.554 - 0.075 - 0.46 - 0.038 - 0.33 - 00902 mat :

T2 00 0.044 - 0.001 0.088 - 0.003 0.133 - 0.006 0.179 - 0.011 0.227 - 0.017 0.275 - 0.026 0.324 - 0.036 0.374 - 0.049 0.427 - 0.064 0.481 - 0.082 0.537 - 0.105 0.596 - 0.133 0.66 - 0.168 0.732 - 0.219 0.878 - 0.47 0.858 - 0.512 0.83 - 0.537 0.795 - 0.553 0.757 - 0.561 0.714 - 0.562 0.668 - 0.558 0.619 - 0.546 0.565 - 0.529 0.507 - 0.504 0.444 - 0.469 0.374 - 0.424 0.295 - 0.361 0.198 - 0.267 00 0.04 0.065 0.081 0.126 0.125 0.183 0.171 0.238 0.218 0.289 0.268 0.337 0.319 0.381 0.372 0.422 0.428 0.459 0.485 0.493 0.546 0.521 0.61 0.544 0.678 0.559 0.754 0.561 0.866 0.5 0.866 0.5 0.863 0.372 0.823 0.308 0.776 0.256 0.724 0.212 0.669 0.174 0.612 0.141 0.552 0.111 0.489 0.086 0.425 0.063 0.359 0.045 0.291 0.029 0.221 0.017 0.15 0.008 0.076 0.002 00 0.021 - 0.038 - 0.042 - 0.078 - 0.062 - 0.118 - 0.08 - 0.161 - 0.098 - 0.205 - 0.115 - 0.251 - 0.131 - 0.298 - 0.145 - 0.349 - 0.158 - 0.401 - 0.169 - 0.457 - 0.178 - 0.517 - 0.183 - 0.583 - 0.184 - 0.656 - 0.177 - 0.744 - 0.032 - 0.995 - 0.014 0.999 - 0.05 0.987 - 0.081 0.965 - 0.107 0.936 - 0.13 0.9 - 0.149 0.858 - 0.164 0.809 - 0.175 0.754 - 0.182 0.691 - 0.184 0.619 - 0.18 0.536 - 0.165 0.436 - 0.133 0.305 - 00902 mat :

lo 0.1 - : hi 0.1 : 12 mat

Lo 0.15 - : Hi 0.15 : 12 mat

t1 k 0 : i 1 T1 rows range T1 i 1 el lo ≥ (T1 i 1 el hi ≤ (* 1 ≠ idx k k 1 + : el i : conserved region if for j idx U j el T1 j 1 el T1 j 2 el 12 mat : for U 41 line :

t2 k 0 : i 1 T2 rows range T2 i 1 el Lo ≥ (T2 i 1 el Hi ≤ (* 1 ≠ idx k k 1 + : el i : conserved region if for j idx U j el T2 j 1 el T2 j 2 el 12 mat : for U 41 line :

Strip single 0's v Strip0 k 0 : i 1 v rows range v i el 0 ≠ R k k 1 + : el v i el : v is ≠ 0 if 11 line for R 31 line :

data Unest v data 1 el : j 2 data rows range v v data j el stack : for v 31 line :

N1 t1 Strip0 Unest : N2 t2 Strip0 Unest : 21 line

data char size clr plot k 1 data rows range r3 k el char : r4 k el size : r5 k el clr : 13 mat for data r3 r4 r5 augment 21 line :

N1 N1 . 9 blue plot : N2 N2 . 9 red plot : 21 sys

T1 T2 2 1 sys N1 N2 2 1 sys

T1 rows t1 rows N1 rows 31 sys 90877631 sys

T2 rows t2 rows N2 rows 31 sys 90886231 sys

Exclude/Include ...

x 010 0.1 range : data x x sqrt vectorize 6 round vectorize augment : lo 2 sqrt : hi 4 : 12 mat 31 sys

range k 0 : i 1 data rows range data i 1 el lo ≥ (data i 1 el hi ≤ (* 1 ≠ idx k k 1 + : el i : conserved region if for j idx U j el data j 1 el data j 2 el 12 mat : for U 41 line :

v Strip0 k 0 : i 1 v rows range v i el 0 ≠ R k k 1 + : el v i el : v is ≠ 0 if 11 line for R 31 line :

data Unest v data 1 el : j 2 data rows range v v data j el stack : for v 31 line :

New range Strip0 Unest :

data char size clr plot k 1 data rows range r3 k el char : r4 k el size : r5 k el clr : 13 mat for data r3 r4 r5 augment 21 line :

locate indices in [lo, hi] range ... M lo hi locate k 0 : i 1 M rows range j 1 M cols range M i j el lo ≥ (M i j el hi ≤ (* 0 ≠ u k k 1 + : el i : v k k : el j : 12 mat k k 1 + : if for for strip paired 0's k 0 : i 1 u rows range u i el v i el * 0 ≠ R k k 1 + : el u i el v i el 12 mat : NOT in search lo/hi if 11 line for R 31 line 41 line :

MyRange New . 9 black plot :

MyRange lo 2 lo 1 - 2 2 mat hi 3 hi 1 - 2 2 mat 3 1 sys

lo 2 sqrt : hi 3 : 12 mat

idx data 2 col lo hi locate :

jidx idx Unest 1 col :

MyStuff data 1 col jidx el data 2 col jidx el augment :

MyStuff lo 2 ^ 3 lo 2 ^ 1 - 2 2 mat 2 1 sys

MyStuff 2 1.414 2.1 1.449 2.2 1.483 2.3 1.517 2.4 1.549 2.5 1.581 2.6 1.612 72 mat

MyStuff 1 row MyStuff MyStuff rows row 21 sys 2 1.414 12 mat 9312 mat 21 sys