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