Loop over a data frame comparing elements of the firts and second row











up vote
1
down vote

favorite












I want to loop over a dataframe, I want to compare one of the elements of the actual row and the next row.



for example, I have a data frame that looks like this:



      V1       V2          V3            V4
1 chr1 10 1000 2000
2 chr1 10 2000 3000
3 chr1 10 4000 5000
.
.
.


I would like to compare the element of the 1st row and 4th column with the element of the 2nd row and third column, and if they are the same do something, then the element of the 2nd row and 4th column with the element of the 3th row and 3th column, do something and so on.



So I am trying something like this:



for (i in 1:nrow(my_dataframe)){
if (my_dataframe[i, 4] == my_dataframe[i+1 , 3]) {
print("OK")
}
}


So this would give me for example 1 OK with my example data frame



However it looks that R doesn't like the i + 1, because is giving me the next error:



Error in if (tabla4subset[i, 4] > tabla4subset[i + 1, 3]) { : 
missing value where TRUE/FALSE needed


Some one know how to do this?










share|improve this question














bumped to the homepage by Community 2 days ago


This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.



















    up vote
    1
    down vote

    favorite












    I want to loop over a dataframe, I want to compare one of the elements of the actual row and the next row.



    for example, I have a data frame that looks like this:



          V1       V2          V3            V4
    1 chr1 10 1000 2000
    2 chr1 10 2000 3000
    3 chr1 10 4000 5000
    .
    .
    .


    I would like to compare the element of the 1st row and 4th column with the element of the 2nd row and third column, and if they are the same do something, then the element of the 2nd row and 4th column with the element of the 3th row and 3th column, do something and so on.



    So I am trying something like this:



    for (i in 1:nrow(my_dataframe)){
    if (my_dataframe[i, 4] == my_dataframe[i+1 , 3]) {
    print("OK")
    }
    }


    So this would give me for example 1 OK with my example data frame



    However it looks that R doesn't like the i + 1, because is giving me the next error:



    Error in if (tabla4subset[i, 4] > tabla4subset[i + 1, 3]) { : 
    missing value where TRUE/FALSE needed


    Some one know how to do this?










    share|improve this question














    bumped to the homepage by Community 2 days ago


    This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

















      up vote
      1
      down vote

      favorite









      up vote
      1
      down vote

      favorite











      I want to loop over a dataframe, I want to compare one of the elements of the actual row and the next row.



      for example, I have a data frame that looks like this:



            V1       V2          V3            V4
      1 chr1 10 1000 2000
      2 chr1 10 2000 3000
      3 chr1 10 4000 5000
      .
      .
      .


      I would like to compare the element of the 1st row and 4th column with the element of the 2nd row and third column, and if they are the same do something, then the element of the 2nd row and 4th column with the element of the 3th row and 3th column, do something and so on.



      So I am trying something like this:



      for (i in 1:nrow(my_dataframe)){
      if (my_dataframe[i, 4] == my_dataframe[i+1 , 3]) {
      print("OK")
      }
      }


      So this would give me for example 1 OK with my example data frame



      However it looks that R doesn't like the i + 1, because is giving me the next error:



      Error in if (tabla4subset[i, 4] > tabla4subset[i + 1, 3]) { : 
      missing value where TRUE/FALSE needed


      Some one know how to do this?










      share|improve this question













      I want to loop over a dataframe, I want to compare one of the elements of the actual row and the next row.



      for example, I have a data frame that looks like this:



            V1       V2          V3            V4
      1 chr1 10 1000 2000
      2 chr1 10 2000 3000
      3 chr1 10 4000 5000
      .
      .
      .


      I would like to compare the element of the 1st row and 4th column with the element of the 2nd row and third column, and if they are the same do something, then the element of the 2nd row and 4th column with the element of the 3th row and 3th column, do something and so on.



      So I am trying something like this:



      for (i in 1:nrow(my_dataframe)){
      if (my_dataframe[i, 4] == my_dataframe[i+1 , 3]) {
      print("OK")
      }
      }


      So this would give me for example 1 OK with my example data frame



      However it looks that R doesn't like the i + 1, because is giving me the next error:



      Error in if (tabla4subset[i, 4] > tabla4subset[i + 1, 3]) { : 
      missing value where TRUE/FALSE needed


      Some one know how to do this?







      r






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Jun 18 '17 at 22:38









      Eric González

      3015




      3015





      bumped to the homepage by Community 2 days ago


      This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.







      bumped to the homepage by Community 2 days ago


      This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          I think that I know which was the problem.



          i + 1 = nrow(my_dataframe) + 1 


          So for example, if my data frame is of 10 rows, I am trying to compare at the end the row 10 with the row 11 that doesn't exist. So the solution was:



          for (i in 1:(nrow(my_dataframe)-1)) {
          if(my_dataframe[i, 4] == my_dataframe[i + 1, 3]) {
          print("OK")
          }
          }





          share|improve this answer





















            Your Answer








            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "106"
            };
            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: 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%2funix.stackexchange.com%2fquestions%2f371867%2floop-over-a-data-frame-comparing-elements-of-the-firts-and-second-row%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
            0
            down vote













            I think that I know which was the problem.



            i + 1 = nrow(my_dataframe) + 1 


            So for example, if my data frame is of 10 rows, I am trying to compare at the end the row 10 with the row 11 that doesn't exist. So the solution was:



            for (i in 1:(nrow(my_dataframe)-1)) {
            if(my_dataframe[i, 4] == my_dataframe[i + 1, 3]) {
            print("OK")
            }
            }





            share|improve this answer

























              up vote
              0
              down vote













              I think that I know which was the problem.



              i + 1 = nrow(my_dataframe) + 1 


              So for example, if my data frame is of 10 rows, I am trying to compare at the end the row 10 with the row 11 that doesn't exist. So the solution was:



              for (i in 1:(nrow(my_dataframe)-1)) {
              if(my_dataframe[i, 4] == my_dataframe[i + 1, 3]) {
              print("OK")
              }
              }





              share|improve this answer























                up vote
                0
                down vote










                up vote
                0
                down vote









                I think that I know which was the problem.



                i + 1 = nrow(my_dataframe) + 1 


                So for example, if my data frame is of 10 rows, I am trying to compare at the end the row 10 with the row 11 that doesn't exist. So the solution was:



                for (i in 1:(nrow(my_dataframe)-1)) {
                if(my_dataframe[i, 4] == my_dataframe[i + 1, 3]) {
                print("OK")
                }
                }





                share|improve this answer












                I think that I know which was the problem.



                i + 1 = nrow(my_dataframe) + 1 


                So for example, if my data frame is of 10 rows, I am trying to compare at the end the row 10 with the row 11 that doesn't exist. So the solution was:



                for (i in 1:(nrow(my_dataframe)-1)) {
                if(my_dataframe[i, 4] == my_dataframe[i + 1, 3]) {
                print("OK")
                }
                }






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Jun 19 '17 at 3:04









                Eric González

                3015




                3015






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Unix & Linux 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.


                    To learn more, see our tips on writing great answers.





                    Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                    Please pay close attention to the following guidance:


                    • 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%2funix.stackexchange.com%2fquestions%2f371867%2floop-over-a-data-frame-comparing-elements-of-the-firts-and-second-row%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

                    Accessing regular linux commands in Huawei's Dopra Linux

                    Can't connect RFCOMM socket: Host is down

                    Kernel panic - not syncing: Fatal Exception in Interrupt