Selecting and removing rows in R dataframes

Поділитися
Вставка

КОМЕНТАРІ • 36

  • @toribianco3744
    @toribianco3744 3 роки тому +5

    I have been trying to edit my data for an hour and this is the first video that I had success with!!! THANK YOU

  • @lopezb
    @lopezb 5 років тому +4

    Just what I needed! Simple and clear! Thanks.

  • @toonybg
    @toonybg 7 років тому

    Great tutorial :) Thanks for introducing to dplyr

  • @alextelzrow7136
    @alextelzrow7136 2 роки тому

    Holy moly, this was helpful! Thank you for making this.

  • @ShainaWantsRevenge
    @ShainaWantsRevenge 2 роки тому

    I could marry you. This just helped me figure out how to separate a data set I've been working on for over a week!

  • @CasperLind1
    @CasperLind1 2 роки тому

    THANKS M8 i have been watch 8 videos this helped!

  • @Pidamoussouma
    @Pidamoussouma 6 років тому +1

    very good video....

  • @peeyush7434
    @peeyush7434 3 роки тому

    Very helpful tutorial

  • @wardahmustahsan888
    @wardahmustahsan888 5 років тому

    Hi
    Great Vid! Can you do one on the by() function?

  • @nikhiljha8717
    @nikhiljha8717 5 років тому

    how can we prepare a dataframe from lets say diamonds where "cut" type is ideal, good and very good?

  • @abhishekr.p6189
    @abhishekr.p6189 4 роки тому

    Thanks Lot... For Video

  • @sebon11
    @sebon11 5 років тому +1

    Great, understendable, with normal accent - helped a lot, thanks

  • @shivgan3g
    @shivgan3g 8 років тому

    Thanks

  • @sudiptomitra
    @sudiptomitra 3 роки тому

    How deal with empty/blank cell in a particular column of a data set in R ?

  • @tinaluke2454
    @tinaluke2454 9 років тому +10

    Thanks for the video. What if I wanted to remove rows with certain keywords. In this example, how would I go about removing all rows that have "good" under the column "ideal"?

    • @akashchandra2223
      @akashchandra2223 6 років тому

      hey hows life going

    • @ShainaWantsRevenge
      @ShainaWantsRevenge 2 роки тому +1

      In R, I went to the column that had the answers that I needed to sort by, then I put all the answers I DIDN'T want at the top, then I did the code above to make a new data set!
      Example: I want to remove rows with "good" under the Column "Answer." I go to that column, then sort the data to where answers of "good" are displayed at the top. R will have those row numbers to the left side of the source. Say my data set has 50 participants. Also say that rows 1-10 have answers of "good" as wells 15, 20, 32-35, 37, 40, 45-47. I would then type
      NEWDATASETWITHOUTGOOD

  • @im_karamo1907
    @im_karamo1907 5 років тому

    hELLO sir, in my dataset i have some NA in all the columns. i use na.omit but it returns 0 rows and all the columns present. secondly i took one variable such as dataset$sex to remove all NAs but then the rows is not equal to the other column rows in the main dataset and the remaining rows returns NA again because it isnt equal to the entire rows in the dataset.
    my question is how do i fix this... how do i remove all the NAs and still have the same number of rows in each of the columns?
    need your help thanks

  • @bayudc4782
    @bayudc4782 6 років тому

    can i remove specific rows using id?

  • @Hodbalass
    @Hodbalass 6 років тому

    is that Mila Yianapolous?

  • @nooraalagha5588
    @nooraalagha5588 4 роки тому +1

    Thanks for the video! I have a question I haven't been able to find the answer for. What if I wanted to remove rows with certain keywords, and I have those keywords in a list in another data frame containing only those specific keyword? I need to remove the entire row for the column that contains those keywords. In this example, how would I remove all rows that have a list of 187 words, such as "good" and so on, under the column "ideal"?

    • @msperfect941
      @msperfect941 3 роки тому

      Did you find the answer to this cause I need to know the same thing

    • @ShainaWantsRevenge
      @ShainaWantsRevenge 2 роки тому

      @@msperfect941 In R, I went to the column that had the answers that I needed to sort by, then I put all the answers I DIDN'T want at the top, then I did the code above to make a new data set!
      Example: I want to remove rows with "good" under the Column "Answer." I go to that column, then sort the data to where answers of "good" are displayed at the top. R will have those row numbers to the left side of the source. Say my data set has 50 participants. Also say that rows 1-10 have answers of "good" as wells 15, 20, 32-35, 37, 40, 45-47. I would then type
      NEWDATASETWITHOUTGOOD

  • @knowledgesignim8428
    @knowledgesignim8428 Рік тому

    How to sum of all prices in column price when against cut is same in cut column in diamonds dataset in R programming

  • @GulerKatgap-sq1od
    @GulerKatgap-sq1od 2 місяці тому

  • @mrjigeeshu
    @mrjigeeshu 4 роки тому

    I was expecting filter based on string column. You didnt talk about it,

  • @miguelsilva4601
    @miguelsilva4601 5 років тому

    Hi, very good video.. I have a question.. How extract rows to a new data frame?.. Example.. extract all the rows "good" to a new data frame..

    • @ShainaWantsRevenge
      @ShainaWantsRevenge 2 роки тому

      In R, I went to the column that had the answers that I needed to sort by, then I put all the answers I DIDN'T want at the top, then I did the code above to make a new data set!
      Example: I want to remove rows with "good" under the Column "Answer." I go to that column, then sort the data to where answers of "good" are displayed at the top. R will have those row numbers to the left side of the source. Say my data set has 50 participants. Also say that rows 1-10 have answers of "good" as wells 15, 20, 32-35, 37, 40, 45-47. I would then type
      NEWDATASETWITHOUTGOOD

  • @imp1107
    @imp1107 5 років тому

    10:30 It is 1% not 10%. But informative video anyway.

  • @Kumars_Take
    @Kumars_Take 3 роки тому

    I have a data frame from which I need to select one particular value. The coil limbs in this d/f are Company, Stock_price and Value. I need to select the stock_price for company=“CCC”

  • @Jonpaulim
    @Jonpaulim 3 роки тому

    Do you mind If I ask a question please

  • @CrystalisDota
    @CrystalisDota 5 років тому

    canu styop pasting functions randomly .... holy jesus