Re: replace with closest value
- To: mathgroup at smc.vnet.net
- Subject: [mg119528] Re: replace with closest value
- From: DrMajorBob <btreat1 at austin.rr.com>
- Date: Wed, 8 Jun 2011 07:12:59 -0400 (EDT)
- References: <201106071045.GAA05887@smc.vnet.net>
- Reply-to: drmajorbob at yahoo.com
a = {1.3, 1.5, 1.6, 1.8, 2.1, 2.3, 2.6, 2.9, 3.3, 3.7, 4.2, 4.7, 5.2, 5.9, 6.6, 7.4, 8.3, 9.4, 10.6, 11.8, 13.1, 14.8, 16.9, 19., 21.5, 23.6}; b = {1.2, 1.4, 1.6, 1.8, 2, 2.25, 2.5, 2.75, 3, 3.25, 3.5, 3.75, 4, 5, 6, 8, 10, 15, 20, 25, 40, 60, 100}; (Nearest[b] /@ a)[[All, 1]] {1.4, 1.4, 1.6, 1.8, 2, 2.25, 2.5, 3, 3.25, 3.75, 4, 5, 5, 6, 6, 8, \ 8, 10, 10, 10, 15, 15, 15, 20, 20, 25} (Nearest[b] /@ a)[[All, -1]] {1.4, 1.6, 1.6, 1.8, 2, 2.25, 2.5, 3, 3.25, 3.75, 4, 5, 5, 6, 6, 8, \ 8, 10, 10, 10, 15, 15, 15, 20, 20, 25} Mean /@ (Nearest[b] /@ a) {1.4, 1.5, 1.6, 1.8, 2, 2.25, 2.5, 3, 3.25, 3.75, 4, 5, 5, 6, 6, 8, \ 8, 10, 10, 10, 15, 15, 15, 20, 20, 25} (Nearest[Rationalize@b] /@ Rationalize@a)[[All, 1]] /. x_Rational :> N@x {1.2, 1.4, 1.6, 1.8, 2, 2.25, 2.5, 3, 3.25, 3.75, 4, 5, 5, 6, 6, 8, \ 8, 10, 10, 10, 15, 15, 15, 20, 20, 25} eps = 10^-10; -eps + Mean /@ (Nearest[b + eps] /@ a) {1.2, 1.4, 1.6, 1.8, 2, 2.25, 2.5, 3, 3.25, 3.75, 4, 5, 5, 6, 6, 8, \ 8, 10, 10, 10, 15, 15, 15, 20, 20, 25} Mean /@ (Nearest[Rationalize@b] /@ Rationalize@a) /. x_Rational :> N@x {1.3, 1.5, 1.6, 1.8, 2, 2.25, 2.5, 3, 3.25, 3.75, 4, 5, 5, 6, 6, 8, \ 8, 10, 10, 10, 15, 15, 15, 20, 20, 25} None of these are what you seem to expect, because of rounding. Bobby On Tue, 07 Jun 2011 05:45:51 -0500, graser <graser at gmail.com> wrote: > Hi > > I have a some question for you! > > Let's say there is a list like that > AA={1.3, 1.5, 1.6, 1.8, 2.1, 2.3, 2.6, 2.9, 3.3, 3.7, 4.2, 4.7, 5.2, > 5.9, 6.6, 7.4, 8.3, 9.4, 10.6, 11.8, 13.1, 14.8, 16.9, 19., 21.5, > 23.6}. > Length[AA]=26 > I want to replace the element in the list with a closest number I > specify in my list BB, > BB={1.2, 1.4, 1.6, 1.8, 2, 2.25, 2.5, 2.75, 3, 3.25, 3.5, 3.75, 4, 5, > 6, 8 , 10 , 15, 20, 25, 40, 60, 100}, > Length[BB]=23 > so that the list AA after I replace will be > > AA={1.2, 1.5, 1.6, 1.8, 2. 2.25, 2.5,3.........20, 25} > Length[AA]=26. > > I wonder if anyone can help me to solve this problem! > > -- DrMajorBob at yahoo.com
- References:
- replace with closest value
- From: graser <graser@gmail.com>
- replace with closest value