similar to: merging with aggregating

Dear List, I'm trying to use R under Windows on a huge database in MySQL via ODBC (technical reasons for this...). Now I want to read tables with some 160.000.000 entries into R. I would be lucky if anyone out there has some good hints what to consider concerning memory management. I'm not sure about the best methods reading such huge files into R. for the moment I spilt the whole

Dear Group, Having a character vector like this one: [1] "03:38:55" "07:42:38" "08:04:27" "08:17:13" "08:41:14" "08:46:58" [7] "08:47:11" "08:53:51" "08:57:51" "08:58:56" I try to do a histogram over times of a day. All I want to know, if my solution is proper or if there is another

Dear Group I'm still trying to bring many data into R (see older postings). After solving some troubles with the database I do most of the work in MySQL. But still I could be nice to work on some data using R. Therefore I can use a dedicated Server with Gentoo Linux as OS hosting only R. This Server is a nice machine with two CPU and 4GB RAM which should do the job: Dual Intel XEON 3.06 GHz

I have some time series data like 01/02/1990 0.531 0.479 01/03/1990 0.510 0.522 01/06/1990 0.602 0.604 there is no weekends and holidays. how do I graph them in a single plot that the x-axis is the dates and the y-axis is the time series? Thank you Regards, Jincai Jiang (Office) 212-761-3984 -------------------------------------------------------- This is not an offer (or solicitation

Dear Group, if anyone has experience with the RMySQL Package maybe this behaviour is know: Reading data from a table into R the fields with datatype bigint(20) unsigned are transformed in some way: e.g. the query "select * from orders where userid = 14929859848712890325" selects the correct case but in R the userid is changed to 14929859848712890368. What happened here? This

In my (limited) experience R is more powerful concerning data manipulation. An example: I have a vector holding a user id. Some user ids can appear more than once. Doing SELECT COUNT(DISTINCT userid) on MySQL will take approx. 15 min. Doing length(unique(userid)) will take (almost) no time... So I think the other way round will serve best: Do everything in R and avoid using SQL on the database...

Hi all, I have a question regarding connection of two Asterisk servers to our PBX. Each Asterisk server has one PCI E1 card, and they are in failover mode with Linux HA. On our PBX we have only one E1 card towards Asterisk servers. My question is how to connect these two Asterisks to one E1 card on PBX, and when primary Asterisk server fails not to have to manually pull out E1 cable from primary

Hi, Apologies for the long mail. I have a data.frame with columns of price/mcap data for a portfolio of stocks, and the date. To get the total value of the portfolio on a daily basis, I calculate rowSums of the data.frame. > set.seed(1) > ab <- matrix(round(runif(100)*100),nrow=20,ncol=5) > ab[1:5,4:5] <- NA > ab[6:10,5] <- NA > ac <- as.data.frame(ifelse(ab <=

Hi all, I'm testing Linksys SPA922 phone and I have strange issue. when call is finished on the phone I see "CallEnded" and normal silence for cca. 5 seconds and then I get fast busy for cca. 20 sec. So, this isn't automatic hangup as on other phones I have tried (Cisco 7940, grandstream, XLite,... ) and I have to manually hangup handset to finish a call. Is this normal behavior

Hi all, I have a question regarding using T38 for fax sending and here is my scenario: fax -> SIP ATA (T38 enabled) -> Asterisk #1 -> IAX TRUNK -> Asterisk #2 -> SIP ATA (T38 enabled) -> fax My question is, how can I know if I'm really using T38? is T38 information coming to the other side (because of SIP to IAX conversion) or just plain g711a data? I'm using Linksys

Hi, all together. I have - a maybe trivial - problem with aggregating a list of weights. Here is the problem: - At first I have set of nodes (X/Y-coordinates) and associated weights, where the set of nodes is typically not unique - I want to get a set of unique nodes and the sum of associated weights I am grateful for any help See for example: # weights: w <- c(1, 1, 1, 1, 1) #

Hello, I have a data set that needs to be combined so that rows are summed by a group based on a certain variable. I'm pretty sure rowsum() or rowsums() can do this but it's difficult for me to figure out how it will work for my data based on the examples I've read. My data are structured like this: Plot SizeClass Stems 12 Class3 1 12 Class4

Hello! # I have 3 vectors of values: values1<-rnorm(10) values2<-rnorm(10) values3<-rnorm(10) # In real life, all 3 vectors have a length of 25 # I create all possible combinations of 4 based on 10 elements: mycombos<-expand.grid(1:10,1:10,1:10,1:10) dim(mycombos) # Removing rows that contain pairs of identical values in any 2 of these columns: mycombos<-mycombos[!(mycombos$Var1

Hi I have two irregular time series, which are of different lengths and being and end at different times. For the common subset of time that they both span, they should have the same values, but the values may occur at slightly different time intervals. I am trying to "line up" the identical values and reconcile them. I have merged the two series into a zoo object which looks

Dear everyone, I have looked all over the internet but I cannot find a way to solve my problem. In my data I want to sum a couple of variables. Some of these variables have NA values, and when I add them together, the result is NA dat <- data.frame( id = gl(5,1), var1 = rnorm(5, 10), var2 = rnorm(5, 7), var3 = rnorm(5, 6), var4 = rnorm(5, 3), var5 = rnorm(5, 8) ) dat[3,3] <- NA dat[4,5]

Dear all, I think that my question is very simple but I failed to solve it. I have a list which elements are matrices like this: >mylist [[1]] [,1] [,2] [,3] [1,] 1 3 5 [2,] 2 4 6 [[2]] [,1] [,2] [,3] [1,] 7 9 11 [2,] 8 10 12 I'd like to create a matrix M<-mylist[[1]]+mylist[[2]] [,1] [,2] [,3] [1,] 8 12 16 [2,] 10 14 18

Hi, I would like to sum some specific columns in my matrix- for example, my matrix looks like this: [,1] [,2] [,3] [,4] [,5] [1,] 1 NA NA NA NA [2,] 2 1 NA 1 NA [3,] 3 2 1 2 1 [4,] 4 3 2 3 2 [5,] NA NA NA 4 3 [6,] NA NA NA 5 NA I would like to find the sum of the first two columns, the second two columns and

Folks, I have a data frame with columns 200401, 200402, ..., 201207, 201208. These represent years/months. What would be the best way to sum these columns by year? What about by quarter? Thanks for your time, KW -- [[alternative HTML version deleted]]

I'm interested if anyone can help me to the R to display multiple data elements on one graph - just a simple graph, nothing fancy. I can't seem to find an example of this. An example of what I'm looking for is, say, a CPU graph which graphs user, system, and idle time as a cumulative stack representing each data element as a different color. See the following URL for an example

Hello, I am trying to figure out how to do a sum of items within a row. For example, I have a data frame something like this: A1 B1 ... A2 B2 ... 1 1 4 1 4 2 2 5 2 5 3 3 6 3 6 What I want, is for each row, to get A1 + A2, B1 + B2, etc. which would, perhaps, give me a vector something like this c(2, 8, ... 4, 10 ... 6, 12). Does anyone know of a simple