similar to: AW: Reading huge chunks of data from MySQL into Windows R

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, 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

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

Dear List, I have two data.frame of the following form: A: n V1 V2 1 12 0 2 10 8 3 3 8 4 8 4 6 7 3 7 12 0 8 1 0 9 18 0 10 1 0 13 2 0 B: n V1 V2 1 0 2 2 0 3 3 1 9 4 12 8 5 2 9 6 2 9 8 2 0 10 4 1 11 7 1 12 0 1 Now I want to merge those frame to one data.frame with summing up the columns V1 and V2 but not the column n. So the result

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

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

I agree with Martin "R Graph Gallery" has a lot of neat stuff. I also think there should be a on CRAN website a list of "R websites". And in a perfect world one of the search engines scope would get extended to search them all. Jarek ====================================================\==== Jarek Tuszynski, PhD. o / \ Science Applications

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

Hello all, I?m trying to take a huge dataset (1.5 GB) and separate it into smaller chunks with R. So far I had nothing but problems. I cannot load the whole dataset in R due to memory problems. So, I instead try to load a few (100000) lines at a time (with read.table). However, R kept crashing (with no error message) at about the 6800000 line. This is extremely frustrating. To try to fix

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 folks A common wisdom here is that one should use a proper hardware phone rather that an extra software on the user's PC. Why is that such a big issue? One thing that bothers me with the current crop of hardware SIP phones is that they are hopelessly properitary. So what would it take to build a fully-adaptable phone? Here are some of my thoughts. This is not anything I plan to do soon

Hi all, I have a problem with using remote MySQL database server with two Asterisk (1.4.17) servers. PhoneA registers with Asterisk#1 using realtime into MySQL on remote server and everything is working fine and when I call Phone A from Phone B (also registered with Asterisk#1) call is established. Problem is when I call PhoneA (which is registered with Asterisk#1) from PhoneC (which is

Sorry to repost this, but it looks like it's getting buried in r-help (originally posted October 5: my experience says that if it hasn't been answered by then it won't be). I wouldn't bother, but I'm worried that r-devel might be better, *and* a previous e-mail of mine on the subject in January also seemed to get buried. Synopsis: boxplot notches look weird when notches are

Classification: UNCLASSIFIED Caveats: NONE Thanks for your quick response. The program you mentioned below available from R is based on number of runs (up or down) not based on a longest length of runs of same events. To be more specific, for example, from a series, HHTHTTTTHHH, the number of runs are 5, and the longest length of runs of the same events is 4. I'll check for the website you

Dear group, Here is my df (obtained with a read.csv2()): df <- structure(list(DESCRIPTION = c("COTTON NO.2 Jul/10", "COTTON NO.2 Jul/10", "PALLADIUM Jun/10", "PALLADIUM Jun/10", "SUGAR NO.11 Jul/10", "SUGAR NO.11 Jul/10"), CREATED.DATE = c("13/05/2010", "13/05/2010", "14/05/2010",

Dear group, Here is my df : df <- structure(list(DESCRIPTION = c("PRM HGH GD ALUMINIUM USD 09/07/10 ", "PRM HGH GD ALUMINIUM USD 09/07/10 ", "PRIMARY NICKEL USD 04/06/10 " ), CREATED.DATE = structure(c(18361, 18361, 18325), class = "Date"), QUANITY = c(-1L, 1L, 1L), CLOSING.PRICE = c("2,415.90", "2,415.90",

Full_Name: M. Edward Borasky Version: 1.2.3 (2001-04-26) OS: Windows 2000 Submission from: (NULL) (206.98.121.224) I have a Celeron with 192 MB of RAM. My paging file is 288 MB, which is the Windows recommended size. Here's the starting screen: -------------------------------------------------------------------------------- R : Copyright 2001, The R Development Core Team Version 1.2.3

Dear group, Here is my data.frame : df <- structure(list(DESCRIPTION = c("PRM HGH GD ALU", "PRM HGH GD ALU", "PRIMARY NICKEL", "PRIMARY NICKEL", "PRIMARY NICKEL", "PRIMARY NICKEL", "STANDARD LEAD ", "STANDARD LEAD ", "STANDARD LEAD ", "STANDARD LEAD ", "STANDARD LEAD ",

I am trying to read a tab-delimited 1.25 GB file of 4,115,119 records each with 52 fields. I am using R 2.11.0 on a 64-bit Windows 7 machine with 8 GB memory. I have tried the two following statements with the same results: d <- read.delim(filename, as.is=TRUE) d <- read.delim(filename, as.is=TRUE, nrows=4200000) I have tried starting R with this parameter but that changed