Displaying 10 results from an estimated 10 matches similar to: "Execute SQL Stored Procedure in R"
2010 Jul 20
3
Sequence from 2 Vectors
I would like to create a vector that is a sequence from 2 vectors. Could
anyone provide suggestion on this?
For example
> a<-c(1,2,3)
> b<-a+2
> b
[1] 3 4 5
I would like to have a vector that is a sequence which starting from a
and ending at b
c = c(1:3,2:4,3:5)
c = c(1,2,3,2,3,4,3,4,5)
Thank you
Best Regards,
Suphajak Ngamlak
Equity and Derivatives Trading
Phatra Securities
2010 Sep 15
2
Get File Names in Folder, Read Files, Update, and Write
Dear All,
Could you please recommend how I can do this?
I have several text files in one folder. Let's name them A0801.RSK,
A0802.RSK, ....
I would like R to
1) Know all file names in this folder
2) Update value in one column of these files
3) Write results in another text file with _xval in the file names
Below is R code for read, update, and write one file
2010 Nov 09
2
Calculate Mean from List
Dear all,
I have a list of correlation coefficient matrixes. Each matrix represents one date.
For example
A[[1]]
A B C
A 1 0.2 0.3
B 0.2 1 0.4
C 0.3 0.4 1
A[[2]]
A B C
A 1 0.5 0.6
B
2011 Sep 07
1
Weight in Function RM
Dear all,
I am trying to do weighted regression using lm function in R. However, I have a question why the results from
1) lm(formula = Y~aX, weight = w)
2) lm(formula = wY~waX)
are different. Aren't they supposed to have the exactly same result?
Below are the R code to see difference in regression results
MatY <- c(0.15,0.42,0.31,0.22)
MatX <-
2010 Aug 04
1
SQLDF from Variable Matrix
Dear all,
I would like to do sample statistics, e.g. mean, median from very large
dataset. This is part of commands I use routinely with several dataset
so I would like to make it into function. The simplified examples are
Test<-data.frame(A=c('a','b','c','a','b','c'),B=c(1,2,3,4,5,6))
#Create function (This one work)
2010 Oct 28
1
bugs when using R-2.12.0 Please HELP!
Hi, R-help group, I kinda meeting a question when using R-2.12.0(Previous
version is 2.10.0):
When I typed "library("Biobase")", everything is alright!
But when I type "library("genefilter")", it doesn't work!
And echo this:
Error in library.dynam(lib, package, package.lib) :
DLL 'RSQLite' not found: maybe not installed for this
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
2010 Nov 01
1
sqldf hanging on macintosh - works on windows
Have a long script that runs fine on windows (32 bit). When I try to run in
on two different macs (64 bit), however, it hangs with identical behavior.
I start with:
library(sqldf)
This results in messages:
Loading required package: DBI
Loading required package: RSQLite
Loading required package: RSQLite.extfuns
Loading required package: gsubfn
Loading required package: proto
Loading required
2010 Jun 27
2
Ways to work with R and Postgres
Hi,
I post this message to the general r-help list hoping anyone within a wider range have suggestions:
There are three ways to integration R and postgres, especially on 64bit Microsoft windows Platform,
1. via RODBC package, which has 32 bit and 64 bit version for windows
2. via RPostgres interface, which only has 32bit version currently
3. via plr for Greenplum, which only supports a
2012 May 21
1
tcktk problem with custom R 2.15.0 build on RHEL5
Hi all,
Please bear with me because I'm not all that familiar with R. I manage a
research cluster that's running Red Hat 5.6 (64-bit), and we recently
installed version 2.15.0 of R for some users. Here's how we built it:
./configure --prefix=/opt/shared/R/2.15.0 --with-tcltk --with-system-zlib --with-system-bzlib --with-system-pcre --with-lapack --enable-R-shlib
When we ran