How to join many columns of data in array?












1












$begingroup$


I have large number of columns of data. How to put in single matrix?



For example, with test data of 1 x 3 matrixs



test[1] = {1, 1, 1}
test[2] = {2, 2, 2}
test[3] = {3, 3, 3}
test[4] = {4, 4, 4}


I use



Array[test, 4, 1, Join]


and get 1 x 12 matrix



{1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4}


I want to get 4 x 3 matrix



{{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}









share|improve this question









$endgroup$

















    1












    $begingroup$


    I have large number of columns of data. How to put in single matrix?



    For example, with test data of 1 x 3 matrixs



    test[1] = {1, 1, 1}
    test[2] = {2, 2, 2}
    test[3] = {3, 3, 3}
    test[4] = {4, 4, 4}


    I use



    Array[test, 4, 1, Join]


    and get 1 x 12 matrix



    {1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4}


    I want to get 4 x 3 matrix



    {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}









    share|improve this question









    $endgroup$















      1












      1








      1


      1



      $begingroup$


      I have large number of columns of data. How to put in single matrix?



      For example, with test data of 1 x 3 matrixs



      test[1] = {1, 1, 1}
      test[2] = {2, 2, 2}
      test[3] = {3, 3, 3}
      test[4] = {4, 4, 4}


      I use



      Array[test, 4, 1, Join]


      and get 1 x 12 matrix



      {1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4}


      I want to get 4 x 3 matrix



      {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}









      share|improve this question









      $endgroup$




      I have large number of columns of data. How to put in single matrix?



      For example, with test data of 1 x 3 matrixs



      test[1] = {1, 1, 1}
      test[2] = {2, 2, 2}
      test[3] = {3, 3, 3}
      test[4] = {4, 4, 4}


      I use



      Array[test, 4, 1, Join]


      and get 1 x 12 matrix



      {1, 1, 1, 2, 2, 2, 3, 3, 3, 4, 4, 4}


      I want to get 4 x 3 matrix



      {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}






      list-manipulation matrix array






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked 31 mins ago









      Nigel1Nigel1

      1806




      1806






















          4 Answers
          4






          active

          oldest

          votes


















          3












          $begingroup$

          You can try creating an Array and then Transposing:



          In[14]:= Transpose @ Array[test, 4]

          Out[14]= {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}





          share|improve this answer









          $endgroup$





















            3












            $begingroup$

            num = 4;
            test[#] & /@ Range[num] // Transpose



            {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}







            share|improve this answer









            $endgroup$









            • 1




              $begingroup$
              test /@ Range... will do too.
              $endgroup$
              – Kuba
              4 mins ago



















            1












            $begingroup$

            Another possibility:



            Array[List /@ test[#] &, 4, 1, Join[##, 2] &]





            share|improve this answer









            $endgroup$





















              0












              $begingroup$

              Array[test, 4, 1, Transpose[{##}] &]



              {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}




              also



              Array[test, 4, 1, Flatten[{##}, {2}] &]
              Array[test, 4, 1, Thread[{##}] &]





              share|improve this answer











              $endgroup$













                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%2f190061%2fhow-to-join-many-columns-of-data-in-array%23new-answer', 'question_page');
                }
                );

                Post as a guest















                Required, but never shown

























                4 Answers
                4






                active

                oldest

                votes








                4 Answers
                4






                active

                oldest

                votes









                active

                oldest

                votes






                active

                oldest

                votes









                3












                $begingroup$

                You can try creating an Array and then Transposing:



                In[14]:= Transpose @ Array[test, 4]

                Out[14]= {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}





                share|improve this answer









                $endgroup$


















                  3












                  $begingroup$

                  You can try creating an Array and then Transposing:



                  In[14]:= Transpose @ Array[test, 4]

                  Out[14]= {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}





                  share|improve this answer









                  $endgroup$
















                    3












                    3








                    3





                    $begingroup$

                    You can try creating an Array and then Transposing:



                    In[14]:= Transpose @ Array[test, 4]

                    Out[14]= {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}





                    share|improve this answer









                    $endgroup$



                    You can try creating an Array and then Transposing:



                    In[14]:= Transpose @ Array[test, 4]

                    Out[14]= {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}






                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered 25 mins ago









                    rafalcrafalc

                    44127




                    44127























                        3












                        $begingroup$

                        num = 4;
                        test[#] & /@ Range[num] // Transpose



                        {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}







                        share|improve this answer









                        $endgroup$









                        • 1




                          $begingroup$
                          test /@ Range... will do too.
                          $endgroup$
                          – Kuba
                          4 mins ago
















                        3












                        $begingroup$

                        num = 4;
                        test[#] & /@ Range[num] // Transpose



                        {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}







                        share|improve this answer









                        $endgroup$









                        • 1




                          $begingroup$
                          test /@ Range... will do too.
                          $endgroup$
                          – Kuba
                          4 mins ago














                        3












                        3








                        3





                        $begingroup$

                        num = 4;
                        test[#] & /@ Range[num] // Transpose



                        {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}







                        share|improve this answer









                        $endgroup$



                        num = 4;
                        test[#] & /@ Range[num] // Transpose



                        {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}








                        share|improve this answer












                        share|improve this answer



                        share|improve this answer










                        answered 20 mins ago









                        JerryJerry

                        1,112112




                        1,112112








                        • 1




                          $begingroup$
                          test /@ Range... will do too.
                          $endgroup$
                          – Kuba
                          4 mins ago














                        • 1




                          $begingroup$
                          test /@ Range... will do too.
                          $endgroup$
                          – Kuba
                          4 mins ago








                        1




                        1




                        $begingroup$
                        test /@ Range... will do too.
                        $endgroup$
                        – Kuba
                        4 mins ago




                        $begingroup$
                        test /@ Range... will do too.
                        $endgroup$
                        – Kuba
                        4 mins ago











                        1












                        $begingroup$

                        Another possibility:



                        Array[List /@ test[#] &, 4, 1, Join[##, 2] &]





                        share|improve this answer









                        $endgroup$


















                          1












                          $begingroup$

                          Another possibility:



                          Array[List /@ test[#] &, 4, 1, Join[##, 2] &]





                          share|improve this answer









                          $endgroup$
















                            1












                            1








                            1





                            $begingroup$

                            Another possibility:



                            Array[List /@ test[#] &, 4, 1, Join[##, 2] &]





                            share|improve this answer









                            $endgroup$



                            Another possibility:



                            Array[List /@ test[#] &, 4, 1, Join[##, 2] &]






                            share|improve this answer












                            share|improve this answer



                            share|improve this answer










                            answered 18 mins ago









                            Henrik SchumacherHenrik Schumacher

                            51.1k469146




                            51.1k469146























                                0












                                $begingroup$

                                Array[test, 4, 1, Transpose[{##}] &]



                                {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}




                                also



                                Array[test, 4, 1, Flatten[{##}, {2}] &]
                                Array[test, 4, 1, Thread[{##}] &]





                                share|improve this answer











                                $endgroup$


















                                  0












                                  $begingroup$

                                  Array[test, 4, 1, Transpose[{##}] &]



                                  {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}




                                  also



                                  Array[test, 4, 1, Flatten[{##}, {2}] &]
                                  Array[test, 4, 1, Thread[{##}] &]





                                  share|improve this answer











                                  $endgroup$
















                                    0












                                    0








                                    0





                                    $begingroup$

                                    Array[test, 4, 1, Transpose[{##}] &]



                                    {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}




                                    also



                                    Array[test, 4, 1, Flatten[{##}, {2}] &]
                                    Array[test, 4, 1, Thread[{##}] &]





                                    share|improve this answer











                                    $endgroup$



                                    Array[test, 4, 1, Transpose[{##}] &]



                                    {{1, 2, 3, 4}, {1, 2, 3, 4}, {1, 2, 3, 4}}




                                    also



                                    Array[test, 4, 1, Flatten[{##}, {2}] &]
                                    Array[test, 4, 1, Thread[{##}] &]






                                    share|improve this answer














                                    share|improve this answer



                                    share|improve this answer








                                    edited 9 mins ago

























                                    answered 14 mins ago









                                    kglrkglr

                                    180k9200413




                                    180k9200413






























                                        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.




                                        draft saved


                                        draft discarded














                                        StackExchange.ready(
                                        function () {
                                        StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmathematica.stackexchange.com%2fquestions%2f190061%2fhow-to-join-many-columns-of-data-in-array%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

                                        SQL Server 17 - Attemping to backup to remote NAS but Access is denied

                                        Always On Availability groups resolving state after failover - Remote harden of transaction...

                                        Restoring from pg_dump with foreign key constraints