Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives 0votes
0answers
52views
How to create 2 new columns in R (date difference + convert Seasons to minutes)?
I am new to R and trying to create two new variables from my dataset.My data frame is called netflix and it contains these relevant columns:date_added and durationExample values:date_added: "...
-3votes
0answers
45views
How can I use a named vector with recode? [duplicate]
Suppose I havedf <- data.frame(name=c("Hello", "Hi", "GoodMorning"))I would like to convert "GoodMorning" into "GoodEvening" (of course this is ...
- 5,386
0votes
2answers
119views
Fill but with a conditional
I have the following dataframe:df <- tribble( ~nuts_code, ~value, "AT", 1, "AT1", NA, "AT2", NA, "BG", NA, "BG1", 10, "BG2"...
- 5,386
1vote
4answers
190views
How to coalesce using a function of other rows?
I have the following tibble:eu_df <- structure( list( nuts_code = c( "PT17", "PT17", "PT17", "PT17", "PT17", "PT17", "PT17", &...
- 5,386
3votes
5answers
179views
index/match equivalent in R for merging data frames in a tidy way
I have two data frames in R that share SOME columns and SOME rows in an arbitrary order.I now want to create a third data frame that has the columns and rows of data frame 1 merged with the ...
- 11.6k
3votes
7answers
331views
Combine columns of a list of dataframes with a custom function
Suppose I have a list of dataframes l. All dataframes are guaranteed to have the same shape and contain the same columns.I would like to combine the columns of those dataframes with a column-specific ...
- 5,386
3votes
1answer
110views
Creating custom dbplyr compatible function in SQL
I'm working with dbplyr and DuckDB to process very large Parquet files using limited system resources. To make my workflow more efficient, I want to create a custom function that can be seamlessly ...
4votes
4answers
296views
How to expand printing of tibble's nested data types (list columns)?
When printing a tibble, how do I print the cells with nested data types (in list columns)? Let's have a look at two examples:1. call data typeb <- tibble(a = 1, prior = list(call("rnorm"...
- 60.2k
3votes
4answers
179views
Two-level unstack in R
Say I have data.frame h like this: component hyperpar x1 i sigma2 1.02 envN sigma2 1.03 envN sigma2_int 0.14 envN sigma2_int ...
- 60.2k
2votes
2answers
118views
Deducting values across a data frame based on condition
I am trying to deduct values across a data frame of elements.structure(list(Date = structure(c(20095, 20095, 20095, 20095, 20123, 20123, 20123, 20123), class = "Date"), Type = c("Drip&...
3votes
3answers
214views
Mutating detection data into binary
Currently I have a dataframe of bear detections that I want to convert into a binary detection history (14 columns of day1, day2, day3, etc. where:actual_date_out = the date the camera was deployed, ...
0votes
1answer
116views
In `dplyr` `filter`， how to parse conditions which are stored in string? [duplicate]
In dplyr filter, how to parse conditions which are stored in string?When there's only one condition, below code can worklibrary(dplyr)conditions_string_1 <- "Species=='versicolor'"iris ...
- 2,547
2votes
3answers
164views
Calculating Overlapping hours / minutes
I have some date/time data that has overlapping minutes/hours and I want to calculate how much there is. I'm a little stumped on how to do this. I prefer a tidyverse solution because I'm more familiar ...
- 422
0votes
2answers
83views
How to keep or recover group names
Sometimes, in case report forms the almost-same entries are inserted on a certain day and for some patient.I want to find similar, possibly misspelled comment, per patient and date. Finding the ...
- 10.3k
0votes
1answer
139views
Extract/ subset rows from df start based on partial match in one column and ends extraction based on second column value
I want to extract information from a large df of multiple .docx files. Using the officer package I have so far read all .docx from a folder into 1 df. However I need a way to extract specific sections ...
- 462
This tag is in a collective: a subcommunity defined by tags with relevant content and experts.
- The Overflow Blog
- Featured on Meta
Hot Network Questions
- Exercise in Mathematical Logic by Ebbinghaus
- Blind Spot Regarding the Correlation Coefficient
- A subset of a rectangle that 'blocks' every curve that goes from right to left must connect upper and lower sides
- If photons are the carriers of the electromagnetic force, why isn't electricity made of photons?
- strange use of вышел
- MinMaxStack - tracks minimum and maximum values
- Permanence of the basic forces
- Do customizable blank-slate protagonists limit the narrative potential of action RPGs?
- Is there some kind of cultural reference behind the SNL "Norwegian Movie" skit?
- Dual nationality citizen registering for EES in Switzerland
- About \def parameter list
- What are the correct lyrics to the song "Lola", by The Kinks?
- What is the point of All In?
- Making a case for a defensive infantry wedge formation
- When exactly does the game clock start during an American football kickoff?
- How many Runway Holding Position markings are needed?
- Sum of the parts
- Simple current source with bjt
- Visualizing Different Coordinate Representations of Complex Numbers
- Diagnosing non-operational wired doorbell
- Status of the tabularray package?
- How do we decide whether a vibration of a solid object is longitudinal or transverse, when the object is not a 1D rod or 1D string?
- Fool a program it has a pty of specific size
- how to define an expandable key-value command?