How to creates a Counts[] function that includes zero?

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP












3














In the following example, I'm trying to how many times each integer 1-n appears in list 'a'. But if an element did not appear in a list, Counts creates an association that returns the element instead of zero. So the result is a mixed list of counts and integers, with no indication of which you're looking at.



n = 10;
a = RandomInteger[n, n]
c = Counts[a];
Table[i /. c, i, 1, n]

7, 7, 0, 7, 10, 5, 3, 0, 1, 8
1, 2, 1, 4, 1, 6, 3, 1, 9, 1


Is there a way to make a Counts function that can count zero?










share|improve this question




























    3














    In the following example, I'm trying to how many times each integer 1-n appears in list 'a'. But if an element did not appear in a list, Counts creates an association that returns the element instead of zero. So the result is a mixed list of counts and integers, with no indication of which you're looking at.



    n = 10;
    a = RandomInteger[n, n]
    c = Counts[a];
    Table[i /. c, i, 1, n]

    7, 7, 0, 7, 10, 5, 3, 0, 1, 8
    1, 2, 1, 4, 1, 6, 3, 1, 9, 1


    Is there a way to make a Counts function that can count zero?










    share|improve this question


























      3












      3








      3







      In the following example, I'm trying to how many times each integer 1-n appears in list 'a'. But if an element did not appear in a list, Counts creates an association that returns the element instead of zero. So the result is a mixed list of counts and integers, with no indication of which you're looking at.



      n = 10;
      a = RandomInteger[n, n]
      c = Counts[a];
      Table[i /. c, i, 1, n]

      7, 7, 0, 7, 10, 5, 3, 0, 1, 8
      1, 2, 1, 4, 1, 6, 3, 1, 9, 1


      Is there a way to make a Counts function that can count zero?










      share|improve this question















      In the following example, I'm trying to how many times each integer 1-n appears in list 'a'. But if an element did not appear in a list, Counts creates an association that returns the element instead of zero. So the result is a mixed list of counts and integers, with no indication of which you're looking at.



      n = 10;
      a = RandomInteger[n, n]
      c = Counts[a];
      Table[i /. c, i, 1, n]

      7, 7, 0, 7, 10, 5, 3, 0, 1, 8
      1, 2, 1, 4, 1, 6, 3, 1, 9, 1


      Is there a way to make a Counts function that can count zero?







      list-manipulation counting






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Dec 13 at 21:50









      Henrik Schumacher

      48.1k467136




      48.1k467136










      asked Dec 13 at 21:34









      Jerry Guern

      1,983833




      1,983833




















          3 Answers
          3






          active

          oldest

          votes


















          4














          Use Lookup instead of ReplaceAll:



          n = 10;
          SeedRandom[1]
          a = RandomInteger[n,n];
          c = Counts[a]

          Table[i /. c, i, 1, n]
          Lookup[c, Range[10], 0]



          <|1 -> 1, 4 -> 2, 0 -> 4, 7 -> 1, 8 -> 1, 6 -> 1|>



          1, 2, 3, 2, 5, 1, 1, 1, 9, 10



          1, 0, 0, 2, 0, 1, 1, 1, 0, 0







          share|improve this answer




























            2














            Or you can use SparseArray with additive matrix assembly which may be a bit faster:



            n = 1000000;
            a = RandomInteger[n, n];
            counts = Lookup[Counts[a], Range[1, n], 0]; // AbsoluteTiming // First

            counts2 = Rest@With[spopt = SystemOptions["SparseArrayOptions"],
            Internal`WithLocalSettings[
            SetSystemOptions["SparseArrayOptions" -> "TreatRepeatedEntries" -> Total],

            SparseArray[Partition[a+1, 1] -> 1, n+1],

            SetSystemOptions[spopt]]
            ]; // AbsoluteTiming // First



            1.30965



            0.148508



            True







            share|improve this answer




























              1














              a = 7, 7, 0, 7, 10, 5, 3, 0, 1, 8;
              Counts[a] /@ Range[10] /. Missing -> (0 &)



              1, 0, 1, 0, 1, 0, 3, 1, 0, 1




              Alternatively,



              Block[Missing = (0 &), Counts[a] /@ Range[10]]



              1, 0, 1, 0, 1, 0, 3, 1, 0, 1







              share|improve this answer




















                Your Answer





                StackExchange.ifUsing("editor", function ()
                return StackExchange.using("mathjaxEditing", function ()
                StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
                StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
                );
                );
                , "mathjax-editing");

                StackExchange.ready(function()
                var channelOptions =
                tags: "".split(" "),
                id: "387"
                ;
                initTagRenderer("".split(" "), "".split(" "), channelOptions);

                StackExchange.using("externalEditor", function()
                // Have to fire editor after snippets, if snippets enabled
                if (StackExchange.settings.snippets.snippetsEnabled)
                StackExchange.using("snippets", function()
                createEditor();
                );

                else
                createEditor();

                );

                function createEditor()
                StackExchange.prepareEditor(
                heartbeatType: 'answer',
                autoActivateHeartbeat: false,
                convertImagesToLinks: false,
                noModals: true,
                showLowRepImageUploadWarning: true,
                reputationToPostImages: null,
                bindNavPrevention: true,
                postfix: "",
                imageUploader:
                brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
                contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
                allowUrls: true
                ,
                onDemand: true,
                discardSelector: ".discard-answer"
                ,immediatelyShowMarkdownHelp:true
                );



                );













                draft saved

                draft discarded


















                StackExchange.ready(
                function ()
                StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f187860%2fhow-to-creates-a-counts-function-that-includes-zero%23new-answer', 'question_page');

                );

                Post as a guest















                Required, but never shown

























                3 Answers
                3






                active

                oldest

                votes








                3 Answers
                3






                active

                oldest

                votes









                active

                oldest

                votes






                active

                oldest

                votes









                4














                Use Lookup instead of ReplaceAll:



                n = 10;
                SeedRandom[1]
                a = RandomInteger[n,n];
                c = Counts[a]

                Table[i /. c, i, 1, n]
                Lookup[c, Range[10], 0]



                <|1 -> 1, 4 -> 2, 0 -> 4, 7 -> 1, 8 -> 1, 6 -> 1|>



                1, 2, 3, 2, 5, 1, 1, 1, 9, 10



                1, 0, 0, 2, 0, 1, 1, 1, 0, 0







                share|improve this answer

























                  4














                  Use Lookup instead of ReplaceAll:



                  n = 10;
                  SeedRandom[1]
                  a = RandomInteger[n,n];
                  c = Counts[a]

                  Table[i /. c, i, 1, n]
                  Lookup[c, Range[10], 0]



                  <|1 -> 1, 4 -> 2, 0 -> 4, 7 -> 1, 8 -> 1, 6 -> 1|>



                  1, 2, 3, 2, 5, 1, 1, 1, 9, 10



                  1, 0, 0, 2, 0, 1, 1, 1, 0, 0







                  share|improve this answer























                    4












                    4








                    4






                    Use Lookup instead of ReplaceAll:



                    n = 10;
                    SeedRandom[1]
                    a = RandomInteger[n,n];
                    c = Counts[a]

                    Table[i /. c, i, 1, n]
                    Lookup[c, Range[10], 0]



                    <|1 -> 1, 4 -> 2, 0 -> 4, 7 -> 1, 8 -> 1, 6 -> 1|>



                    1, 2, 3, 2, 5, 1, 1, 1, 9, 10



                    1, 0, 0, 2, 0, 1, 1, 1, 0, 0







                    share|improve this answer












                    Use Lookup instead of ReplaceAll:



                    n = 10;
                    SeedRandom[1]
                    a = RandomInteger[n,n];
                    c = Counts[a]

                    Table[i /. c, i, 1, n]
                    Lookup[c, Range[10], 0]



                    <|1 -> 1, 4 -> 2, 0 -> 4, 7 -> 1, 8 -> 1, 6 -> 1|>



                    1, 2, 3, 2, 5, 1, 1, 1, 9, 10



                    1, 0, 0, 2, 0, 1, 1, 1, 0, 0








                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Dec 13 at 21:38









                    Carl Woll

                    66.8k386174




                    66.8k386174





















                        2














                        Or you can use SparseArray with additive matrix assembly which may be a bit faster:



                        n = 1000000;
                        a = RandomInteger[n, n];
                        counts = Lookup[Counts[a], Range[1, n], 0]; // AbsoluteTiming // First

                        counts2 = Rest@With[spopt = SystemOptions["SparseArrayOptions"],
                        Internal`WithLocalSettings[
                        SetSystemOptions["SparseArrayOptions" -> "TreatRepeatedEntries" -> Total],

                        SparseArray[Partition[a+1, 1] -> 1, n+1],

                        SetSystemOptions[spopt]]
                        ]; // AbsoluteTiming // First



                        1.30965



                        0.148508



                        True







                        share|improve this answer

























                          2














                          Or you can use SparseArray with additive matrix assembly which may be a bit faster:



                          n = 1000000;
                          a = RandomInteger[n, n];
                          counts = Lookup[Counts[a], Range[1, n], 0]; // AbsoluteTiming // First

                          counts2 = Rest@With[spopt = SystemOptions["SparseArrayOptions"],
                          Internal`WithLocalSettings[
                          SetSystemOptions["SparseArrayOptions" -> "TreatRepeatedEntries" -> Total],

                          SparseArray[Partition[a+1, 1] -> 1, n+1],

                          SetSystemOptions[spopt]]
                          ]; // AbsoluteTiming // First



                          1.30965



                          0.148508



                          True







                          share|improve this answer























                            2












                            2








                            2






                            Or you can use SparseArray with additive matrix assembly which may be a bit faster:



                            n = 1000000;
                            a = RandomInteger[n, n];
                            counts = Lookup[Counts[a], Range[1, n], 0]; // AbsoluteTiming // First

                            counts2 = Rest@With[spopt = SystemOptions["SparseArrayOptions"],
                            Internal`WithLocalSettings[
                            SetSystemOptions["SparseArrayOptions" -> "TreatRepeatedEntries" -> Total],

                            SparseArray[Partition[a+1, 1] -> 1, n+1],

                            SetSystemOptions[spopt]]
                            ]; // AbsoluteTiming // First



                            1.30965



                            0.148508



                            True







                            share|improve this answer












                            Or you can use SparseArray with additive matrix assembly which may be a bit faster:



                            n = 1000000;
                            a = RandomInteger[n, n];
                            counts = Lookup[Counts[a], Range[1, n], 0]; // AbsoluteTiming // First

                            counts2 = Rest@With[spopt = SystemOptions["SparseArrayOptions"],
                            Internal`WithLocalSettings[
                            SetSystemOptions["SparseArrayOptions" -> "TreatRepeatedEntries" -> Total],

                            SparseArray[Partition[a+1, 1] -> 1, n+1],

                            SetSystemOptions[spopt]]
                            ]; // AbsoluteTiming // First



                            1.30965



                            0.148508



                            True








                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered Dec 13 at 21:49









                            Henrik Schumacher

                            48.1k467136




                            48.1k467136





















                                1














                                a = 7, 7, 0, 7, 10, 5, 3, 0, 1, 8;
                                Counts[a] /@ Range[10] /. Missing -> (0 &)



                                1, 0, 1, 0, 1, 0, 3, 1, 0, 1




                                Alternatively,



                                Block[Missing = (0 &), Counts[a] /@ Range[10]]



                                1, 0, 1, 0, 1, 0, 3, 1, 0, 1







                                share|improve this answer

























                                  1














                                  a = 7, 7, 0, 7, 10, 5, 3, 0, 1, 8;
                                  Counts[a] /@ Range[10] /. Missing -> (0 &)



                                  1, 0, 1, 0, 1, 0, 3, 1, 0, 1




                                  Alternatively,



                                  Block[Missing = (0 &), Counts[a] /@ Range[10]]



                                  1, 0, 1, 0, 1, 0, 3, 1, 0, 1







                                  share|improve this answer























                                    1












                                    1








                                    1






                                    a = 7, 7, 0, 7, 10, 5, 3, 0, 1, 8;
                                    Counts[a] /@ Range[10] /. Missing -> (0 &)



                                    1, 0, 1, 0, 1, 0, 3, 1, 0, 1




                                    Alternatively,



                                    Block[Missing = (0 &), Counts[a] /@ Range[10]]



                                    1, 0, 1, 0, 1, 0, 3, 1, 0, 1







                                    share|improve this answer












                                    a = 7, 7, 0, 7, 10, 5, 3, 0, 1, 8;
                                    Counts[a] /@ Range[10] /. Missing -> (0 &)



                                    1, 0, 1, 0, 1, 0, 3, 1, 0, 1




                                    Alternatively,



                                    Block[Missing = (0 &), Counts[a] /@ Range[10]]



                                    1, 0, 1, 0, 1, 0, 3, 1, 0, 1








                                    share|improve this answer












                                    share|improve this answer



                                    share|improve this answer










                                    answered Dec 13 at 22:10









                                    kglr

                                    176k9197402




                                    176k9197402



























                                        draft saved

                                        draft discarded
















































                                        Thanks for contributing an answer to Mathematica Stack Exchange!


                                        • Please be sure to answer the question. Provide details and share your research!

                                        But avoid


                                        • Asking for help, clarification, or responding to other answers.

                                        • Making statements based on opinion; back them up with references or personal experience.

                                        Use MathJax to format equations. MathJax reference.


                                        To learn more, see our tips on writing great answers.





                                        Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                                        Please pay close attention to the following guidance:


                                        • Please be sure to answer the question. Provide details and share your research!

                                        But avoid


                                        • Asking for help, clarification, or responding to other answers.

                                        • Making statements based on opinion; back them up with references or personal experience.

                                        To learn more, see our tips on writing great answers.




                                        draft saved


                                        draft discarded














                                        StackExchange.ready(
                                        function ()
                                        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f187860%2fhow-to-creates-a-counts-function-that-includes-zero%23new-answer', 'question_page');

                                        );

                                        Post as a guest















                                        Required, but never shown





















































                                        Required, but never shown














                                        Required, but never shown












                                        Required, but never shown







                                        Required, but never shown

































                                        Required, but never shown














                                        Required, but never shown












                                        Required, but never shown







                                        Required, but never shown






                                        Popular posts from this blog

                                        How to check contact read email or not when send email to Individual?

                                        Displaying single band from multi-band raster using QGIS

                                        How many registers does an x86_64 CPU actually have?