python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - tidyverse

Add rows intermittently throughout data frame

I have data like this: df<-structure(list(username = c("dan.amy", "dan.amy", "dan.amy", "stupidski", "stupidski", "stupidski", "cbu...
test-img

Joe Crozier

r

tidyverse

Votes: 0

Answers: 1

Latest Answer

Here is a dplyr way: library(dplyr) df %>% group_by(username) %>% summarise(username = last(username)) %>% mutate(Department = "Generic Research Department", ...
test-img

TarJae

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

Find the count or frequency over rolling periods by group

Here's my data: Person<-c("Bob","Bob","Bob","Bob","Mary","Mary","Mary","Mary","Sue","Sue","S...
test-img

Tish

r

dplyr

tidyverse

counting

Votes: 0

Answers: 1

Latest Answer

Here's a solution using dplyr: data_final <- data %>% group_by(Person) %>% mutate(Two_year_period = paste(Year,lead(as.numeric(Year)), sep = "-")) %>% # Create new column w...
test-img

Guillermo Garcia

Taking the more recent row of values in R?

if i have the following dataframe: tibble(date = c("2010_quarter_1","2010_quarter_2", "2011_end"), values = c(100,100, 2000)) How can i apply a filter condition so that ...
test-img

Beans On Toast

r

dataframe

dplyr

tidyverse

Votes: 0

Answers: 1

Latest Answer

I think the trick is to make actual dates from the date strings and then just keep the last available date (and also keep the year data) dat <- tibble(date = c("2010_quarter_1","201...
test-img

L Smeets

Posts

Questions

Blogs

Jobs