How to pivot a dataframe with two columns with no index












10















I am trying to pivot my current two column dataframe which currently looks like this:



one   two
a 12
b 32
c 12


I want to pivot this resulting in neither column becoming the index. My expected result is:



 a   b   c 
12 32 12


a, b, and c are the new columns. 12, 32, 12 are the values in the row.



Thanks










share|improve this question









New contributor




macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

























    10















    I am trying to pivot my current two column dataframe which currently looks like this:



    one   two
    a 12
    b 32
    c 12


    I want to pivot this resulting in neither column becoming the index. My expected result is:



     a   b   c 
    12 32 12


    a, b, and c are the new columns. 12, 32, 12 are the values in the row.



    Thanks










    share|improve this question









    New contributor




    macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      10












      10








      10








      I am trying to pivot my current two column dataframe which currently looks like this:



      one   two
      a 12
      b 32
      c 12


      I want to pivot this resulting in neither column becoming the index. My expected result is:



       a   b   c 
      12 32 12


      a, b, and c are the new columns. 12, 32, 12 are the values in the row.



      Thanks










      share|improve this question









      New contributor




      macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      I am trying to pivot my current two column dataframe which currently looks like this:



      one   two
      a 12
      b 32
      c 12


      I want to pivot this resulting in neither column becoming the index. My expected result is:



       a   b   c 
      12 32 12


      a, b, and c are the new columns. 12, 32, 12 are the values in the row.



      Thanks







      python pandas






      share|improve this question









      New contributor




      macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question









      New contributor




      macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question








      edited yesterday







      macyyy33













      New contributor




      macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked yesterday









      macyyy33macyyy33

      1026




      1026




      New contributor




      macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      macyyy33 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.
























          3 Answers
          3






          active

          oldest

          votes


















          5














          Use set_index to move column 'one' into the index, then use T to transpose.



          a.set_index('one').T


          Output:



          one   a   b   c
          two 12 32 12


          Info:



          <class 'pandas.core.frame.DataFrame'>
          Index: 1 entries, two to two
          Data columns (total 3 columns):
          a 1 non-null int64
          b 1 non-null int64
          c 1 non-null int64
          dtypes: int64(3)
          memory usage: 28.0+ bytes
          None





          share|improve this answer































            3














            If this is your input:



            a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
            one two
            0 a 12
            1 b 32
            2 c 12


            Then a.transpose() results in this:



                  0   1   2
            one a b c
            two 12 32 12


            Is this what you were looking for?






            share|improve this answer
























            • You can use a.T for short.

              – Scott Boston
              yesterday





















            2














            Giving everything the same index with .pivot_table



            df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)

            #or with pivot
            df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
            df.columns = [y for _,y in df.columns]

            a b c
            0 12 32 12





            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
              });


              }
              });






              macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.










              draft saved

              draft discarded


















              StackExchange.ready(
              function () {
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54950958%2fhow-to-pivot-a-dataframe-with-two-columns-with-no-index%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









              5














              Use set_index to move column 'one' into the index, then use T to transpose.



              a.set_index('one').T


              Output:



              one   a   b   c
              two 12 32 12


              Info:



              <class 'pandas.core.frame.DataFrame'>
              Index: 1 entries, two to two
              Data columns (total 3 columns):
              a 1 non-null int64
              b 1 non-null int64
              c 1 non-null int64
              dtypes: int64(3)
              memory usage: 28.0+ bytes
              None





              share|improve this answer




























                5














                Use set_index to move column 'one' into the index, then use T to transpose.



                a.set_index('one').T


                Output:



                one   a   b   c
                two 12 32 12


                Info:



                <class 'pandas.core.frame.DataFrame'>
                Index: 1 entries, two to two
                Data columns (total 3 columns):
                a 1 non-null int64
                b 1 non-null int64
                c 1 non-null int64
                dtypes: int64(3)
                memory usage: 28.0+ bytes
                None





                share|improve this answer


























                  5












                  5








                  5







                  Use set_index to move column 'one' into the index, then use T to transpose.



                  a.set_index('one').T


                  Output:



                  one   a   b   c
                  two 12 32 12


                  Info:



                  <class 'pandas.core.frame.DataFrame'>
                  Index: 1 entries, two to two
                  Data columns (total 3 columns):
                  a 1 non-null int64
                  b 1 non-null int64
                  c 1 non-null int64
                  dtypes: int64(3)
                  memory usage: 28.0+ bytes
                  None





                  share|improve this answer













                  Use set_index to move column 'one' into the index, then use T to transpose.



                  a.set_index('one').T


                  Output:



                  one   a   b   c
                  two 12 32 12


                  Info:



                  <class 'pandas.core.frame.DataFrame'>
                  Index: 1 entries, two to two
                  Data columns (total 3 columns):
                  a 1 non-null int64
                  b 1 non-null int64
                  c 1 non-null int64
                  dtypes: int64(3)
                  memory usage: 28.0+ bytes
                  None






                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered yesterday









                  Scott BostonScott Boston

                  55.9k73156




                  55.9k73156

























                      3














                      If this is your input:



                      a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
                      one two
                      0 a 12
                      1 b 32
                      2 c 12


                      Then a.transpose() results in this:



                            0   1   2
                      one a b c
                      two 12 32 12


                      Is this what you were looking for?






                      share|improve this answer
























                      • You can use a.T for short.

                        – Scott Boston
                        yesterday


















                      3














                      If this is your input:



                      a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
                      one two
                      0 a 12
                      1 b 32
                      2 c 12


                      Then a.transpose() results in this:



                            0   1   2
                      one a b c
                      two 12 32 12


                      Is this what you were looking for?






                      share|improve this answer
























                      • You can use a.T for short.

                        – Scott Boston
                        yesterday
















                      3












                      3








                      3







                      If this is your input:



                      a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
                      one two
                      0 a 12
                      1 b 32
                      2 c 12


                      Then a.transpose() results in this:



                            0   1   2
                      one a b c
                      two 12 32 12


                      Is this what you were looking for?






                      share|improve this answer













                      If this is your input:



                      a = pd.DataFrame([("a", 12), ("b", 32), ("c", 12)], columns=["one", "two"])
                      one two
                      0 a 12
                      1 b 32
                      2 c 12


                      Then a.transpose() results in this:



                            0   1   2
                      one a b c
                      two 12 32 12


                      Is this what you were looking for?







                      share|improve this answer












                      share|improve this answer



                      share|improve this answer










                      answered yesterday









                      Niklas MertschNiklas Mertsch

                      473115




                      473115













                      • You can use a.T for short.

                        – Scott Boston
                        yesterday





















                      • You can use a.T for short.

                        – Scott Boston
                        yesterday



















                      You can use a.T for short.

                      – Scott Boston
                      yesterday







                      You can use a.T for short.

                      – Scott Boston
                      yesterday













                      2














                      Giving everything the same index with .pivot_table



                      df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)

                      #or with pivot
                      df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
                      df.columns = [y for _,y in df.columns]

                      a b c
                      0 12 32 12





                      share|improve this answer




























                        2














                        Giving everything the same index with .pivot_table



                        df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)

                        #or with pivot
                        df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
                        df.columns = [y for _,y in df.columns]

                        a b c
                        0 12 32 12





                        share|improve this answer


























                          2












                          2








                          2







                          Giving everything the same index with .pivot_table



                          df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)

                          #or with pivot
                          df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
                          df.columns = [y for _,y in df.columns]

                          a b c
                          0 12 32 12





                          share|improve this answer













                          Giving everything the same index with .pivot_table



                          df.pivot_table(columns='one', index=df.index//len(df), values='two').rename_axis(None, axis=1)

                          #or with pivot
                          df = df.pivot(columns='one', index=df.index//len(df)).rename_axis([None, None], axis=1)
                          df.columns = [y for _,y in df.columns]

                          a b c
                          0 12 32 12






                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered yesterday









                          ALollzALollz

                          14.2k31636




                          14.2k31636






















                              macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.










                              draft saved

                              draft discarded


















                              macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.













                              macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.












                              macyyy33 is a new contributor. Be nice, and check out our Code of Conduct.
















                              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%2f54950958%2fhow-to-pivot-a-dataframe-with-two-columns-with-no-index%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 label and detect the document text images

                              Vallis Paradisi

                              Tabula Rosettana