similar to: problem in reading large files

Hi, I have a large table in Postgresql (result of an MCMC simulation, with 1 million rows) and I would like to retrive colums (correspond to variables) using RODBC. I have a column called "index" which is used to order rows. Unfortunately, sqlQuery can't return all the values from a column at once (RODBC complains about lack of memory). So I am using the following code:

Chris Lattner wrote: > As such, I'd like to open up a forum for naming ideas. I think we need to > continue to use the name 'LLVM' to refer to the IR (i.e. that which is > described in http://llvm.org/docs/LangRef.html), and we should plan to > attach LLVM as a suffix to the project name for several years to come: For > example: "Use the Foo/LLVM Compiler

After reading the article about rails in OnLamp, I''ve decided to give it a try. In many way it resembles a product that I used to work several years ago, but based on Tcl. So I this might just be what a Pythonier as me needs to try out Ruby. :) Now the problem is, right now the computer where I want to play around with rails doesn''t have net access. I already downloaded the

Dear, I'm doing analysis where I need to work on relatively large (50-60 MB) text files, though I'm really interested only in parts with binary variables (named indicators1, indicators2, ... etc.) Every text file contains other numeric columns, but not always the same and not always in the same order - therefore I would rather need a method connecting to file and reading only colums with

Yep, Wolfgang picked up on the one thing I saw too. This is why I like having people review my stuff. I think it's a bit of a pity that str_offsets_base can point into the middle of a str_offsets contribution in some ways Actually I changed my mind after saying that in the review, and in this writeup I concluded that it cannot do that. str_offsets_base points to the element immediately

Hello Everyone, I've been looking at benchmarks of LLVM recently, and overall they look pretty good. Aside from things that use OpenMP or benefit from autovectorisation, Clang/LLVM and GCC seem to come fairly close, with no overall winner. But: there do seem to have been a number of performance regressions between 2.9 and 3.0: http://openbenchmarking.org/result/1110178-AR-1110173AR66

Hello, I've a data frame with 15 colums and 6000 rows, and I need the data in a single vector of size 90000 for ttest. Is there such a conversion function in R, or would I have to write my own loop over the colums? thanks for your help + kind regards Arne

Hi everybody How do I do to calculate the median and average of a colum of time data like this: "8:50:10". I also need to plot the time difference between two colums Thanks a lot -- View this message in context: http://n4.nabble.com/median-for-time-data-tp932287p932287.html Sent from the R help mailing list archive at Nabble.com.

Anyone here used these phones? I'm getting more and more frustrated by todays modern crop of routers with their so-called SIP ALGs which are invariably broken, or routers with built-in ATAs which block internal SIP phones from working, so looking to use IAX for some end-users. I already support it for people who want to use (eg) Zoiper and use IAX a lot to plumb boxes together, but never

Hi All, I've the following data frame with 54 rows and 4 colums: > x Ratio Dose Time Batch R.010mM.04h.NEW 0.02 010mM 04h NEW R.010mM.04h.NEW.1 0.07 010mM 04h NEW ... R.010mM.24h.NEW.2 0.06 010mM 24h NEW R.010mM.04h.OLD 0.19 010mM 04h OLD ... R.010mM.04h.OLD.1 0.49 010mM 04h OLD R.100mM.24h.OLD 0.40 100mM 24h OLD I'd

Hello, I am experiencing a very noticeable memory leak when using large lists of large data. The code below creates a list of matrices, yet the memory does not free up after removing that item and performing a garbage collection. Is there a something I can do to prevent this memory leak? Any help would be greatly appreciated. By the way, if you execute the code, please run it in a new R session.

Hello, I am a new user of R and I am trying to use the data I am reading from a spreadsheet. I installed the xlsReadWrite package and I am able to read data from this files, but how can I assign the colums into values? E.g: as I read a spreadsheet like this one: A B 1 2 4 9 I manually assign the values: A<-c(1,4) B<-c(2,9) to plot it on a graph: plot(A,B) or make histograms: hist(A) But

Hi, I have the following problem: I have a data.frame with 36 sample sites (colums) for which I have covariates in 3 categories: Area, Month and River. Each Area consists of 3 rivers, which were sampled over 3 month. Now I want to fuse River 1-3 for one area in one month. To get a data.frame with 12 colums. I am trying to do a "for loop" (which may be a complicated solution, but I

I persuaded my friends to convert to Linux, now they want Sketchup! They are the sort of people who would click on anything and I don't want them to get malware etc. Is there a way to make Wine run *only* Sketchup and nothing else? I did try searching for the answer but couldn't find one. Thanks

Hi, I need some help to export a data frame with 83 rows and 1411 colums. I have used the package RODBC until now. But now, I have 1411 colums that I can't send to the old excel. If anybody knows a package to convert my data frame in xlsx tell me! Thanks for help in advance! Pamela Botrel -- View this message in context:

I do not understand some colums in the output to ''shorewall show connections'' /root> shorewall show connections Shorewall-2.0.2f Connections at firewall - Mon Jan 3 13:12:52 PST 2005 .. tcp 6 353296 ESTABLISHED src=112.129.244.121 dst=224.81.133.205 sport=3647 dport=443 src=224.81.133.205 dst=112.129.244.121 sport=443 dport=3647 [ASSURED] use=1 I would like to know

Hi All, I'd like to ask for a few clarifications. I am doing some calculations over some biggish datasets. One has ~ 23000 rows, and 6 columns, the other has ~620000 rows and 6 columns. I am using these datasets to perform a simulation of of haplotype coalescence over a pedigree (the datestes themselves are pedigree information). I created a new dataset (same number of rows as the pedigree

I have a large dataset (~1 million rows) of three variables: ID (patient's name), DATE (of appointment) and DIAGNOSIS (given on that date). Patients may have been assigned more than one diagnosis at any one appointment - leading to two rows, same ID and DATE but different DIAGNOSIS. The diagnoses may change between appointments. I want to subset the data in two ways: - define groups

Hello, I'm trying to set up the flowwing data structure in R: A data frame with 7,000 rows and 4 colums. The rownames have some special meaning (they are names of genes). The 1st column per row is itself a data frame, and columns 2 to 4 will keep numeric values. The data frame contained in the 1st column will have 54 rows (with special names) and 4 colums (1st col is a response, cols 2- 4

Mulberry client-side message filtering can be persuaded to search for a nonexistent message ... <tag> UID SEARCH UNSEEN UNDELETED UNDRAFT 12 (OR FROM "Cron Daemon <sthen at eeyore.37.spacehopper.org>" SUBJECT "Cron <sthen at wide> /home/sthen/pingme") Dovecot 0.99.10 returns this ... <tag> NO Sequence out of range: 12 I *think* the correct