Formatting a table to look nice












3












$begingroup$


my current code is:



binsize = 21;

data = {535, 481, 554, 567, 565, 513, 526, 506, 565, 475, 552, 533, 

   474, 556, 520, 508, 597, 479, 537, 499, 546, 473, 579, 526, 594, 

   477, 518, 538, 497, 565};

firstbin = 472;

a = BinCounts[data, {firstbin, Max[data] + binsize, binsize}];

b = Range[firstbin, Max[data] + binsize, binsize];

Transpose[{Take[b, Length[a]], a}] // TableForm


Which does give me a nice table, however I would like the bins to be labeled something like "472-492 6" instead of just "472 6"



any advice would be great, thank you.






table formatting







share|improve this question











$endgroup$

















    3












    $begingroup$


    my current code is:



    binsize = 21;
    
data = {535, 481, 554, 567, 565, 513, 526, 506, 565, 475, 552, 533, 
    
   474, 556, 520, 508, 597, 479, 537, 499, 546, 473, 579, 526, 594, 
    
   477, 518, 538, 497, 565};
    
firstbin = 472;
    
a = BinCounts[data, {firstbin, Max[data] + binsize, binsize}];
    
b = Range[firstbin, Max[data] + binsize, binsize];
    
Transpose[{Take[b, Length[a]], a}] // TableForm


    Which does give me a nice table, however I would like the bins to be labeled something like "472-492 6" instead of just "472 6"



    any advice would be great, thank you.






    table formatting







    share|improve this question











    $endgroup$















      3












      3








      3


      1



      $begingroup$


      my current code is:



      binsize = 21;
      
data = {535, 481, 554, 567, 565, 513, 526, 506, 565, 475, 552, 533, 
      
   474, 556, 520, 508, 597, 479, 537, 499, 546, 473, 579, 526, 594, 
      
   477, 518, 538, 497, 565};
      
firstbin = 472;
      
a = BinCounts[data, {firstbin, Max[data] + binsize, binsize}];
      
b = Range[firstbin, Max[data] + binsize, binsize];
      
Transpose[{Take[b, Length[a]], a}] // TableForm


      Which does give me a nice table, however I would like the bins to be labeled something like "472-492 6" instead of just "472 6"



      any advice would be great, thank you.






      table formatting







      share|improve this question











      $endgroup$




      my current code is:



      binsize = 21;
      
data = {535, 481, 554, 567, 565, 513, 526, 506, 565, 475, 552, 533, 
      
   474, 556, 520, 508, 597, 479, 537, 499, 546, 473, 579, 526, 594, 
      
   477, 518, 538, 497, 565};
      
firstbin = 472;
      
a = BinCounts[data, {firstbin, Max[data] + binsize, binsize}];
      
b = Range[firstbin, Max[data] + binsize, binsize];
      
Transpose[{Take[b, Length[a]], a}] // TableForm


      Which does give me a nice table, however I would like the bins to be labeled something like "472-492 6" instead of just "472 6"



      any advice would be great, thank you.






      table formatting




      table formatting






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 1 hour ago







      Wombles

















      asked 2 hours ago









      WomblesWombles

      334




      334






















          2 Answers
          2






          active

          oldest

          votes


















          4












          $begingroup$

          {binlims, bincounts} = HistogramList[data, {firstbin, Max[data] + binsize, binsize}];
          
bins = Row[{#, #2 - 1}, "-"] & @@@ Partition[binlims, 2, 1];
          
TableForm[Transpose[{bins, bincounts}]]


          enter image description here






          share|improve this answer









          $endgroup$













          • $begingroup$
            Thank you very much!
            $endgroup$
            – Wombles
            1 hour ago










          • $begingroup$
            @Wombles, you are welcome.
            $endgroup$
            – kglr
            1 hour ago



















          1












          $begingroup$

          Here is one way:



          bb = b - 1;
          
c = Complement[bb, {Min[bb]}];
          
Transpose[{Take[b, Length[a]], ConstantArray["---", Length[a]], c, a}] // TableForm


          Here is the output:



          enter image description here






          share|improve this answer











          $endgroup$













          • $begingroup$
            I wish I knew more about string manipulation to get the first three columns to combine to one column of text!
            $endgroup$
            – mjw
            1 hour ago










          • $begingroup$
            You might want ToString and StringJoin
            $endgroup$
            – MarcoB
            1 hour ago











          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%2f192750%2fformatting-a-table-to-look-nice%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          2 Answers
          2






          active

          oldest

          votes








          2 Answers
          2






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          4












          $begingroup$

          {binlims, bincounts} = HistogramList[data, {firstbin, Max[data] + binsize, binsize}];
          
bins = Row[{#, #2 - 1}, "-"] & @@@ Partition[binlims, 2, 1];
          
TableForm[Transpose[{bins, bincounts}]]


          enter image description here






          share|improve this answer









          $endgroup$













          • $begingroup$
            Thank you very much!
            $endgroup$
            – Wombles
            1 hour ago










          • $begingroup$
            @Wombles, you are welcome.
            $endgroup$
            – kglr
            1 hour ago
















          4












          $begingroup$

          {binlims, bincounts} = HistogramList[data, {firstbin, Max[data] + binsize, binsize}];
          
bins = Row[{#, #2 - 1}, "-"] & @@@ Partition[binlims, 2, 1];
          
TableForm[Transpose[{bins, bincounts}]]


          enter image description here






          share|improve this answer









          $endgroup$













          • $begingroup$
            Thank you very much!
            $endgroup$
            – Wombles
            1 hour ago










          • $begingroup$
            @Wombles, you are welcome.
            $endgroup$
            – kglr
            1 hour ago














          4












          4








          4





          $begingroup$

          {binlims, bincounts} = HistogramList[data, {firstbin, Max[data] + binsize, binsize}];
          
bins = Row[{#, #2 - 1}, "-"] & @@@ Partition[binlims, 2, 1];
          
TableForm[Transpose[{bins, bincounts}]]


          enter image description here






          share|improve this answer









          $endgroup$



          {binlims, bincounts} = HistogramList[data, {firstbin, Max[data] + binsize, binsize}];
          
bins = Row[{#, #2 - 1}, "-"] & @@@ Partition[binlims, 2, 1];
          
TableForm[Transpose[{bins, bincounts}]]


          enter image description here







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered 1 hour ago









          kglrkglr

          187k10203421




          187k10203421












          • $begingroup$
            Thank you very much!
            $endgroup$
            – Wombles
            1 hour ago










          • $begingroup$
            @Wombles, you are welcome.
            $endgroup$
            – kglr
            1 hour ago


















          • $begingroup$
            Thank you very much!
            $endgroup$
            – Wombles
            1 hour ago










          • $begingroup$
            @Wombles, you are welcome.
            $endgroup$
            – kglr
            1 hour ago
















          $begingroup$
          Thank you very much!
          $endgroup$
          – Wombles
          1 hour ago




          $begingroup$
          Thank you very much!
          $endgroup$
          – Wombles
          1 hour ago












          $begingroup$
          @Wombles, you are welcome.
          $endgroup$
          – kglr
          1 hour ago




          $begingroup$
          @Wombles, you are welcome.
          $endgroup$
          – kglr
          1 hour ago











          1












          $begingroup$

          Here is one way:



          bb = b - 1;
          
c = Complement[bb, {Min[bb]}];
          
Transpose[{Take[b, Length[a]], ConstantArray["---", Length[a]], c, a}] // TableForm


          Here is the output:



          enter image description here






          share|improve this answer











          $endgroup$













          • $begingroup$
            I wish I knew more about string manipulation to get the first three columns to combine to one column of text!
            $endgroup$
            – mjw
            1 hour ago










          • $begingroup$
            You might want ToString and StringJoin
            $endgroup$
            – MarcoB
            1 hour ago
















          1












          $begingroup$

          Here is one way:



          bb = b - 1;
          
c = Complement[bb, {Min[bb]}];
          
Transpose[{Take[b, Length[a]], ConstantArray["---", Length[a]], c, a}] // TableForm


          Here is the output:



          enter image description here






          share|improve this answer











          $endgroup$













          • $begingroup$
            I wish I knew more about string manipulation to get the first three columns to combine to one column of text!
            $endgroup$
            – mjw
            1 hour ago










          • $begingroup$
            You might want ToString and StringJoin
            $endgroup$
            – MarcoB
            1 hour ago














          1












          1








          1





          $begingroup$

          Here is one way:



          bb = b - 1;
          
c = Complement[bb, {Min[bb]}];
          
Transpose[{Take[b, Length[a]], ConstantArray["---", Length[a]], c, a}] // TableForm


          Here is the output:



          enter image description here






          share|improve this answer











          $endgroup$



          Here is one way:



          bb = b - 1;
          
c = Complement[bb, {Min[bb]}];
          
Transpose[{Take[b, Length[a]], ConstantArray["---", Length[a]], c, a}] // TableForm


          Here is the output:



          enter image description here







          share|improve this answer














          share|improve this answer



          share|improve this answer








          edited 1 hour ago

























          answered 1 hour ago









          mjwmjw

          4228




          4228












          • $begingroup$
            I wish I knew more about string manipulation to get the first three columns to combine to one column of text!
            $endgroup$
            – mjw
            1 hour ago










          • $begingroup$
            You might want ToString and StringJoin
            $endgroup$
            – MarcoB
            1 hour ago


















          • $begingroup$
            I wish I knew more about string manipulation to get the first three columns to combine to one column of text!
            $endgroup$
            – mjw
            1 hour ago










          • $begingroup$
            You might want ToString and StringJoin
            $endgroup$
            – MarcoB
            1 hour ago
















          $begingroup$
          I wish I knew more about string manipulation to get the first three columns to combine to one column of text!
          $endgroup$
          – mjw
          1 hour ago




          $begingroup$
          I wish I knew more about string manipulation to get the first three columns to combine to one column of text!
          $endgroup$
          – mjw
          1 hour ago












          $begingroup$
          You might want ToString and StringJoin
          $endgroup$
          – MarcoB
          1 hour ago




          $begingroup$
          You might want ToString and StringJoin
          $endgroup$
          – MarcoB
          1 hour ago


















          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%2f192750%2fformatting-a-table-to-look-nice%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

          Why is a white electrical wire connected to 2 black wires?

          Image
          1 I just opened my ceiling light to replace it with another mount. I see a white wire connected to 2 black wires, is that right? The middle switch controls this ceiling light. electrical ceiling light share | improve this question asked 4 hours ago konyak konyak 108 4 New contributor konyak is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct. ...
          Read more

          Waikiki

          Image
          Denne artikkelen kan ha godt av ein språkvask , som reinskar opp målføringa og/eller innfører same språkstilen overalt. Denne artikkelen kan ha godt av ei opprydding for å nå ein høgare standard og/eller for å verta i tråd med standardoppsettet. Sjå korleis du redigerer ei side og stilmanualen for hjelp. Waikiki Land   USA Stat Hawaii Stad Honolulu Wikimedia Commons: Waikiki Utsyn over Waikiki Waikīkī er ein bydel i Honolulu, sør på øya Oahu, som er ei av Hawaii-øyane. Waikīkīstranda er ein av dei meste berømte strendene i verda. Waikīkī strekkjer seg langs stillehavskysten og har ei rekkje velrenommerte hotell. Bydelen er Hawaii-turismens høyborg. På Waikīkī Beach står ei statue av den lokale sportsstjerna Duka Kahanamoku. Kjelder | Denne artikkelen bygger på «Waikiki» frå Wikipedia på bokmål, den 4. november 2018. Denne artikkelen manglar kjelder eller referansar . Hjelp Wikipedia med å finna truverdige kjelder...
          Read more

          What are all the squawk codes?

          Image
          2 $begingroup$ I love aviation and I love learning new things about it. I was wondering if anyone knew all of the squawk codes and in particular what squawk 7500 means. squawk-codes share | improve this question edited 15 mins ago Jamiec ♦ 14.8k 4 60 91 asked 5 hours ago Zac Callaghan Zac Callaghan 11 2 New contributor Zac Callaghan is a new co...
          Read more