Pandas: issues with groupby. Error: 'ValueError: Grouper for not 1-dimensional'












0















I've been looking for this error here, but I only found this solution 1 (which doesn't work in my case). Does anybody can guide me on how to solve it?.



My dataset (df2) looks like this: 



      id_cl  id_sup total_t cl_ind  cl_city  sup_ind  sup_city  same_city

0   1000135 1797029  414.85  I5610  11308.0    G4711   10901.0   no

1   1000135 1798069  19.76   I5610  11308.0    G4719   10901.0   no

2   1000135 1923186  302.73  I5610  11308.0    G4630   10901.0   no

3   1000135 2502927  1262.86 I5610  11308.0    G4630   11308.0   yes

4   1000135 2504288  155.04  I5610  11308.0    G4711   11308.0   yes


I need to group this dataset as follows:



df_sup = df2.groupby(['cl_city','cl_ind','same_city']).agg({'id_sup':'nunique', 'total_t':'sum'})


But when performing this, I'm getting this error!:



ValueError: Grouper for 'cl_city' not 1-dimensional


As a result I need something like this: 



                                 id_sup      total_t

cl_city     cl_ind  same_city       

  10701      A0112         no         2    21964.22

                          yes        31     3530.40

             A0122         no      2374 23328061.47

                          yes      1228  2684408.12

             A0127         no        11    19962.68

                          yes         7      915.44

             A0163         no       357   574827.97

                          yes       140     60385.7





python pandas







share|improve this question

























  • What is the output of df2.columns?

    – Peter Leimbigler
    Nov 21 '18 at 22:47











  • as an output I need to know: how many unique 'id_sup' and the sum of 'total_t' of every item of cl_city, cl_ind and same_city. Basically a table with columns: cl_city | cl_ind | same_city | count of unique id_sup | sum of total_T

    – PAstudilloE
    Nov 21 '18 at 22:54











  • Possible duplicate of stackoverflow.com/questions/43298192/…

    – Kevin Fang
    Nov 21 '18 at 22:58








  • 1





    @PAstudilloE, thanks! This does reveal the immediate cause of the error: for some terrible reason, the columns of df2 are a highly nested MultiIndex, where instead of each string being a label, each string is actually the name of a separate *index level*(!) The fix for this comes from stackoverflow.com/q/14507794, and is this: df.columns = [' '.join(col).strip() for col in df.columns.values]. You mentioned df2 is the result of many merges; I suspect those merges are not written optimally, leading to this pathological MultiIndex situation.

    – Peter Leimbigler
    Nov 21 '18 at 23:21






  • 1





    Thanks @PeterLeimbigler!! That's exactly what happened. I solved the issue as you recommended.

    – PAstudilloE
    Nov 21 '18 at 23:26
















0















I've been looking for this error here, but I only found this solution 1 (which doesn't work in my case). Does anybody can guide me on how to solve it?.



My dataset (df2) looks like this: 



      id_cl  id_sup total_t cl_ind  cl_city  sup_ind  sup_city  same_city

0   1000135 1797029  414.85  I5610  11308.0    G4711   10901.0   no

1   1000135 1798069  19.76   I5610  11308.0    G4719   10901.0   no

2   1000135 1923186  302.73  I5610  11308.0    G4630   10901.0   no

3   1000135 2502927  1262.86 I5610  11308.0    G4630   11308.0   yes

4   1000135 2504288  155.04  I5610  11308.0    G4711   11308.0   yes


I need to group this dataset as follows:



df_sup = df2.groupby(['cl_city','cl_ind','same_city']).agg({'id_sup':'nunique', 'total_t':'sum'})


But when performing this, I'm getting this error!:



ValueError: Grouper for 'cl_city' not 1-dimensional


As a result I need something like this: 



                                 id_sup      total_t

cl_city     cl_ind  same_city       

  10701      A0112         no         2    21964.22

                          yes        31     3530.40

             A0122         no      2374 23328061.47

                          yes      1228  2684408.12

             A0127         no        11    19962.68

                          yes         7      915.44

             A0163         no       357   574827.97

                          yes       140     60385.7





python pandas







share|improve this question

























  • What is the output of df2.columns?

    – Peter Leimbigler
    Nov 21 '18 at 22:47











  • as an output I need to know: how many unique 'id_sup' and the sum of 'total_t' of every item of cl_city, cl_ind and same_city. Basically a table with columns: cl_city | cl_ind | same_city | count of unique id_sup | sum of total_T

    – PAstudilloE
    Nov 21 '18 at 22:54











  • Possible duplicate of stackoverflow.com/questions/43298192/…

    – Kevin Fang
    Nov 21 '18 at 22:58








  • 1





    @PAstudilloE, thanks! This does reveal the immediate cause of the error: for some terrible reason, the columns of df2 are a highly nested MultiIndex, where instead of each string being a label, each string is actually the name of a separate *index level*(!) The fix for this comes from stackoverflow.com/q/14507794, and is this: df.columns = [' '.join(col).strip() for col in df.columns.values]. You mentioned df2 is the result of many merges; I suspect those merges are not written optimally, leading to this pathological MultiIndex situation.

    – Peter Leimbigler
    Nov 21 '18 at 23:21






  • 1





    Thanks @PeterLeimbigler!! That's exactly what happened. I solved the issue as you recommended.

    – PAstudilloE
    Nov 21 '18 at 23:26














0












0








0








I've been looking for this error here, but I only found this solution 1 (which doesn't work in my case). Does anybody can guide me on how to solve it?.



My dataset (df2) looks like this: 



      id_cl  id_sup total_t cl_ind  cl_city  sup_ind  sup_city  same_city

0   1000135 1797029  414.85  I5610  11308.0    G4711   10901.0   no

1   1000135 1798069  19.76   I5610  11308.0    G4719   10901.0   no

2   1000135 1923186  302.73  I5610  11308.0    G4630   10901.0   no

3   1000135 2502927  1262.86 I5610  11308.0    G4630   11308.0   yes

4   1000135 2504288  155.04  I5610  11308.0    G4711   11308.0   yes


I need to group this dataset as follows:



df_sup = df2.groupby(['cl_city','cl_ind','same_city']).agg({'id_sup':'nunique', 'total_t':'sum'})


But when performing this, I'm getting this error!:



ValueError: Grouper for 'cl_city' not 1-dimensional


As a result I need something like this: 



                                 id_sup      total_t

cl_city     cl_ind  same_city       

  10701      A0112         no         2    21964.22

                          yes        31     3530.40

             A0122         no      2374 23328061.47

                          yes      1228  2684408.12

             A0127         no        11    19962.68

                          yes         7      915.44

             A0163         no       357   574827.97

                          yes       140     60385.7





python pandas







share|improve this question
















I've been looking for this error here, but I only found this solution 1 (which doesn't work in my case). Does anybody can guide me on how to solve it?.



My dataset (df2) looks like this: 



      id_cl  id_sup total_t cl_ind  cl_city  sup_ind  sup_city  same_city

0   1000135 1797029  414.85  I5610  11308.0    G4711   10901.0   no

1   1000135 1798069  19.76   I5610  11308.0    G4719   10901.0   no

2   1000135 1923186  302.73  I5610  11308.0    G4630   10901.0   no

3   1000135 2502927  1262.86 I5610  11308.0    G4630   11308.0   yes

4   1000135 2504288  155.04  I5610  11308.0    G4711   11308.0   yes


I need to group this dataset as follows:



df_sup = df2.groupby(['cl_city','cl_ind','same_city']).agg({'id_sup':'nunique', 'total_t':'sum'})


But when performing this, I'm getting this error!:



ValueError: Grouper for 'cl_city' not 1-dimensional


As a result I need something like this: 



                                 id_sup      total_t

cl_city     cl_ind  same_city       

  10701      A0112         no         2    21964.22

                          yes        31     3530.40

             A0122         no      2374 23328061.47

                          yes      1228  2684408.12

             A0127         no        11    19962.68

                          yes         7      915.44

             A0163         no       357   574827.97

                          yes       140     60385.7





python pandas




python pandas






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 21 '18 at 23:03







PAstudilloE

















asked Nov 21 '18 at 22:37









PAstudilloEPAstudilloE

142111




142111













  • What is the output of df2.columns?

    – Peter Leimbigler
    Nov 21 '18 at 22:47











  • as an output I need to know: how many unique 'id_sup' and the sum of 'total_t' of every item of cl_city, cl_ind and same_city. Basically a table with columns: cl_city | cl_ind | same_city | count of unique id_sup | sum of total_T

    – PAstudilloE
    Nov 21 '18 at 22:54











  • Possible duplicate of stackoverflow.com/questions/43298192/…

    – Kevin Fang
    Nov 21 '18 at 22:58








  • 1





    @PAstudilloE, thanks! This does reveal the immediate cause of the error: for some terrible reason, the columns of df2 are a highly nested MultiIndex, where instead of each string being a label, each string is actually the name of a separate *index level*(!) The fix for this comes from stackoverflow.com/q/14507794, and is this: df.columns = [' '.join(col).strip() for col in df.columns.values]. You mentioned df2 is the result of many merges; I suspect those merges are not written optimally, leading to this pathological MultiIndex situation.

    – Peter Leimbigler
    Nov 21 '18 at 23:21






  • 1





    Thanks @PeterLeimbigler!! That's exactly what happened. I solved the issue as you recommended.

    – PAstudilloE
    Nov 21 '18 at 23:26



















  • What is the output of df2.columns?

    – Peter Leimbigler
    Nov 21 '18 at 22:47











  • as an output I need to know: how many unique 'id_sup' and the sum of 'total_t' of every item of cl_city, cl_ind and same_city. Basically a table with columns: cl_city | cl_ind | same_city | count of unique id_sup | sum of total_T

    – PAstudilloE
    Nov 21 '18 at 22:54











  • Possible duplicate of stackoverflow.com/questions/43298192/…

    – Kevin Fang
    Nov 21 '18 at 22:58








  • 1





    @PAstudilloE, thanks! This does reveal the immediate cause of the error: for some terrible reason, the columns of df2 are a highly nested MultiIndex, where instead of each string being a label, each string is actually the name of a separate *index level*(!) The fix for this comes from stackoverflow.com/q/14507794, and is this: df.columns = [' '.join(col).strip() for col in df.columns.values]. You mentioned df2 is the result of many merges; I suspect those merges are not written optimally, leading to this pathological MultiIndex situation.

    – Peter Leimbigler
    Nov 21 '18 at 23:21






  • 1





    Thanks @PeterLeimbigler!! That's exactly what happened. I solved the issue as you recommended.

    – PAstudilloE
    Nov 21 '18 at 23:26

















What is the output of df2.columns?

– Peter Leimbigler
Nov 21 '18 at 22:47





What is the output of df2.columns?

– Peter Leimbigler
Nov 21 '18 at 22:47













as an output I need to know: how many unique 'id_sup' and the sum of 'total_t' of every item of cl_city, cl_ind and same_city. Basically a table with columns: cl_city | cl_ind | same_city | count of unique id_sup | sum of total_T

– PAstudilloE
Nov 21 '18 at 22:54





as an output I need to know: how many unique 'id_sup' and the sum of 'total_t' of every item of cl_city, cl_ind and same_city. Basically a table with columns: cl_city | cl_ind | same_city | count of unique id_sup | sum of total_T

– PAstudilloE
Nov 21 '18 at 22:54













Possible duplicate of stackoverflow.com/questions/43298192/…

– Kevin Fang
Nov 21 '18 at 22:58







Possible duplicate of stackoverflow.com/questions/43298192/…

– Kevin Fang
Nov 21 '18 at 22:58






1




1





@PAstudilloE, thanks! This does reveal the immediate cause of the error: for some terrible reason, the columns of df2 are a highly nested MultiIndex, where instead of each string being a label, each string is actually the name of a separate *index level*(!) The fix for this comes from stackoverflow.com/q/14507794, and is this: df.columns = [' '.join(col).strip() for col in df.columns.values]. You mentioned df2 is the result of many merges; I suspect those merges are not written optimally, leading to this pathological MultiIndex situation.

– Peter Leimbigler
Nov 21 '18 at 23:21





@PAstudilloE, thanks! This does reveal the immediate cause of the error: for some terrible reason, the columns of df2 are a highly nested MultiIndex, where instead of each string being a label, each string is actually the name of a separate *index level*(!) The fix for this comes from stackoverflow.com/q/14507794, and is this: df.columns = [' '.join(col).strip() for col in df.columns.values]. You mentioned df2 is the result of many merges; I suspect those merges are not written optimally, leading to this pathological MultiIndex situation.

– Peter Leimbigler
Nov 21 '18 at 23:21




1




1





Thanks @PeterLeimbigler!! That's exactly what happened. I solved the issue as you recommended.

– PAstudilloE
Nov 21 '18 at 23:26





Thanks @PeterLeimbigler!! That's exactly what happened. I solved the issue as you recommended.

– PAstudilloE
Nov 21 '18 at 23:26












1 Answer
1






active

oldest

votes


















0














I don't know why python is showing me that error, df2 is the result of merging several previous datasets and it does not have any duplicate columns.



I solve this issue in a silly way but it worked. I converted df2 to a CSV file and then I load it again. After that, everything is working fine. [But I can't figure out, why python is showing that error]. Hope it helps.






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',
    autoActivateHeartbeat: false,
    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%2f53421406%2fpandas-issues-with-groupby-error-valueerror-grouper-for-something-not-1-d%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









    0














    I don't know why python is showing me that error, df2 is the result of merging several previous datasets and it does not have any duplicate columns.



    I solve this issue in a silly way but it worked. I converted df2 to a CSV file and then I load it again. After that, everything is working fine. [But I can't figure out, why python is showing that error]. Hope it helps.






    share|improve this answer




























      0














      I don't know why python is showing me that error, df2 is the result of merging several previous datasets and it does not have any duplicate columns.



      I solve this issue in a silly way but it worked. I converted df2 to a CSV file and then I load it again. After that, everything is working fine. [But I can't figure out, why python is showing that error]. Hope it helps.






      share|improve this answer


























        0












        0








        0







        I don't know why python is showing me that error, df2 is the result of merging several previous datasets and it does not have any duplicate columns.



        I solve this issue in a silly way but it worked. I converted df2 to a CSV file and then I load it again. After that, everything is working fine. [But I can't figure out, why python is showing that error]. Hope it helps.






        share|improve this answer













        I don't know why python is showing me that error, df2 is the result of merging several previous datasets and it does not have any duplicate columns.



        I solve this issue in a silly way but it worked. I converted df2 to a CSV file and then I load it again. After that, everything is working fine. [But I can't figure out, why python is showing that error]. Hope it helps.







        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 21 '18 at 23:09









        PAstudilloEPAstudilloE

        142111




        142111
































            draft saved

            draft discarded




















































            Thanks for contributing an answer to Stack Overflow!


            • 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%2fstackoverflow.com%2fquestions%2f53421406%2fpandas-issues-with-groupby-error-valueerror-grouper-for-something-not-1-d%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 change which sound is reproduced for terminal bell?

            Image
            3 Recently upgrade to 18.10 from 18.04, and using the terminal is becoming annoying: the new alert sound is a drip ( /usr/share/sounds/gnome/default/alerts/drip.ogg ), and the previous one is still located at ( /usr/share/sounds/ubuntu/stereo/bell.ogg ). My issue is that at the gnome-terminal, when autocompleting or pressing left BOTH sounds are reproduced, at the same time. I want to just have ubuntu/stereo/bell.ogg active, not both . At the moment I have been only able to reduce the volume of the alerts (but still both are played), or turn the alerts down (but I dislike both "solutions"). gnome-terminal 18.10 teminal-bell share | improve this question
            Read more

            Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents

            Image
            up vote 5 down vote favorite 2 I would like to make it so that the vertical space below the title of each chapter is the same when using the Bjornstrup package (i.e. so that the descenders do not affect the spacing - as shown by the red arrow in the picture below). I think I'm fairly happy with the spacing around "A chapter", so I'd really like titles without descenders (e.g. "Contents") to have the same vertical spacing as "A chapter" below the title. I would also like to remove the large "0" in the contents title. Any help appreciated, as always. documentclass[11pt,a4paper]{book} % Packages[![enter image description here][1]][1] usepackage[left=3.5cm, right=3.5cm, top=4.3cm, bottom=4.25cm]{geometry} usepackage[utf8]{inputenc} usepackage{libertine} usepackage[libertine]{newtx
            Read more

            Can I use Tabulator js library in my java Spring + Thymeleaf project?

            Image
            0 I want to add Tabulator js to my java project. I added tabulator.min.js, tabulator.min.css to resources folder. After that added to my html page these dependencies as recommending in readme.md. <link rel="stylesheet" th:href="@{/css/tabulator.min.css}"> <script type="text/javascript" th:src="@{/js/tabulator.min.js}"></script> Now my tables view all elements, that I have in the html page, but not correct. In the documentation of Tabulator is example how to create header and table, var table = new Tabulator("#example-table", { columns:[ {title:"Name", field:"name", sorter:"string", width:200, editor:true}, {title:"Age", field:"age", sorter:"
            Read more