Displaying 20 results from an estimated 2000 matches similar to: "Importing data into R"
2004 Oct 06
1
RExcel : problem with error handler?
Dear R-help,
Call RInterface.StartRServer ' Works fine
Call RInterface.RRun("objects()") ' Works fine
Call Rinterface.RRun( other R commands which do not generate errors, the
demos etc ) ' Works fine
But ...
Call RInterface.RRun("doesnotexist") ' Sends Excel into endless loop it
appears
After about 90 seconds a dialog box appears "Microsoft
2004 Nov 14
1
excel/r interface
Dear all,
I am quite new to R and for preofessional reasons I was interested in the R/excel interface by Baier and Neuwirth. After setup I see the Rexcel and the Rhelp on the Menu bar of Microsoft Excel XP. However, after putting the formula =RApply("pchisqr", 30, 1) Excel returns the message "could not start Rserver". Any suggestions how to fix this. How do run this
2009 Sep 18
5
Writing Reports from R in Microsoft Office Open XML format (follow-up)
Dear Duncan and other R users,
The department in which I work will soon make some decisions to
improve our reporting. Since I hope that our solution will support R
and Sweave-like functionality (otherwise it wouldn't be an
improvement....), I hope it's ok to repeat my question back from June
if there are any news on an odfWeave-like package for weaving
Microsoft Word documents? (in the
2006 Sep 20
3
Spliting a huge vector
Dear R users,
I have a huge vector that I would like to split into
unequal slices. However, the only way I can do this is
to create another huge vector to define the groups
that are used to split the original vector, e.g.
# my vector is this
a.vector <- seq(2, by=5, length=100)
# indices where I would like to slice my vector
cut.values <- c(30, 50, 100, 109, 300, 601, 803)
# so I have to
2004 Jun 25
1
help on integration
Dear Sir
I am an analyst based in India, actively working on price analysis and forecasting.
I would request you to let me know is it possible to write front end in MS VB and call R function to do the statistical analysis. The data is inputed through the form designed in VB.
Thank you for the help and clarification.
Best regards
Krishna
---------------------------------
2012 Mar 19
1
How to use R script in VB?
Hello R friends,
I want to use my R script in VB to make macro in Excel.
I tried with RExcel but it seems to me that this package is just GUI API
and I still have to run(connect) R to use the script.
Google tells me there are some ways to make R script as an independent
library/module/header so that I can call it in VB, C or JAVA.
Where can I get detailed tutorial or manual for that?
Thanks in
2005 Apr 18
2
UnauthorizedAccessException in R(D)COM
Dear friends,
I am trying to create a web application to produce some
statistical result using R. In order to avoid high CPU usage of web
server caused by R, I have to create an ASP.NET web service in another
server to involve R.
But I am facing the unauthorizedAccessException when I call the
web service, even I have assigned access and launch permission to everyone
using
2005 Nov 24
4
Survreg Weibull lambda and p
Hi All,
I have conducted the following survival analysis which appears to be OK
(thanks BRipley for solving my earlier problem).
> surv.mod1 <- survreg( Surv(timep1, relall6)~randgrpc, data=Dataset,
dist="weibull", scale = 1)
> summary(surv.mod1)
Call:
survreg(formula = Surv(timep1, relall6) ~ randgrpc, data = Dataset,
dist = "weibull", scale = 1)
2005 May 24
2
reading multiple files
Dear All,
How do I read in multiple data frames or matrices in a
loop, e.g.
for (i in 1:n) {
channel <- odbcConnectExcel("filenames")
file[i] <- as.data.frame(sqlFetch(channel,
"sheet"))
}
I would like file[i] to be the name of the data.frame
(i.e. file[1], file[2], file[3],...etc) rather than a
vector.
Thanks in advance for any help.
Dave
2006 Jan 11
3
Regular expressions
Matching regular expressions
Dear useRs!
I have the following problem. I would like to find objects in my environment
that have two strings in it. For example, I might want to find objects that
have in their names "MY" and "TARGET". I do not care about the ordering of
these two substrings in the name, neither what is in front, behind or
between them, the only thing important
2005 Jun 07
2
reading non-existing files
Dear all,
I'm trying to read to a collection of files in a loop
using odbcConnectExcel - but not all of the files
exist. This is the code I have
for(i in 1:no.of.subs){
channel <- odbcConnectExcel(paste(working.dir,
subs[i], ".xls", sep=""))
datafiles[[i]] <- as.matrix(sqlFetch(channel,
"Data"))
close(channel)
}
I'm not sure how to
2006 Jan 13
3
Taking code from packages
Hello!
I am currently in the process of creating (my first) package, which (when
ready) I intend to publish to CRAN. In the process of creating this package
I have taken some code form existing packages. I have actually copied parts
of functions in to new functions. This code is usually something very basic
such as Rand index. What is the proper procedure for this?
Since most of R (and also the
2009 Aug 31
1
RE xcel - two problems - Running RExcel & Working Directory error
Hi,
I am using RExcel both at work and at home and am facing a couple of
challenges. The one at home is that when using RExcel and trying to run any
code that involves changing the working directory, I get the following
error.
Error in command:
setwd("C:\\Raoul\\R\\R Maps_UK Maps_Test\\NUTS_03M_2006_SH\\shape\\data")\n
cannot change working directory
The one at office is more
2004 Jul 16
6
[Bug 1529] 32bit rollover problem rsyncing files greater than 4GB in size
https://bugzilla.samba.org/show_bug.cgi?id=1529
wayned@samba.org changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
------- Additional Comments From wayned@samba.org 2004-07-14 09:55
2005 Dec 22
1
Problems with passing ... to a function
Dear useRs!
I have written a function that should pass argument "m" to the next
function, however it does not! Please have a look at the function below that
shows a problem and tell me what I am missing. As you can see, the "blocks"
argument is passed corectly, while "m" is not.
Best,
Ales Ziberna
opt.par.new<-function(
#function for optimizig
2006 Jan 04
2
Putting an object in to a function that calls the current function
Hello!
I would like to put an object in to a function that calls the current
function.
I thought the answer will be clear to me after reading the help files:
?assign
?sys.parent
However it is not.
Here is an example I thought should work, however it dose not exactly:
f<-function(){s();print(a)}
s<-function()assign(x="a",value="ok",pos=sys.parent())
f() #I want to get
2005 Dec 14
2
The fastest way to select and execute a few selected functions inside a function
Dear useRs?
I have the following problem! I have a function that calls one or more
functions, depending on the input parameters. I am searching for the fastest
way to select and execute the selected functions and return their results in
a list. The number of possible functions is 10, however usually only 2 are
selected (although sometimes more, even all).
For examples, if I have function
2004 Nov 02
3
Using East-european characters in R
Does anybody know how to produce a East-European character "??" - "c with a
v-shaped hat " in R (in text or plot)?
I do know how to get "??,??" - "s,z, with a v-shaped hat", but not this one.
Thanks in advance for any suggestions,
Ales Ziberna
P.S.: I am using Windows XP and R version 1.9.1 (details below)
$platform
[1]
2012 May 21
16
Contactos en Madrid-ayuda con instalación
Hola a todos,
Mi nombre es Juanjo. Llevo un tiempo intentado hacer funcionar un programa
que necesita de la instalación de RPROJECT y REXCEL. He mirado varias guías
e instalado los programas pero obtengo varios errores.
El principal es que tras instalar RProject, Rexcel y statcon y al intentar
correr esta macro desde Visual Basic…
Sub Start()
RInterface.StartRServer
2005 Feb 04
5
How to access results of survival analysis
Hello,
it seems that the main results of survival analysis with package survival
are shown only as side effects of the print method.
If I compute e.g. a Kaplan-Meier estimate by
> km.survdur<-survfit(s.survdur)
then I can simply print the results by
> km.survdur
Call: survfit(formula = s.survdur)
n events median 0.95LCL 0.95UCL
100.0 58.0 46.8 41.0 79.3
Is