search for: dcast

Dear R communitiy, I am trying to use multiple functions for aggregation within a function call for dcast. However this seems to result in an error. Also I have not managed to make dcast() work with fun.aggregate=sd. Please find attached some example code using the ChickWeight data. Many thanks for your help! Jokel #Chick weight example names(ChickWeight) <- tolower(names(ChickWeight)) sd(Chic...

Working with 5 subset streams from my source data frame, three of them successfully call dcast(), but two fail: jerritt.cast <- dcast(jerritt.melt, site + sampdate ~ param) Aggregation function missing: defaulting to length and winters.cast <- dcast(winters.melt, site + sampdate ~ param) Aggregation function missing: defaulting to length Yet both data frames have the values in t...

I need to understand how and why dcast() adds NAs to a data frame that contained no missing values. The database table of chemical concentrations has all missing values removed because they cannot contribute to data analyses. The structure of the R data frame of these data have no NA values, and neither does the data frame resulting...

Hello--I'm doing a simple crosstab using dcast: rawfreq <- dcast(nh11brfs, race3~CHCCOPD, length) with the results race3 Yes No NA 1 White non-Hispanic 446 5473 21 2 Other non-Hispanic 29 211 0 3 Hispanic 6 81 1 4 <NA> 10 83 1 How would I modify this call to exclude all missing v...

Hola a todos, Queria preguntaros si conoceis alguna manera para invertir la funcion dcast. Quiero transformar una matriz en un data frame de tres columnas que indiquen solo los casos donde la combinacion fila-columna sea diferente de NA. Se me habia ocurrido hacer un bucle que fuera seleccionando todos los valores para cada combinacion de fila y columna, pero el problema es que con una...

I'm in the middle of my own little intellectual exercise comparing dcast() and reshape() and have successfully stumped myself. I want to melt() a data frame, then dcast() it into a new form. After doing so, I want to duplicate the process using reshape(). So far, I can do the melt and cast require(reshape2) Raw <- data.frame(site = c(1, 1, 1, 1, 2, 2, 2, 2),...

...1 2 52 TPP 3 3 53 TPP 1 4 54 TPP 2 5 50.1 GPA 9 1 51.1 GPA 11 2 52.1 GPA 8 3 53.1 GPA 8 4 54.1 GPA 10 5 And I want to reshape it into ID TPP GPA 1 1 0 9 2 2 1 11 3 3 3 8 4 4 1 8 5 5 2 10 I realise that dcast function in the reshape2 package can handle much more complicated tasks than that, but I can't make it do a simple one. If I simply tried > dcast(aa, ... ~ Target) Using ID as value column: use value.var to override. Aggregation function missing: defaulting to length Eaten GPA TPP 1...

Hi, I am trying to calculated various summary statistics using the dcast function of reshape2. This works perfectly for getting the mean, sum, length, sd. But when I want to calculate the median I get an error. I tried it with and without removing NAs: my_median <- function(x) median(x, na.rm = FALSE) median_df <- dcast(patch_stats_dfm,formula=species~input+barri...

...8 > Un saludo. Olivier ----- Mensaje original ----- De: "Javier Marcuzzi" <javier.ruben.marcuzzi en gmail.com> Para: "Ruben Bermad" <ruben_bm en hotmail.com>, r-help-es en r-project.org Enviados: Jueves, 11 de Febrero 2016 12:45:02 Asunto: Re: [R-es] Invertir dcast Estimado Ruben Bernard ¿Usted desea algo como sparce matrix? Javier Rubén Marcuzzi De: Ruben Bermad Enviado: jueves, 11 de febrero de 2016 9:40 Para: r-help-es en r-project.org Asunto: [R-es] Invertir dcast Hola a todos, Queria preguntaros si conoceis alguna manera para invertir la funcion dc...

..."fillno2_v3", "fillno3_v2", "fillno3_v3", "fillno4_v2", "fillno4_v3", "fillno5_v2", "fillno5_v3", "fillno6_v2", "fillno6_v3"), class = "data.frame", row.names = c(NA, -3L))   I have tried melt and dcast, but can only get reshape to organize by one measured variable at a time (and not two, as I would like).   For example, the following organizes my data by fill-number and v2:   dcast(DF, person ~ fillno, value.var=c("v2"))   likewise the following works for v3   dcast(DF, person ~ fillno,...

...r datasets is certainly better! Sounds like the adjustments you devised, especially keeping the multicore approach for `make_clean_names()` and ensuring that `ID_Key` values remain intact, were the missing components you needed to fit it into your workflow. I believe the warning message regarding `dcast()` occurs because `keeptabs` is a `tbl_df` from the tidyverse rather than a base `data.frame` or `data.table`. The `data.table` implementation of `dcast()` expects a `data.table` or `data.frame`. When it detects a `tbl_df`, it tries to redirect to `reshape2::dcast()`, but since that appears to be d...

...hat? I have a simple three column data.frame that I would like to reshape to wide preferably using reshape2. An example from http://stackoverflow.com/questions/9617348/reshape-three-column-data-frame-to-matrix looked perfect except I wanted a data frame but it seemed okay. I just changed acast to dcast and it seems fine. Stackoverflow example: tmp <- data.frame(x=gl(2,3, labels=letters[24:25]), y=gl(3,1,6, labels=letters[1:3]), z=c(1,2,3,3,3,2)) dd <- dcast(tmp, x~y, value.var="z") My Example: Does NOT work md2 <- structure(list(group...

...collapse="+"))) data_long <- sort(data_long, f = formula_sort) return(data_long) } reshape_wide <- function(data, ids) { # Bring data into wide form formula_wide <- as.formula(paste(paste(ids, collapse="+"), "~ Data_Points")) data_wide <- dcast(data, formula_wide) # Resort data formula_sort <- as.formula(paste("~", paste(ids, collapse="+"))) data_wide <- sort(data_wide, f = formula_sort) return(data_wide) } d <- data.frame( test_name = c(rep("Test_A", 6), rep("Test_B",...

Hi, I'd like to get mean values for the margins of my casted data.frame. For the casting I am using dcast() from reshape2. However, when I set the margins parameter (margins=c("grand\_row")) I get following error concerning an unrecognized escape character '\_'. So what is the correct command to get the outermost margins only in reshape2? /johannes [[alternative HTML version delete...

...eclean(keeptabs[[i]],c("column1","column2")), mc.cores = numcores) }else{ keeptabs <- lapply(1:length(keeptabs), function(i) crewjanitormakeclean(keeptabs[[i]],c("column1","column2"))) } keeptabs <- bind_rows(keeptabs) out1 <- dcast(keeptabs, ID_Key ~ column1, fun.aggregate = length, value.var = "column1") out2 <- dcast(keeptabs, ID_Key ~ column2, fun.aggregate = length, value.var = "column2") out1 <- setDT(out1 |> rename_with(~ paste0("column1_name_", .x, recycle0 = TRUE), -ID_Ke...

...ID | Page 123 | Choice A 123 | Choice B 456 | Choice A 456 | Choice B ... I thought that I should do the following 1. Make the data set "wide", counting the observations so the data looks like this: ID | Count of Preference A | Count of Preference B 123 | 1 | 1 ... Using table1 <- dcast(data,ID ~ Page,fun.aggregate=length,value_var='Page' ) 2. Create a correlation matrix of preferences cor(table2[,-1]) How would I restrict my correlation to show preferences that met a minimum sample threshold? Can you confirm if the two following commands do the same thing? What would I...

I've successfully reformatted data frames from long to wide with reshape2, but this time I'm getting errors that I want to understand and resolve. Here's the data frame structure and the results of the melt() and dcast() functions: str(waterchem) 'data.frame': 128412 obs. of 8 variables: $ site : Factor w/ 64 levels "D-1","D-2","D-3",..: 1 1 1 1 1 1 1 ... $ sampdate: Date, format: "2007-12-12" "2007-12-12" ... $ preeq0 : logi TRUE TRUE TRUE TR...

...uot;1", "2", "3", "4", "5", "6")) I need to resahpe "example" in a wide format so that ?SENSOR? appear as columns and ?DATE? as rows with corresponding ?VALUE? as value; I thought it was very simple so that I?ve been trying this: dcast(example,DATE~SENSOR) But I've got this message: Using DATE as value column. Use the value argument to cast to override this choice Errore in `[.data.frame`(data, , variables, drop = FALSE) : undefined columns selected and even if by using the value argument sorted out any good result? s...

...ressed representation, then combine results at the end. It's probbaly better to move away from `pivot_wider()` on a massive scale and attempt a data.table-based approach, which is often more memory-efficient and faster for large-scale operations in R. An alternate way would be data.table?s `dcast()` can handle large data more efficiently, and data.table?s in-memory operations often reduce overhead compared to tidyverse pivoting functions. Also - consider using data.table?s `fread()` or `arrow::open_dataset()` directly with `as.data.table()` to keep everything in a data.table format. For ex...

Muchas gracias, pensaba hacerlo en una sola línea pero no anda. Me quedo con dcast así no tengo que cargar más paquetes. Un abrazo! Fernando Macedo El 03/09/16 a las 14:26, Carlos J. Gil Bellosta escribió: > reshape2 + dcast > > El día 3 de septiembre de 2016, 19:23, Fernando Macedo > <fermace en gmail.com> escribió: >> Buenas, estoy intentando hacer un...