python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - na

Simultaneously remove the first and last rows of a data frame until reaching a row that does not have an NA

I have a dataframe that contains NA values, and I want to remove some rows that have an NA (i.e., not complete cases). However, I only want to remove rows at the beginning and ending of the dataframe....
test-img

AndrewGB

r

dataframe

data.table

tidyverse

na

Votes: 0

Answers: 7

Latest Answer

Another possible solution (thanks, @r2evans, for suggesting complete.cases): library(dplyr) df %>% mutate(aux = !complete.cases(.)) %>% filter(!cumall(aux)) %>% arrange(desc(var1)) ...
test-img

PaulS

Remove last row of data frame until reaching a row that does not have an NA

I have a dataframe that contains NA values, and I want to remove some rows that have an NA (i.e., not complete cases). However, I only want to remove rows at the end of the dataframe. So, I want to ke...
test-img

AndrewGB

r

dataframe

na

Votes: 0

Answers: 3

Latest Answer

We could use na.trim from zoo package: library(zoo) library(dplyr) df %>% slice(1:nrow(na.trim(df, "right", is.na = "any"))) var1 var2 var3 var4 1 1 3 6 NA 2...
test-img

TarJae

R: Merge rows within one Dataframe with different constellation von Data and NAs

I have a dataframe like this: df <- data.frame(ID=c(1,2,3,3,4,4,5), Name=c("Name1","Name2","Name3", "Name3","Name4", "Name4&q...
test-img

Anna Dh

r

merge

rows

na

Votes: 0

Answers: 0

How to use is.na to identify NA, &quot; &quot;, &quot;&quot; etc

I have 2 problems: Problem 1: I am trying to work out how to identify any common missing value formats like NA, " ", "". I thought is.na would identify all of these formats, can so...
test-img

Maree

r

vector

na

missing-data

Votes: 0

Answers: 1

Latest Answer

is.na only detects NA values, not " " nor "". You can convert " " and "" to NA using gsub, and then use is.na: v = c(NA, "", " ", "A&qu...
test-img

Ma&#235;l

Posts

Questions

Blogs

Jobs