in Education by
Want to remove the lines from data frame from that : Have NAs across all columns a b c d e f 1 YASH00000206234 0 NA NA NA NA 2 YASH00000199774 0 2 2 2 2 3 YASH00000221722 0 NA NA NA NA 4 YASH00000207704 0 NA NA 1 2 5 YASH00000207531 0 NA NA NA NA 6 YASH00000221412 0 1 2 3 2 I would like to get the data frame as follows : a b c d e f 2 YASH00000199774 0 2 2 2 2 6 YASH00000221412 0 1 2 3 2 Have NAs in only some columns and the result I will get: a b c d e f 2 YASH00000199774 0 2 2 2 2 4 YASH00000207704 0 NA NA 1 2 6 YASH00000221412 0 1 2 3 2 Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
(a)To remove all rows with NA values, we use na.omit() function. In your case: final <- na.omit(dataframe) Output: a b c d e f 2 YASH00000199774 0 2 2 2 2 6 YASH00000221412 0 1 2 3 2 (b)To remove rows with NA by selecting particular columns from a data frame, we use complete.cases() function. In your case: dataframe[complete.cases(dataframe[ , 5:6]),] Output: a b c d e f 2 YASH00000199774 0 2 2 2 2 4 YASH00000207704 0 NA NA 1 2 6 YASH00000221412 0 1 2 3 2 If you want to explore more in R programming then watch this R programming tutorial for beginner:

Related questions

0 votes
    I want to exclude specific participants from a DataFrame and create it from an existing DataFrame. I want a method ... worked for me. Select the correct answer from above options...
asked Jan 23, 2022 in Education by JackTerrance
0 votes
    I have a dataframe: > myvec name order_no 1 Nehal 12 2 sejal 14 3 sejal 16 4 shyam 11 5 Nehal 12 6 Sejal 16 ... Sejal 3 Shyam 1 Ram 1 Select the correct answer from above options...
asked Jan 23, 2022 in Education by JackTerrance
0 votes
    I want a way to create a empty data.frame in R, I just want to point out data types for each column and name it without any row created. df...
asked Jan 24, 2022 in Education by JackTerrance
0 votes
    I want to remove some questions from data frame, I know how to delete them individually using df$x...
asked Jan 23, 2022 in Education by JackTerrance
0 votes
    Can someone please tell me a quick way to convert a nested list of data whose length is 100 and each item is a list of ... 100 rows and 10 columns? I am attaching a sample data: 5...
asked Jan 20, 2022 in Education by JackTerrance
0 votes
    I want to bind two data frames with different set of columns and I also want to retain all the columns that fails to ... do that in R? Select the correct answer from above options...
asked Jan 23, 2022 in Education by JackTerrance
0 votes
    Can someone tell me a function which can return a specified no. of rows picked randomly without any replacement from a DataFrame in R? Select the correct answer from above options...
asked Jan 23, 2022 in Education by JackTerrance
0 votes
    There are two different methods for accessing the element of a list or data frame- [ ] and [[ ]] , ... the difference between them? Select the correct answer from above options...
asked Jan 20, 2022 in Education by JackTerrance
0 votes
    I want to select rows from a DataFrame based on values in some column in pandas, How can I do it? I ... WHERE column_name = some_value Select the correct answer from above options...
asked Jan 22, 2022 in Education by JackTerrance
0 votes
    Here are two data frames : df1 = data.frame(CId = a(1:6), Item = b(rep("TV", 3), rep("Book", 3 ... I do a SQL style select statement Select the correct answer from above options...
asked Jan 20, 2022 in Education by JackTerrance
0 votes
    I have code that at one place ends up with a list of data frames which I really want to convert ... starting with (this is grossly simplified for illustration): listOfDataFrames...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I have a data frame called "newprice" (see below) and I want to change the column names in my program in R. > newprice ... 164 In fact, this is what am doing: names(newprice)[1]...
asked Feb 2, 2022 in Education by JackTerrance
0 votes
    import pandas as pd from itertools import combinations, product, permutations MH_P= ["Maria Herrera"] OP_P= ["Oscar ... i solve it? Select the correct answer from above options...
asked Jan 11, 2022 in Education by JackTerrance
0 votes
    I have a data which consists of two columns "Students" & "points" x...
asked Jan 21, 2022 in Education by JackTerrance
0 votes
    How can I sort a data.frame by multiple columns. E.x. I would like to sort the column q(descending) by column f (ascending) dd...
asked Jan 20, 2022 in Education by JackTerrance
...