Selecting and removing rows in R dataframes

  Рет қаралды 161,715

Richard Webster

Richard Webster

Күн бұрын

Пікірлер: 37
@toribianco3744
@toribianco3744 4 жыл бұрын
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 жыл бұрын
Just what I needed! Simple and clear! Thanks.
@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!
@alextelzrow7136
@alextelzrow7136 3 жыл бұрын
Holy moly, this was helpful! Thank you for making this.
@CasperLind1
@CasperLind1 2 жыл бұрын
THANKS M8 i have been watch 8 videos this helped!
@agborflavine1523
@agborflavine1523 Ай бұрын
Thank you. Really really really helpful
@tinaluke2454
@tinaluke2454 9 жыл бұрын
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 7 жыл бұрын
hey hows life going
@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
@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”
@Kumars_Take
@Kumars_Take 3 жыл бұрын
How would I do that?
@Kumars_Take
@Kumars_Take 3 жыл бұрын
The columns in this d/f. I hate autocorrect
@StefanoVerugi
@StefanoVerugi 3 жыл бұрын
please try new_df
@sudiptomitra
@sudiptomitra 4 жыл бұрын
How deal with empty/blank cell in a particular column of a data set in R ?
@nikhiljha8717
@nikhiljha8717 6 жыл бұрын
how can we prepare a dataframe from lets say diamonds where "cut" type is ideal, good and very good?
@knowledgesignim8428
@knowledgesignim8428 2 жыл бұрын
How to sum of all prices in column price when against cut is same in cut column in diamonds dataset in R programming
@nooraalagha5588
@nooraalagha5588 4 жыл бұрын
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
@toonybg
@toonybg 7 жыл бұрын
Great tutorial :) Thanks for introducing to dplyr
@Hodbalass
@Hodbalass 7 жыл бұрын
is that Mila Yianapolous?
@Jonpaulim
@Jonpaulim 4 жыл бұрын
Do you mind If I ask a question please
@im_karamo1907
@im_karamo1907 6 жыл бұрын
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
@sebon11
@sebon11 5 жыл бұрын
Great, understendable, with normal accent - helped a lot, thanks
@wardahmustahsan888
@wardahmustahsan888 6 жыл бұрын
Hi Great Vid! Can you do one on the by() function?
@Pidamoussouma
@Pidamoussouma 7 жыл бұрын
very good video....
@mrjigeeshu
@mrjigeeshu 4 жыл бұрын
I was expecting filter based on string column. You didnt talk about it,
@peeyush7434
@peeyush7434 4 жыл бұрын
Very helpful tutorial
@bayudc4782
@bayudc4782 7 жыл бұрын
can i remove specific rows using id?
@miguelsilva4601
@miguelsilva4601 6 жыл бұрын
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.
@abhishekr.p6189
@abhishekr.p6189 4 жыл бұрын
Thanks Lot... For Video
@GulerKatgap-sq1od
@GulerKatgap-sq1od 8 ай бұрын
@CrystalisDota
@CrystalisDota 6 жыл бұрын
canu styop pasting functions randomly .... holy jesus
@shivgan3g
@shivgan3g 9 жыл бұрын
Thanks
Data wrangling with R in 27 minutes
27:19
Equitable Equations
Рет қаралды 30 М.
Loops using R programming
13:37
R Programming 101
Рет қаралды 17 М.
人是不能做到吗?#火影忍者 #家人  #佐助
00:20
火影忍者一家
Рет қаралды 20 МЛН
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
How to treat Acne💉
00:31
ISSEI / いっせい
Рет қаралды 108 МЛН
Beat Ronaldo, Win $1,000,000
22:45
MrBeast
Рет қаралды 158 МЛН
27. All about Dataframes in R
23:36
Anand S
Рет қаралды 11 М.
Top 10 Must-Know {dplyr} Commands for Data Wrangling in R!
8:01
yuzaR Data Science
Рет қаралды 8 М.
Describe and Summarise your data
19:44
R Programming 101
Рет қаралды 58 М.
This Is Why Python Data Classes Are Awesome
22:19
ArjanCodes
Рет қаралды 821 М.
Solving one of PostgreSQL's biggest weaknesses.
17:12
Dreams of Code
Рет қаралды 222 М.
the TRUTH about C++ (is it worth your time?)
3:17
Low Level
Рет қаралды 811 М.
Handle Missing Values: Imputation using R ("mice") Explained
22:47
DataExplained
Рет қаралды 65 М.
人是不能做到吗?#火影忍者 #家人  #佐助
00:20
火影忍者一家
Рет қаралды 20 МЛН