python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - tidyverse

rbind/bind_rows two unequal data.frames

Below, I wonder how to rbind dat2 to dat1 such that I can achieve my Desired_output below? Note that no new columns has to be added. (see the desired output) fit <- lm(mpg ~ hp, data = mtcars) dat...
test-img

Simon Harmel

r

dataframe

dplyr

tidyverse

rbind

Votes: 0

Answers: 2

Latest Answer

A possible solution, which requires names(dat2)[2] <- names(dat1)[4] before binding the rows (there was a mismatch of column names): library(tidyverse) fit <- lm(mpg ~ hp, data = mtcars) dat1 ...
test-img

PaulS

How to sort data in descending order based on every second value in R?

I am using dplyr for most of my data wrangling in R. Yet, I am having a hard time achieving this particular effect. Can't also seem to find the answer by googling either. Assume I have data like this ...
test-img

bajun65537

r

dplyr

tidyverse

tidyr

data-wrangling

Votes: 0

Answers: 2

Latest Answer

One approach using a join: df %>% filter(year == 2021) %>% # group_by(person) %>% slice(2) %>% ungroup() %>% #each person's yr2 arrange(-cash) %>% select(-cash, -year) %>...
test-img

Jon Spring

Run a R script for all files in a directory, and store the outputs in one common data frame

I have a script that works fine for one file. It takes the information from a json file, extracts a list and a sublist of it (A), and then another list B with the third element of list A. It creates a...
test-img

Javi

r

json

dataframe

for-loop

tidyverse

Votes: 0

Answers: 2

Latest Answer

You can do it with purrr::map or purrr::map_dfr. Is this what you looking for? archivos <- list.files("./raw_data", pattern = "json", full.names = TRUE) # load master file and ...
test-img

Alvaro Morales

Error: cannot allocate vector of size 145.6 Mb using RMarkdown

Have been wracking my brain on what to do about this but basically I have written code on a sample set of my data (300k rows) in RMarkdown. Works perfectly. Now I wish to add the following but then I ...
test-img

John Thomas

r

memory-management

odbc

r-markdown

tidyverse

Votes: 0

Answers: 2

Latest Answer

You could try to let SQL do the heavy lifting using dbplyr. So start by connecting to a database and creating a dbplyr specific tibble: library(DBI) library(odbc) library(tidyverse) library(dbplyr) m...
test-img

JBGruber

Posts

Questions

Blogs

Jobs