similar to: SQL like function?

Displaying 20 results from an estimated 11000 matches similar to: "SQL like function?"

2007 Sep 08
2
Problem in installing packages on linux machine...
Hi, I am trying to install RSQLite package on my Fedora workstation. I tried to install other packages as well, but each time I got the same error messages saying "compilation error" and "non zero exit status". Do I have to specify "lib="? I never specified the library path before when I was using Fedora Core 6. Warning in install.packages("RSQLite")
2007 Dec 24
2
R Compilation error on Ubuntu
Hi I bought a new laptop HP dv9500 just a week ago and installed a Ubuntu gutsy ribbon on this laptop. I wanted to install Fedora but there are more threads on Ubuntu, so I decided to install Ubuntu. After hours of struggle in configuring x server/graphic card stuff, I installed R for Gutsy ribbon using "sudo apt-get install g77 r-core'. Now when I tried to install 'sp' package
2008 Feb 04
1
how to get points from SpatialPolygonsDataFrame
Um texto embutido e sem conjunto de caracteres especificado associado... Nome: n?o dispon?vel Url: https://stat.ethz.ch/pipermail/r-help/attachments/20080203/5ea1e3ad/attachment.pl
2008 Jun 28
1
lme4 package
Hi, Could someone explain what this message mean? I was playing with lme4 pacakge but I could not run any models... Error in printMer(object) : no slot of name "dims" for this object of class "table" In addition: Warning message: In printMer(object) : trying to get slot "dims" from an object (class "table") that is not an S4 object
2007 Sep 06
2
problems in read.table
Dear R-users, I have encountered the following problem every now and then. But I was dealing with a very small dataset before, so it wasn't a problem (I just edited the dataset in Openoffice speadsheet). This time I have to deal with many large datasets containing commuting flow data. I appreciate if anyone could give me a hint or clue to get out of this problem. I have a .dat file
2007 Aug 29
1
combining datasets by row
Rusers, I am trying to append multiple .csv files of different dimensions (but # of columns are the same for all .csv files). I do have .csv files whose names are CA1.csv ~ CA100.csv. CA means california and 1 means the first file. So what I have been doing (after googling how to append by row multiple files) was: cleanup_data<-function(state,count) { out<-matrix() for (i in 1:
2012 Jun 29
1
Help for string opeation
Hi R users, I appreciate if you could give me some hint/help on this string operation. Suppose I have a list of string objects in varying sizes like [[1]] [1] "A" [2] "B" [3] "C" [[2]] [1] "D" [2] "E" [[3]] [1] "F" Then I would like to create a vector that contains all elements like [1] "A" "B" "C"
2006 Mar 20
1
exporting graphics
Hi, This is a very fundamental question. I want to export graphical results so that I can place them in an openoffice document. I use Fedora 5. Can anyone help? Thanks in advance. ------------------------------------ Takatsugu Kobayashi PhD Student Indiana University, Dept. Geography
2007 May 10
1
A simple question about PRINCOMP
Hi, I just wonder if this is a rounding error by the princomp command in R. Although this does not make much sense, using a hypothetical dataset, a, a<-matrix(runif(1000),100,10) I did PCA with the princomp, and compared it with the results estimated with the eigen and the prcomp commands. And I found some differences in the results: opposite signs in the loadings; slight differences in
2007 Sep 16
1
(no subject)
Hi, Let me apologize for this simple question. I use 64 bit R on my Fedora Core 6 Linux workstation. A 64 bit R has saved a lot of time. I am sure this is a lot to do with my memory limit, but I cannot import 4.8GB. My workstation has a 8GB RAM, Athlon X2 5600, and 1200W PSU. This PC configuration is the best I could get. I know a bit of C and Perl. Should I use C or Perl to manage this
2007 Apr 19
1
rJava help
Hi, I use Redhat Linux for R. Now I am trying to use the rJava library. I downloaded JRE beta 2 from Sun. I typed root@~]# R CMD javareconf Java interpreter : /usr/bin/java Java version : 1.6.0-beta2 Java home path : /usr/java/jre1.6.0 Java library path: $(JAVA_HOME)/lib/amd64/server:$(JAVA_HOME)/lib/amd64:$(JAVA_HOME)/../lib/amd64::/usr/java/packages/lib/amd64:/lib:/usr/lib JNI linker
2009 Jun 02
1
XenClient:How to install VM
Hello I am trying to boot/install VM on XenClient. I would like to learn the way to install VM. Please teach the example of the operation and config file. (Especially, configuration file of method of displaying screen.) thanks. ========================================= [My Executed History] (1) I made a config file for VM(Windows XP:below). (2) I executed the following commands. # xenvm
2007 Sep 07
3
Delete query in sqldf?
Dear All, Is sqldf equipped with delete queries? I have tried delete queries but with no success. Thanks in advance, Paul
2010 Jul 28
1
sqldf 0.3-5 package or tcltk problem
This is my first post. I am running Mac OS X version 10.6.3. I am running R 2.11.0 GUI 1.33 64 bit. This may or may not be related to sqldf, but I experienced this problem while attempting to use an sqldf query. The same code runs with no problem on my Windows machine. Here is what happens: > r=sqldf("select ... ") Loading required package: tcltk Loading Tcl/Tk interface ... Then
2007 Sep 07
2
Automatic detachment of dependent packages
Dear All, When one loads certain packages, some other dependent packages are loaded as well. Is there some way of detaching them automatically when one detaches the first package loaded? For instance, > library(sqldf) Loading required package: RSQLite Loading required package: DBI Loading required package: gsubfn Loading required package: proto but > detach(package:sqldf) > >
2009 Jan 16
5
Value Lookup from File without Slurping
Dear all, I have a repository file (let's call it repo.txt) that contain two columns like this: # tag value AAA 0.2 AAT 0.3 AAC 0.02 AAG 0.02 ATA 0.3 ATT 0.7 Given another query vector > qr <- c("AAC", "ATT") I would like to find the corresponding value for each query above, yielding: 0.02 0.7 However, I want to avoid slurping whole repo.txt
2008 Feb 28
8
How to read HUGE data sets?
Dear R-list, Does somebody know how can I read a HUGE data set using R? It is a hapmap data set (txt format) which is around 4GB. After read it, I need to delete some specific rows and columns. I'm running R 2.6.2 patched over XP SP2 using a 2.4 GHz Core 2-Duo processor and 4GB RAM. Any suggestion would be appreciated. Thanks in advance, Jorge [[alternative HTML version deleted]]
2010 Nov 15
5
How to Read a Large CSV into a Database with R
Hi, I'm working in R 2.11.1 x64 on Windows x86_64-pc-mingw32. I'm trying to insert a very large CSV file into a SQLite database. I'm pretty new to working with databases in R, so I apologize if I'm overlooking something obvious here. I'm trying to work with the American Community Survey data, which is two 1.3GB csv files. I have enough RAM to read one of them into memory,
2007 Nov 13
7
combine two dataframe
I have two data frame A and B adn want to cross them. A has format as: a1 a2 a3 1 2 3 2 3 1 1 3 2 ... B: b1 b2 1 2 2 1 ... the combine result shall be something like a1 a2 a3 b1 b2 1 2 3 1 2 1 2 3 2 1 2 3 1 1 2 2 3 1 2 1 1 3 2 1 2 1 3 2 2 1 .... is there a function able of doing this instead of loops? Thanks, Sun
2007 Jul 19
1
package NULL not found
In performing Rcmd check I am getting this output regarding using Argument '' and a NULL package not found and it stops with an error: * using log directory 'C:/Rpkgs/sqldf.Rcheck' * using ARGUMENT ' ' __ignored__ R version 2.5.1 (2007-06-27) * checking for file 'sqldf/DESCRIPTION' ... OK * this is package 'sqldf' version '0.1-0' * checking package