考虑以下数据帧： set.seed(123) dat1 <- data.frame(Region = rep(c("r1","r2"), each = 100), State = rep(c("NY","MA","FL","GA"), each = 10), Loc = rep(c("a","b","c","d","e","f","g","h"),each = 5), ID = rep(c(1:...

我有以下df +代码示例：（我的df来自01/2016-04/2020） Date A01_Price A02_Price A03_Price A04_Price A05_Price A06_Price A07_Price A08_Price A09_Price A10_Price A11_Price A12_Price A13_Price A14_Price A15_Price 1 2016-01-04 49.5010 21.6400 90.0100 93.676 ...

好的，我正在努力寻找合适的方式来描述我的问题。抱歉，这是一个愚蠢的问题，我仍在学习。 我有一系列小的data.frame，它们的名称定期为“ CountX_YYYY”（X代表特定情况，YYYY代表给定的年份）。我编写了一个函数，该函数首先获取它们的某种类型（X），然后将它们全部绑定并清除id（年份），如下所示： library(dplyr) analysis <- function(case_pattern){ cases <- mget(ls(pattern = case_pattern)) %>...

考虑以下数据框： ID <- rep(c(1, 2,3,4,5)) Sex <- rep(c("Female", "Female","Male", "Female","Male")) Age <- rep(c(NA,55,70,18,19)) size <- rep(c(3, 4,6,2,7)) level <- rep(c("student","student","classmates", "parents","classmates")) data <- data.frame(ID,size,Sex,A...

Sometimes I want to view all rows in a data frame that will be dropped if I drop all rows that have a missing value for any variable. In this case, I'm specifically interested in how to do this with dplyr 1.0's across() function used inside of the filter()...

我有一个很大的（ish）数据框，并且我想使用dplyr mutate函数（或合适的替代方法）来计算所选列的平均值。 例如，假设我有一个数据框，如下所示： colnames(dall) [1] "Code" "LA.Name" "LA_Name" "Jan.20" "Feb.20" "Mar.20" "Apr.20" "May.20" "Jun.20" [10] "Jul.20" "Aug.20" "Sep.20" "Oct.20" "Nov.20" "Dec.20" "Jan....

我正在尝试使用dplyr进行过滤。我只能过滤4组中的1组，对于其他3组，输出将变为空白。 我有以下数据： "29", "29", "30", "30", "30", "30", "4", "4", "4", "4", "4", "5", "5", "5", "5", "5", "6", "6", "6", "6", "16", "16", "16", "16", "17", "17", "17", "17", "17", "18", "18", "18", "18", "52", "52", "52"...

Let's imagine mtcars is an ordered data.frame and that I want the maximum over the previous rows. Then, I can do: > mtcars %>% mutate(test = cummax(wt)) mpg cyl disp hp drat wt qsec vs am gear carb test 1 21.0 6 160.0 110 3.90 2.620 16.46 0 ...

I am trying to recode several variables but with different recode schemes. The recoding scheme is saved in a list where each element is a named vector of the form old = new. Each element is the recoding scheme for each variable in the data frame I am usin...

所有， I have a dplyr sample_n() question. I'm trying to sample with replacement while using the weight option and I seem to be hitting a snag. Namely, sampling with replacement is consistently oversampling a group. It's not a problem I'm getting when samplin...

https://www.kaggle.com/nowke9/ipldata ----- Contains the IPL Data. 这是对IPL数据集进行的探索性研究。 （上面链接的数据链接）将文件“ id”和“ match_id”合并后，我又创建了四个变量，分别是total_extras，total_runs_scored，total_fours_hit和total_sixes_hit。现在，我希望将这些新创建的变量组合到一个数据框中。当我将这些变量分配给单个变量batsman_aggregate并仅选...

有什么办法可以更有效地做到这一点？我想创建一个项目类型的列。每个参与者都有不同数量的项目，所以这确实很棘手。这是我的数据的一个玩具示例 structure(list(id = c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, ...

我已经从MySQL服务器中获取了一些信息到R中，这在我的R数据帧中如下所示： barcode_no Inspection_date current_profile score Tag_log prod_log 12345678 2020-01-15 14:34:13 Large 10 C1 WIP 12345678 2020-01-15 18:33:11 Medium ...

嗨，我正在尝试在数据框中创建一个遵循Boolean true false逻辑的新列。 What I want to say is " if 'SightDate' between 7-15 and 2-15 return TRUE 1 else FALSE [0]" but can't seem to find the syntax for date functions in r. This is what I have so far. #convert SightDate to Month-Day si...

I would like to start by acknowledging that I've asked a similar question before here. I apologise that it is very similar but I've been stuck all day today. My data has changed slightly and the previous code no longer works. Here's the situation. 我有一个包含三列...

我有很多本质上是我想重新编码为整数的变量。 A number of variables are a string with the first character being a digit which corresponds with the integer e.g. 2 = I have considered suicide in the past week, but not made any plans. should be 2. Other variables are yes or no and s...

This questions concerns operation in the language of tidyverse. I am trying to use tidyr::nest and purrr:map2 to perform a bivariate function on two columns of a tibble, replacing them with two other columns which are the result of that bivariate function....

Please, find my data sample ndd below. Question: how can I add a customized legend to this ggplot composed of different geoms? I have tried approaching as described in this thread, but wihtout luck. 我制作了这个情节： However, no matter what I try, I cannot manu...

我有一个要在第二列组之后进行排序的数据集。在第二栏中，有不同的货币名称。所以我想为每种货币创建一个组。 以下是数据集： data = structure(list(repCountry = structure(c(1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L, 2L ), .Label = c("\"AR:Argentina\"", "\"AU:Australia\"", "\"BR:B...

I have a list of corrupted file-paths where in some cases the last directory got melded in with the name of the file (e.g. instead of DIR/analysis/filename.csv it's DIR/analysisfilename.csv). I have created a DF split on / and need to place extract analysi...