Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Friday programming quiz

Friday programming quiz

Scheduled Pinned Locked Moved The Lounge
linqcsharpdata-structuresjsonfunctional
46 Posts 24 Posters 6 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A A Orozco

    In order to get rid of the avg variable so that it doesn't look like created out of thin air, you can replace it with inputs.Average(). As for the unexpected behaviour when the inputs array is empty, you can substitute First() with FirstOrDefault(). This prevents the code from exploding but, as you mentioned, since the expected behaviour is not defined, the result might not be the desired. I must say though, the proposed solution has a nested Lambda expression which contradicts the quiz requirement to use a "Single LINQ Lambda statement" Cheers!

    J Offline
    J Offline
    jesarg
    wrote on last edited by
    #8

    Already replaced the avg with inputs.Average() before you posted. :) I triple-checked the post before posting it the first time, but still made that mistake; hopefully, nobody else sees it. As for the nested Lambda expression, it only has one semi-colon in it, so to me it counts as a single LINQ lambda statement. Maybe I should say "LINQ lambda statement with only one semi-colon at the end", but that would be confusing, and I'd get a ton of people asking for clarification. In any case, thank you for the feedback, and I'll be sure to refine my quiz-posting skills from all this. In the meantime, somebody should try and post their own solution; it's not much of a programming quiz without a few more solutions.

    P 1 Reply Last reply
    0
    • L leppie

      jesarg wrote:

      inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

      You seem to like O^42 complexity :)

      IronScheme
      ((λ (x) `(,x ',x)) '(λ (x) `(,x ',x)))

      J Offline
      J Offline
      jesarg
      wrote on last edited by
      #9

      Although I don't know how the LINQ is resolved, it looks like it can't be worse than O(N^3). The Average() function costs N, the Min() costs N, the Where equals costs N, and the Select Average costs N * N. The worst nesting is N * N * N. Edited: it's at worst O(N^3).

      L K 2 Replies Last reply
      0
      • J jesarg

        Although I don't know how the LINQ is resolved, it looks like it can't be worse than O(N^3). The Average() function costs N, the Min() costs N, the Where equals costs N, and the Select Average costs N * N. The worst nesting is N * N * N. Edited: it's at worst O(N^3).

        L Offline
        L Offline
        leppie
        wrote on last edited by
        #10

        jesarg wrote:

        it's at worst O(N^3).

        See you in a few years when a billion iterations finish ;p

        IronScheme
        ((λ (x) `(,x ',x)) '(λ (x) `(,x ',x)))

        J 1 Reply Last reply
        0
        • L leppie

          jesarg wrote:

          it's at worst O(N^3).

          See you in a few years when a billion iterations finish ;p

          IronScheme
          ((λ (x) `(,x ',x)) '(λ (x) `(,x ',x)))

          J Offline
          J Offline
          jesarg
          wrote on last edited by
          #11

          It remains sub-second time up until around 450 elements, so any test case you manually type should work fine. You think you can put together a solution that's O(N^2)?

          Y 1 Reply Last reply
          0
          • J jesarg

            I promised a programming quiz a couple weeks ago, so here's one: Given an array of integers, select the integer in the array that is the closest to the average of all integers in the array; you must use nothing but a single LINQ lambda statement. If more than one integer is the closest, then any of the closest integers will do. For example, the following code should assign "14" to the int "closest":

            int[] inputs = {1, 2, 3, 5, -1, 7, 145, -33, 22, 14};
            int closest = // put a LINQ lambda expression here

            If you're up for actually figuring out your own solution, ignore the rest of this post. OR If you're lazy and unethical, feel free to copy-paste the sample solution in the small text below and claim it as your own. inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

            B Offline
            B Offline
            BillWoodruff
            wrote on last edited by
            #12

            +5 Interesting challenge, even though far beyond my linquidity. Would like to take a course in Linq from you, because I feel "stymied" in my attempts to advance beyond kindergarten-level using it, assuming I am constitutionally linquidable, that is. best, Bill

            "It is the mark of an educated mind to be able to entertain a thought without accepting it." Aristotle

            J J 2 Replies Last reply
            0
            • J jesarg

              I promised a programming quiz a couple weeks ago, so here's one: Given an array of integers, select the integer in the array that is the closest to the average of all integers in the array; you must use nothing but a single LINQ lambda statement. If more than one integer is the closest, then any of the closest integers will do. For example, the following code should assign "14" to the int "closest":

              int[] inputs = {1, 2, 3, 5, -1, 7, 145, -33, 22, 14};
              int closest = // put a LINQ lambda expression here

              If you're up for actually figuring out your own solution, ignore the rest of this post. OR If you're lazy and unethical, feel free to copy-paste the sample solution in the small text below and claim it as your own. inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

              J Offline
              J Offline
              Johnny J
              wrote on last edited by
              #13

              "We don't do homework!" AND "No programming questions in the Lounge..." ;P

              Why can't I be applicable like John? - Me, April 2011
              -----
              Beidh ceol, caint agus craic againn - Seán Bán Breathnach
              -----
              Da mihi sis crustum Etruscum cum omnibus in eo!
              -----
              Just because a thing is new don’t mean that it’s better - Will Rogers, September 4, 1932

              P 1 Reply Last reply
              0
              • J jesarg

                I promised a programming quiz a couple weeks ago, so here's one: Given an array of integers, select the integer in the array that is the closest to the average of all integers in the array; you must use nothing but a single LINQ lambda statement. If more than one integer is the closest, then any of the closest integers will do. For example, the following code should assign "14" to the int "closest":

                int[] inputs = {1, 2, 3, 5, -1, 7, 145, -33, 22, 14};
                int closest = // put a LINQ lambda expression here

                If you're up for actually figuring out your own solution, ignore the rest of this post. OR If you're lazy and unethical, feel free to copy-paste the sample solution in the small text below and claim it as your own. inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

                S Offline
                S Offline
                Samuel Cragg
                wrote on last edited by
                #14

                Not a very efficient approach (and hope I'm not cheating, there is only one semi-colon!) but here goes:

                int closest = (from t in
                from i in inputs
                let avg = inputs.Average()
                select new { Number = i, Delta = Math.Abs(i - avg) }
                orderby t.Delta
                select t.Number).FirstOrDefault();

                J K 2 Replies Last reply
                0
                • J jesarg

                  I promised a programming quiz a couple weeks ago, so here's one: Given an array of integers, select the integer in the array that is the closest to the average of all integers in the array; you must use nothing but a single LINQ lambda statement. If more than one integer is the closest, then any of the closest integers will do. For example, the following code should assign "14" to the int "closest":

                  int[] inputs = {1, 2, 3, 5, -1, 7, 145, -33, 22, 14};
                  int closest = // put a LINQ lambda expression here

                  If you're up for actually figuring out your own solution, ignore the rest of this post. OR If you're lazy and unethical, feel free to copy-paste the sample solution in the small text below and claim it as your own. inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

                  R Offline
                  R Offline
                  Ravi Bhavnani
                  wrote on last edited by
                  #15

                  Won't work when inputs is of zero length. :) /ravi

                  My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

                  A 1 Reply Last reply
                  0
                  • B BillWoodruff

                    +5 Interesting challenge, even though far beyond my linquidity. Would like to take a course in Linq from you, because I feel "stymied" in my attempts to advance beyond kindergarten-level using it, assuming I am constitutionally linquidable, that is. best, Bill

                    "It is the mark of an educated mind to be able to entertain a thought without accepting it." Aristotle

                    J Offline
                    J Offline
                    Johnny J
                    wrote on last edited by
                    #16

                    BillWoodruff wrote:

                    linquidity

                    Interesting term... I think I'll adopt that! :-D

                    Why can't I be applicable like John? - Me, April 2011
                    -----
                    Beidh ceol, caint agus craic againn - Seán Bán Breathnach
                    -----
                    Da mihi sis crustum Etruscum cum omnibus in eo!
                    -----
                    Just because a thing is new don’t mean that it’s better - Will Rogers, September 4, 1932

                    1 Reply Last reply
                    0
                    • R Ravi Bhavnani

                      Won't work when inputs is of zero length. :) /ravi

                      My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

                      A Offline
                      A Offline
                      AspDotNetDev
                      wrote on last edited by
                      #17

                      Ahem.

                      Thou mewling ill-breeding pignut!

                      R 1 Reply Last reply
                      0
                      • A AspDotNetDev

                        Ahem.

                        Thou mewling ill-breeding pignut!

                        R Offline
                        R Offline
                        Ravi Bhavnani
                        wrote on last edited by
                        #18

                        :thumbsup: /ravi

                        My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

                        1 Reply Last reply
                        0
                        • J jesarg

                          I promised a programming quiz a couple weeks ago, so here's one: Given an array of integers, select the integer in the array that is the closest to the average of all integers in the array; you must use nothing but a single LINQ lambda statement. If more than one integer is the closest, then any of the closest integers will do. For example, the following code should assign "14" to the int "closest":

                          int[] inputs = {1, 2, 3, 5, -1, 7, 145, -33, 22, 14};
                          int closest = // put a LINQ lambda expression here

                          If you're up for actually figuring out your own solution, ignore the rest of this post. OR If you're lazy and unethical, feel free to copy-paste the sample solution in the small text below and claim it as your own. inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

                          P Offline
                          P Offline
                          PIEBALDconsult
                          wrote on last edited by
                          #19

                          jesarg wrote:

                          you must use nothing but a single LINQ lambda statement

                          Frack that; I thought you said this was a programming quiz.

                          1 Reply Last reply
                          0
                          • J jesarg

                            I promised a programming quiz a couple weeks ago, so here's one: Given an array of integers, select the integer in the array that is the closest to the average of all integers in the array; you must use nothing but a single LINQ lambda statement. If more than one integer is the closest, then any of the closest integers will do. For example, the following code should assign "14" to the int "closest":

                            int[] inputs = {1, 2, 3, 5, -1, 7, 145, -33, 22, 14};
                            int closest = // put a LINQ lambda expression here

                            If you're up for actually figuring out your own solution, ignore the rest of this post. OR If you're lazy and unethical, feel free to copy-paste the sample solution in the small text below and claim it as your own. inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

                            D Offline
                            D Offline
                            Daniel Grunwald
                            wrote on last edited by
                            #20

                            int closest = inputs.OrderBy(i => Math.Abs(i - inputs.Average())).FirstOrDefault();

                            This is O(N²) as Average() gets called for every sort key that gets calculated. We can do better by storing the average in a variable. And we can use LINQ to introduce variables within an expression:

                            int closest = (from avg in new[] { inputs.Average() }
                            from i in inputs
                            orderby Math.Abs(i - avg)
                            select i).FirstOrDefault();

                            This is O(N log N), but note that instead of sorting, we just need to find the minimum. Sadly, all the Min() methods compare the element itself, not just a key. However, we can build a suitable implementation using Aggregate():

                            int closest = (from avg in new[] { inputs.Average() }
                            select inputs.Aggregate((a, b) => Math.Abs(a - avg) < Math.Abs(b - avg) ? a : b)
                            ).Single();

                            This runs in linear time, and does pretty much the same as an implementation using a loop would do.

                            J A 2 Replies Last reply
                            0
                            • S Samuel Cragg

                              Not a very efficient approach (and hope I'm not cheating, there is only one semi-colon!) but here goes:

                              int closest = (from t in
                              from i in inputs
                              let avg = inputs.Average()
                              select new { Number = i, Delta = Math.Abs(i - avg) }
                              orderby t.Delta
                              select t.Number).FirstOrDefault();

                              J Offline
                              J Offline
                              jesarg
                              wrote on last edited by
                              #21

                              It's a great solution; it's in the regular LINQ format instead of the lambda format, though. Also, it performs better than the sample solution.

                              1 Reply Last reply
                              0
                              • D Daniel Grunwald

                                int closest = inputs.OrderBy(i => Math.Abs(i - inputs.Average())).FirstOrDefault();

                                This is O(N²) as Average() gets called for every sort key that gets calculated. We can do better by storing the average in a variable. And we can use LINQ to introduce variables within an expression:

                                int closest = (from avg in new[] { inputs.Average() }
                                from i in inputs
                                orderby Math.Abs(i - avg)
                                select i).FirstOrDefault();

                                This is O(N log N), but note that instead of sorting, we just need to find the minimum. Sadly, all the Min() methods compare the element itself, not just a key. However, we can build a suitable implementation using Aggregate():

                                int closest = (from avg in new[] { inputs.Average() }
                                select inputs.Aggregate((a, b) => Math.Abs(a - avg) < Math.Abs(b - avg) ? a : b)
                                ).Single();

                                This runs in linear time, and does pretty much the same as an implementation using a loop would do.

                                J Offline
                                J Offline
                                jesarg
                                wrote on last edited by
                                #22

                                Ok, you just won the programming quiz with flying colors. Your last implementation is doing 5 million elements in sub-second. :) Thanks to everyone who participated, and hopefully, I'll be able to think of another great quiz in a week.

                                1 Reply Last reply
                                0
                                • B BillWoodruff

                                  +5 Interesting challenge, even though far beyond my linquidity. Would like to take a course in Linq from you, because I feel "stymied" in my attempts to advance beyond kindergarten-level using it, assuming I am constitutionally linquidable, that is. best, Bill

                                  "It is the mark of an educated mind to be able to entertain a thought without accepting it." Aristotle

                                  J Offline
                                  J Offline
                                  jesarg
                                  wrote on last edited by
                                  #23

                                  Thanks; LINQ becomes a lot easier once you've used it for a few months, though; you probably just need more practice rather than a course. When I started out, it was confusing, but now it feels easier than loops. LINQ almost always performs worse than using regular loops, though; typically, a loop-based implementation is about 4 times faster when you have a ton of elements.

                                  1 Reply Last reply
                                  0
                                  • J jesarg

                                    It remains sub-second time up until around 450 elements, so any test case you manually type should work fine. You think you can put together a solution that's O(N^2)?

                                    Y Offline
                                    Y Offline
                                    YvesDaoust
                                    wrote on last edited by
                                    #24

                                    This quizz is clearly O(N): computing the average is O(N); computing the absolute deviations from the average is O(N); selecting the smallest element is also O(N). I am not LINQ proficient, but I am pretty sure LINQ implements averaging in linear time, as it would do to build the deviations vector. Finding the position of the minimum of the vector is also O(N). I have nothing against high-level langages, but IMO solving such an easy problem with an O(N^3) hammer is not so welcome.

                                    1 Reply Last reply
                                    0
                                    • J jesarg

                                      I promised a programming quiz a couple weeks ago, so here's one: Given an array of integers, select the integer in the array that is the closest to the average of all integers in the array; you must use nothing but a single LINQ lambda statement. If more than one integer is the closest, then any of the closest integers will do. For example, the following code should assign "14" to the int "closest":

                                      int[] inputs = {1, 2, 3, 5, -1, 7, 145, -33, 22, 14};
                                      int closest = // put a LINQ lambda expression here

                                      If you're up for actually figuring out your own solution, ignore the rest of this post. OR If you're lazy and unethical, feel free to copy-paste the sample solution in the small text below and claim it as your own. inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

                                      B Offline
                                      B Offline
                                      Bruno Tagliapietra
                                      wrote on last edited by
                                      #25

                                      maybe I've found an alternative inputs.Select(x => new { OriginalValue = x, Distance = Math.Abs(x - inputs.Average()) }).OrderBy(a => a.Distance).First().OriginalValue;

                                      K 1 Reply Last reply
                                      0
                                      • J jesarg

                                        Already replaced the avg with inputs.Average() before you posted. :) I triple-checked the post before posting it the first time, but still made that mistake; hopefully, nobody else sees it. As for the nested Lambda expression, it only has one semi-colon in it, so to me it counts as a single LINQ lambda statement. Maybe I should say "LINQ lambda statement with only one semi-colon at the end", but that would be confusing, and I'd get a ton of people asking for clarification. In any case, thank you for the feedback, and I'll be sure to refine my quiz-posting skills from all this. In the meantime, somebody should try and post their own solution; it's not much of a programming quiz without a few more solutions.

                                        P Offline
                                        P Offline
                                        prasun r
                                        wrote on last edited by
                                        #26

                                        Even if you say a lambda statement with only one semi colon, still we can have an anonymous method inside the lambda expression. So lot of clarification required in the challenge statement.

                                        1 Reply Last reply
                                        0
                                        • J jesarg

                                          Although I don't know how the LINQ is resolved, it looks like it can't be worse than O(N^3). The Average() function costs N, the Min() costs N, the Where equals costs N, and the Select Average costs N * N. The worst nesting is N * N * N. Edited: it's at worst O(N^3).

                                          K Offline
                                          K Offline
                                          KP Lee
                                          wrote on last edited by
                                          #27

                                          I like Lambda expressions about as much as the help text for it is descriptive. (IE not much) I'll happily fail your quiz since I didn't sign up for your class and I'm really guessing at how this all works. In your example there were 10 items in the array. Your code:

                                          inputs.Where(x => Math.Abs(x - inputs.Average()) == inputs.Select(y => Math.Abs(y - inputs.Average())).Min()).First();

                                          inputs.Average() loops 10 times, summing all parties and dividing by 10 to provide the average value. y in Math.Abs(y - inputs.Average()) is obviously an interation of inputs values. How it became the iteration value is because it is in the "Select" method, I think. However this expression has to be calculated 100 times (10 y's times Average's 10 loops) to find the Min() value. Math.Abs(x - inputs.Average()) will start on that 100 loop too, so that's 10,000 calculations. (I think that C# isn't smart enough to realize all these function calls on the right side produce a constant so every time the left equation is run, the right equation is re-run.) Aah, but you've put in First() so it will short-circuit the loop when 14 is found. Since 14 is the last value, that's 10,000 loops. :-D 7 Functions executed: Where (1) Math.Abs(2) Average(2) Min(1) First(1) I am never impressed with cute code. Lambda is almost always cute. 10 lines of straightforward code are more valuable than 1 line of cute. The following code

                                            int avg = inputs.Average();
                                            int dif1, dif2, val1;
                                            val1 = inputs\[0\];
                                            if (val1 > avg) dif1 = val1 - avg;
                                            else dif1 = avg - val1;
                                            foreach(int i in inputs) {
                                                if (i > avg) dif2 = i - avg;
                                                else dif2 = avg - i;
                                                if (dif2 < dif1) {
                                                    dif1 = dif2;
                                                    val1 = i;
                                                }
                                            }
                                          

                                          is more verbose, but even with archane variable names, to me, this seems easier to grasp without scratching your head and going: Now, what was that again???? When it is done, you have the average, the closest value to average, and the distance from average in three variables. However, show me the lambda code to do the same thing in 2*N loops my code uses instead of N^4 loops. OK, Math.Abs is easier to read, than if/else, but I think the code cost is about the same. Go ahead and use Abs, there's no advantage in using my 2 lines of code other than showing the function is fairly easy to replicate. Average is too valuable encapsulation to re-invent that wheel. With a 400 item array, 400^4 = 2

                                          P 1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups