similar to: Aggregating Data

Displaying 20 results from an estimated 225 matches similar to: "Aggregating Data"

2017 Nov 14
0
Aggregating Data
R-Help I created a "shortdate" for the purpose of aggregating each var (S72 .S119) by daily sum , but not sure how to handle using a POSIXlt object. > myData$shortdate <- strftime(myData$time, format="%Y/%m/%d") > head(myData) time s72 s79 s82 s83 s116 s119 shortdate 1 2016-10-03 00:00:00 0 0 1 0 0 0 2016/10/03 2
2018 May 07
1
Discovering patterns in textual strings
Bert Here are some examples of the type of text strings I?m dealing with: ??????.??.??? ??????.??.?????????? ?Torrent? Pro - Torrent App ?Torrent?-Torrent Downloader 1 Pic 8 Words - Syllables 1 Pic 8 Words - Syllables 27043_Spanish songs for children 28.android.com.alpha.horoscope 28.android.com.bravo.horoscope 28.Card Game - Offline 28.card Game Multiplayer 37045_Spanish songs
2018 May 05
2
Discovering patterns in textual strings
"Does that help?" No. I am not your private consultant. You need to reply to the list, which I have cc'ed here, not just me. I am still somewhat confused by your specifications, but others may not be. Part of my confusion stems from your failure to provide a reproducible example (see e.g. the posting guide linked below). For example, I cannot tell from your text whether the Abc
2017 Aug 24
2
likert Package
R- Help Forum Working with the "likert" package and I can't figure out why my "bar" graphs are backwards (see attached). The percentages are place correctly but the bars are backwards. #Sample code # libraries library(likert) # create data band <- c("Band 3","Band 3","Band 3","Band 3","Band 3","Band
2018 May 04
1
Discovering patterns in textual strings
R Help Forum Is there a R library (or a way) that I can extract unique character strings, or repeating patterns in textual strings. Say for example I have the following records: Abc_1234_kjhksh_276 Abc Abc_1234_lakdofyo_324 Bce_876_skdhk_*&^%*& Bce Bce_454 And I would like to see the following results Abc Abc_1234 Bce Jeff Reichman [[alternative HTML version
2018 Mar 13
2
Understanding TS objects
R Help Community I'm trying to understand time series (TS) objects. Thought I understood but recently have run into a series of error messages that I'm not sure how to handle. I have 15 years of quarterly data and I typically create a TS object via something like... data.ts <- ts(mydata, start = 2002, frequency = 4) this create a matric as opposed to a vector object as I receive a
2017 Aug 23
2
likert Package
R- Help Forum Working with the "likert" package and find that my "bar" graphs are backwards (see attached) > summary(results) Item low neutral high mean sd 4 Q4 5 15 80 2.75 0.5501196 5 Q5 20 40 40 2.20 0.7677719 1 Q1 65 30 5 1.40 0.5982430 3 Q3 5 90 5 2.00 0.3244428 2 Q2 90 10 0 1.10 0.3077935
2018 Apr 12
3
Bivariate Normal Distribution Plots
R-Help I am attempting to create a series of bivariate normal distributions. So using the mvtnorm library I have created the following code ... # Standard deviations and correlation sig_x <- 1 sig_y <- 1 rho_xy <- 0.0 # Covariance between X and Y sig_xy <- rho_xy * sig_x *sig_y # Covariance matrix Sigma_xy <- matrix(c(sig_x ^ 2, sig_xy, sig_xy, sig_y ^ 2), nrow = 2, ncol = 2)
2018 May 26
2
Grouping by 3 variable and renaming groups
Hello, See if this is it: priceStore_Grps$StoreID <- paste("Store", seq_len(nrow(priceStore_Grps)), sep = "_") Hope this helps, Rui Barradas On 5/26/2018 2:03 PM, Jeff Reichman wrote: > ALCON > > > > I'm trying to figure out how to rename groups in a data frame after groups > by selected variabels. I am using the dplyr library to
2018 May 26
1
Grouping by 3 variable and renaming groups
Hello, Sorry, but I think my first answer is wrong. You probably want something along the lines of sp <- split(priceStore_Grps, priceStore_Grps$StorePC) res <- lapply(seq_along(sp), function(i){ sp[[i]]$StoreID <- paste("Store", i, sep = "_") sp[[i]] }) res <- do.call(rbind, res) row.names(res) <- NULL Hope this helps, Rui Barradas On
2006 Apr 04
4
Aggregating two objects of the same type
I would like to have a customer that has references to two addresses, a billing address and a shipping address. In a non-rails environment I would have two keys in the customers table, billing_address_id and shipping_address_id to reference the addresses. It appears that ActiveRecord expects the parent id to reside in the child table, regardless of whether the relationship is one-to-one or
2005 Jan 13
4
Aggregating logs from numerous FreeBSD machines
Hi folks, My stack of trusty FreeBSD servers always seems to be growing, and it''s getting to the point where the daily and security output mail is too much to make good use of. I''m looking for suggestions for log monitoring and aggregation tools, especially from a monitoring-for-security perspective. If I had to imagine an ideal system, it would be a central server that
2011 Jun 30
6
aggregating data
Hi, I am interested in using the cast function in R to perform some aggregation. I did once manage to get it working, but have now forgotten how I did this. So here is my dilemma. I have several thousands of probes (about 180,000) corresponding to each gene; what I''d like to do is obtain is a frequency count of the various occurrences of each probes for each gene. The data would look
2005 Mar 29
6
Aggregating data (with more than one function)
I have the data similar to the following in a data frame: LastName Department Salary 1 Johnson IT 56000 2 James HR 54223 3 Howe Finance 80000 4 Jones Finance 82000 5 Norwood IT 67000 6 Benson Sales 76000 7 Smith Sales 65778 8 Baker HR 56778 9 Dempsey HR 78999 10 Nolan
2011 Aug 05
5
Aggregating data
I aggregated my data: aggresults <-aggregate(results, by=list(results$a, results$b, results$c), FUN=mean, na.rm=TRUE) results has about 8000 lines of data, and aggresults has about 80 lines. I would like to create a separate variable for each of the 80 aggregates, each containing the 100 lines that were aggregated. I would also like to create plots for each of those 80 datasets. Is
2005 Jan 31
8
aggregating dates
I have a frame which contains 3 columns: "date" "defectnum" "state" And I want to get the most recent state change for a given defect number. date is POSIXct. I have tried: aggregate(ev$date, by=list(ev$defectnum), max) Which appears to be working except that the dates seem to come back as integers (presumably the internal representation of POSIXct). When I
2004 Apr 22
6
wondershaper, host *exclusion*?
Hi, I really like the wondershaper script, it works very well for me. My question is this. Is there a way to get certain remote hosts to be excluded from the shaping? I ask because I don''t have my box connected directly through the net. It sits behind a nat device, and has ports forwarded in for services. I''d like to limit the ports and services, but only to things going outside
2017 Nov 08
1
Help Converting Calendars
How about > p_dates <- paste0(p.dates[[3]], "-", p.dates[[2]], "-", p.dates[[1]]) > myData$p_dates <- p_dates > print(myData, right=FALSE) dates p_dates 1 2017-10-01 1396-7-9 2 2017-10-02 1396-7-10 3 2017-10-03 1396-7-11 > str(myData) 'data.frame': 3 obs. of 2 variables: $ dates : Date, format: "2017-10-01"
2017 Nov 08
1
Help Converting Calendars
R-Help Trying to convert a Gregorian calendar dataset to a Persian calendar dataset. But I end up with a list and not sure what to do. For example ... dates <- c("2017-10-1","2017-10-2","2017-10-3") myData <- data.frame(dates) myData$dates <- as.Date(myData$dates, format = "%Y-%m-%d") > myData dates 1 2017-10-01 2 2017-10-02 3
2016 Apr 24
2
Dividing rows in groups
Hi I have two data frames as shown below (second one is obtained by aggregating rows of similar IDs in df1.). They both have similar number of columns but rows of df2 are lesser than rows of df1. df1: ID A B 1 1 2 1 0 3 2 5 NA 2 1 3 3 1 4 4 NA NA 4