Displaying 20 results from an estimated 4000 matches similar to: "R integration with Microsoft Powerpoint"
2005 May 24
2
Missing Data Line Type?
I have a general question. Is there a setting that can be used for a
multiple line type? The situation is that I want a solid line between x
and y points but if the y point is missing, I want a dashed line type to
the next point. In other words, if point 1 to 2 exists, make that line
solid, otherwise, make it dashed up to the next existing x/y point.
Additionally, what plot type would you
2005 Jun 10
2
Default Format for Dates?
Is there anyway to preset date formats? I have a date from a cover.dbf
that is shown as this:
> cover$FINALREPOR
[1] "2003-06-24"
The numeric value in cover$FINALREPOR is 12227. I'd rather not create
another vector to hold the properly formatted date.
When I put this in a WordPerfect merge, I want the date to be June 24,
2003. I could take care of the problem in a
2005 Jun 23
1
Stop Warnings for Invalid Factor Level, NAs generated?
How can I stop the following warning from occuring?
invalid factor level, NAs generated in: "[<-.factor"(`*tmp*`, iseq, value =
structure(1, .Label = "12", class = "factor"))
The Label messages are for "5", "8", "12" and "46". I want the NAs to be
generated as needed.
Is this causing R to slow down by generating the warning
2005 Jun 30
1
how to call egarch of sas in R
I use R to generate data and I need to estimate the data by egarch (that
doesn't have in R). So how I can call egarch from SAS in R.
Regards,
luck
2005 Jul 01
2
the format of the result
I write a function to get the frequency and prop of a variable.
freq<-function(x,digits=3)
{naa<-is.na(x)
nas<-sum(naa)
if (any(naa))
x<-x[!naa]
n<-length(x)
ta<-table(x)
prop<-prop.table(ta)*100
res<-rbind(ta,prop)
rownames(res)<-c("Freq","Prop")
cat("Missing value(s) are",nas,".\n")
cat("Valid case(s)
2005 May 13
3
List and Column Names in a Function?
In this simple function, how can I pass strings for index and column names
to the function? I've posted this type of question before and received no
response.
Maybe this example will be easier to understand and troubleshoot.
ds <- function(myds, vec) {myds[[vec]]*2}
ds1 <- c(X=list(1:10), Y=list(11:20))
ds(get("ds1"),get("Y"))
khobson at odot.org
Kenneth Ray
2005 Apr 22
2
Hoaglin Outlier Method
I am a new user of R so please bear with me. I have reviewed some R books,
FAQs and such but the volume of material is great. I am in the process of
porting my current SAS and SVS Script code to Lotus Approach, R and
WordPerfect.
My question is, can you help me determine the best R method to implement
the Hoaglin Outlier Method? It is used in the Appendix A and B of the fo
llowing link.
2005 Jun 16
3
Excel files first row not being read
hi,
i am using the RODBC package to read excel files using
odbcConnectExcel and susequently sqlFetch to read the contents of the
file.
the file that i use is just a matrix of numbers thats all. no headers
and column names. what happens is that the sqlFetch is not reading my
first row of numbers.
i have tried different combinations of colnames and rownames logical
values but that first row is not
2005 May 31
1
Add Columns and Order for Rbind?
I am using rbind to add one list with one row to another master list. The
problem is that not all columns exist in both lists.
What methods would you recommend to reorder one list based on the column
names of another? If both sets have the same order and columns, I can
then use rbind. I can live with columns being added to the master list set
it makes the task easier using something like
2005 Apr 29
2
Windows List of Folders?
For windows, how can I list only the folders in some folder?
I was thinking that dir() and file.info() with isdir==TRUE being something
that might work.
These folders or directories are numerically named with no dot extension
names or other characters. Typically, these are 3132, 3334, ...
Here is what I tried. The last line is where I need more work.
pData="C:/Myfiles/R/Data/"
setwd
2005 Sep 09
1
PowerPoint graph insertion
Yes: I have Tufte's monograph on my desk. (along with 4 statistics texts)
Yes: I am not the biggest fan of PowerPoint.
Yes: I am using R to generate charts, plots, trends, etc. I have to summarize them each week.
When I consider how to organize this data my first thought is to generate an HTML file with links to the R-generated plots, which HTML file organizes the plots in the required
2005 Apr 29
0
Windows list of Folders
Hi Kenneth:
I tried:
list.files(path="c:\\pctexv4\\samples")
and that worked just fine.
Hope this helps!
Sincerely,
Erin Hodgess
Associate Professor
Department of Computer and Mathematical Sciences
University of Houston - Downtown
mailto: hodgess at gator.uhd.edu
From: khobson at fd9ns01.okladot.state.ok.us
Subject: [R] Windows List of Folders?
X-BeenThere: r-help at
2010 Apr 18
2
how to use Excel VBA's Shell() to call and execute R file
I have an R file R_test.R saved in C:\R_test folder. The R_test.R looks like
this:
setwd("C:/R_test")
rnorm(100)
write(rnorm(100),"data.txt")
q(save="no", runLast = F)
Next I would like use an Excel VBA/macro Shell() function to call R and
execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)*
I wrote an Excel macro RunRcode like this:
Sub
2005 Jun 29
3
return NA
A<-c(1,2,NA,7,5)
B<-c(3,4,1,4,1)
C<-c(6,5,6,NA,9)
D<-c(8,7,4,6,2)
df1<-cbind(A,B,C,D)
for(i in seq(1,ncol(df1)-1, by=2)) {
ifelse(df1[,i]=="NA",df1[,i+1]=="NA",df1[,] ) }
Tried several variations but none worked. I wish to find any NA's in
column's 1 or 3 and change the numerical value to the right of the "
NA"'s . In this case I
2003 Feb 11
4
How "else" works
I have what is likely to be a simple question about the else keyword.
The usage in the help pages is as follows:
if(cond) cons.expr else alt.expr
I would expect to be able to use it in the following way as well:
if(cond){
cons.expr
}
else alt.expr
This results a syntax error.
Am I doing something wrong, or doesn't R support the spanning of the
combination of if and else
2007 Mar 19
4
running VBA code/macros within Linux
Hi,
.
I know you can run Windows applications using WINE (winehq.com), but has
anyone tried, say, running Word or Excel VBA code/macros based on Windows
run time libraries?
.
the thing is that in their faq
(http://www.winehq.com/site/docs/wine-faq/index) they don't even mention
this possibility and searching on; VBA Word, doesn't give you any hits,
even though WINE does link to windows
2003 Jun 09
2
ESRI shapefiles and EMME/2 packages
I just uploaded two packages to CRAN.
shapefiles_0.1.tar.gz - functions to read and write ESRI shapefiles
(including dbfs)
emme2_0.1.tar.gz - functions to read binary data from an EMME/2 databank
data (EMME/2 is a transportation modeling program)
Please let me know if you find any bugs or have some suggestions. Thanks.
Regards,
Benjamin Stabler
Transportation Planning Analysis Unit
Oregon
2003 Oct 31
4
Array Dimension Names
I would like to reference array dimensions by name in an apply and a summary
function. For example:
apply(x, "workers", sum)
Is there a better way to do this than creating a new attribute for the array
and then creating new methods for apply and summary? I don't want to name
the individual elements of each dimension (such as with dimnames) but rather
name the dimensions. Thanks
2002 Sep 18
2
Use of Apply to Change Values in Dataframe
I have a question about how apply() works for changing data values. I am
using it to change NA values to zero, but the question applies to other
value changing operations as well. If I have a dataframe "Dat" with columns
"a", "b" and "c" and there are some NA values in every column:
If I do:
Dat$a[is.na(Dat$a)] <- 0
then all the NA values are changed
2009 Jul 27
1
creating and populating an environment
Hi, I often work with R by writing long(ish) Excel-VBA macros
interspersed with calls to R via RExcel. A typical example of this would
be:
Sub VBAMacro()
'fetch some data from an excel sheet
'do some basic stuff on said data
'transfer data from vba to R
'run some R statements
'get data back to vba
'show results on the excel sheet
'clean R by deleting all vars