How do I set the order of a grouped bar chart with Chartify?









up vote
3
down vote

favorite
1












How can users change the order of the grouped bars in the example below?



ch = chartify.Chart(blank_labels=True, x_axis_type='categorical') 
ch.plot.bar(
data_frame=quantity_by_fruit_and_country,
categorical_columns=['fruit', 'country'],
numeric_column='quantity')
ch.show('png')


Grouped bar plot










share|improve this question



























    up vote
    3
    down vote

    favorite
    1












    How can users change the order of the grouped bars in the example below?



    ch = chartify.Chart(blank_labels=True, x_axis_type='categorical') 
    ch.plot.bar(
    data_frame=quantity_by_fruit_and_country,
    categorical_columns=['fruit', 'country'],
    numeric_column='quantity')
    ch.show('png')


    Grouped bar plot










    share|improve this question

























      up vote
      3
      down vote

      favorite
      1









      up vote
      3
      down vote

      favorite
      1






      1





      How can users change the order of the grouped bars in the example below?



      ch = chartify.Chart(blank_labels=True, x_axis_type='categorical') 
      ch.plot.bar(
      data_frame=quantity_by_fruit_and_country,
      categorical_columns=['fruit', 'country'],
      numeric_column='quantity')
      ch.show('png')


      Grouped bar plot










      share|improve this question















      How can users change the order of the grouped bars in the example below?



      ch = chartify.Chart(blank_labels=True, x_axis_type='categorical') 
      ch.plot.bar(
      data_frame=quantity_by_fruit_and_country,
      categorical_columns=['fruit', 'country'],
      numeric_column='quantity')
      ch.show('png')


      Grouped bar plot







      python data-visualization chartify






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Nov 9 at 17:17









      matt b

      109k56249318




      109k56249318










      asked Nov 9 at 17:16









      chalpert

      1227




      1227






















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          3
          down vote













          The bar plot method has a categorical_order_by parameter that can be used to change the order. As specified in the documentation, set it equal to values or labels to sort by those corresponding dimensions.



          For a custom sort, you can pass a list of values to the categorical_order_by parameter. Since the bar is grouped by two dimensions, the list should contain tuples as in the example below:



          from itertools import product
          outside_groups = ['Apple', 'Orange', 'Banana', 'Grape']
          inner_groups = ['US', 'JP', 'BR', 'CA', 'GB']
          sort_order = list(product(outside_groups, inner_groups))

          # Plot the data
          ch = chartify.Chart(blank_labels=True, x_axis_type='categorical')
          ch.plot.bar(
          data_frame=quantity_by_fruit_and_country,
          categorical_columns=['fruit', 'country'],
          numeric_column='quantity',
          categorical_order_by=sort_order)
          ch.show('png')


          enter image description here






          share|improve this answer




















            Your Answer






            StackExchange.ifUsing("editor", function ()
            StackExchange.using("externalEditor", function ()
            StackExchange.using("snippets", function ()
            StackExchange.snippets.init();
            );
            );
            , "code-snippets");

            StackExchange.ready(function()
            var channelOptions =
            tags: "".split(" "),
            id: "1"
            ;
            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',
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            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%2fstackoverflow.com%2fquestions%2f53230465%2fhow-do-i-set-the-order-of-a-grouped-bar-chart-with-chartify%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes








            up vote
            3
            down vote













            The bar plot method has a categorical_order_by parameter that can be used to change the order. As specified in the documentation, set it equal to values or labels to sort by those corresponding dimensions.



            For a custom sort, you can pass a list of values to the categorical_order_by parameter. Since the bar is grouped by two dimensions, the list should contain tuples as in the example below:



            from itertools import product
            outside_groups = ['Apple', 'Orange', 'Banana', 'Grape']
            inner_groups = ['US', 'JP', 'BR', 'CA', 'GB']
            sort_order = list(product(outside_groups, inner_groups))

            # Plot the data
            ch = chartify.Chart(blank_labels=True, x_axis_type='categorical')
            ch.plot.bar(
            data_frame=quantity_by_fruit_and_country,
            categorical_columns=['fruit', 'country'],
            numeric_column='quantity',
            categorical_order_by=sort_order)
            ch.show('png')


            enter image description here






            share|improve this answer
























              up vote
              3
              down vote













              The bar plot method has a categorical_order_by parameter that can be used to change the order. As specified in the documentation, set it equal to values or labels to sort by those corresponding dimensions.



              For a custom sort, you can pass a list of values to the categorical_order_by parameter. Since the bar is grouped by two dimensions, the list should contain tuples as in the example below:



              from itertools import product
              outside_groups = ['Apple', 'Orange', 'Banana', 'Grape']
              inner_groups = ['US', 'JP', 'BR', 'CA', 'GB']
              sort_order = list(product(outside_groups, inner_groups))

              # Plot the data
              ch = chartify.Chart(blank_labels=True, x_axis_type='categorical')
              ch.plot.bar(
              data_frame=quantity_by_fruit_and_country,
              categorical_columns=['fruit', 'country'],
              numeric_column='quantity',
              categorical_order_by=sort_order)
              ch.show('png')


              enter image description here






              share|improve this answer






















                up vote
                3
                down vote










                up vote
                3
                down vote









                The bar plot method has a categorical_order_by parameter that can be used to change the order. As specified in the documentation, set it equal to values or labels to sort by those corresponding dimensions.



                For a custom sort, you can pass a list of values to the categorical_order_by parameter. Since the bar is grouped by two dimensions, the list should contain tuples as in the example below:



                from itertools import product
                outside_groups = ['Apple', 'Orange', 'Banana', 'Grape']
                inner_groups = ['US', 'JP', 'BR', 'CA', 'GB']
                sort_order = list(product(outside_groups, inner_groups))

                # Plot the data
                ch = chartify.Chart(blank_labels=True, x_axis_type='categorical')
                ch.plot.bar(
                data_frame=quantity_by_fruit_and_country,
                categorical_columns=['fruit', 'country'],
                numeric_column='quantity',
                categorical_order_by=sort_order)
                ch.show('png')


                enter image description here






                share|improve this answer












                The bar plot method has a categorical_order_by parameter that can be used to change the order. As specified in the documentation, set it equal to values or labels to sort by those corresponding dimensions.



                For a custom sort, you can pass a list of values to the categorical_order_by parameter. Since the bar is grouped by two dimensions, the list should contain tuples as in the example below:



                from itertools import product
                outside_groups = ['Apple', 'Orange', 'Banana', 'Grape']
                inner_groups = ['US', 'JP', 'BR', 'CA', 'GB']
                sort_order = list(product(outside_groups, inner_groups))

                # Plot the data
                ch = chartify.Chart(blank_labels=True, x_axis_type='categorical')
                ch.plot.bar(
                data_frame=quantity_by_fruit_and_country,
                categorical_columns=['fruit', 'country'],
                numeric_column='quantity',
                categorical_order_by=sort_order)
                ch.show('png')


                enter image description here







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 9 at 17:16









                chalpert

                1227




                1227



























                     

                    draft saved


                    draft discarded















































                     


                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function ()
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53230465%2fhow-do-i-set-the-order-of-a-grouped-bar-chart-with-chartify%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 how show current date and time by default on contact form 7 in WordPress without taking input from user in datetimepicker

                    Syphilis

                    Darth Vader #20