Re: [R] Equation with double quotes from R to Excel?

2016-05-13 Thread Liao, Hongsheng
s Ecology Old Dominion University 757-683-4571 > options(useFancyQuotes=FALSE) > paste("IF(A2=", dQuote(""), ",", dQuote(""), ",1)", sep="") -Original Message- From: Sarah Goslee [mailto:sarah.gos...@gmail.com] Sent

[R] Equation with double quotes from R to Excel?

2016-05-13 Thread Liao, Hongsheng
I am trying to add an equation with “” from R to an Excel workbook. However, I have found that the Function “setCellFormula” doesn’t take the “” well while a “” in Excel equation stands for a blank cell. I have tried NA(), EMPTY(), etc, and none of them are what I want. Does anyone have

[R] How to make sub-headers in R

2015-05-15 Thread Liao, Hongsheng
I know how to make one-row header for a data frame using colnames. Is there any function to insert sub-header between the first row of the data and the header? Thanks Hongsheng (Hank) Liao, PhD. Lab Manager Center for Quantitative Fisheries Ecology Old Dominion University 757-683-4571

Re: [R] How to make sub-headers in R

2015-05-15 Thread Liao, Hongsheng
Fisheries Ecology Old Dominion University 757-683-4571 -Original Message- From: Jeff Newmiller [mailto:jdnew...@dcn.davis.ca.us] Sent: Friday, May 15, 2015 10:43 AM To: Liao, Hongsheng; r-help@r-project.org Subject: Re: [R] How to make sub-headers in R I think you are not interpreting

Re: [R] How to make sub-headers in R

2015-05-15 Thread Liao, Hongsheng
, sanitize.colnames.function = force, add.to.row = age.addtorow)) -Original Message- From: Boris Steipe [mailto:boris.ste...@utoronto.ca] Sent: Friday, May 15, 2015 11:42 AM To: Liao, Hongsheng Cc: r-help@r-project.org Subject: Re: [R] How to make sub-headers in R I don't see that being

Re: [R] How to make sub-headers in R

2015-05-15 Thread Liao, Hongsheng
To: Liao, Hongsheng Cc: r-help@r-project.org Subject: Re: [R] How to make sub-headers in R Hongsheng - If you can define the fish ages programmatically, you can also get the values into your output. I had understood your sub-header to be constant per column. Does it need to be updated for different

[R] How to make a Latex table using R

2014-05-15 Thread Liao, Hongsheng
http://cran.r-project.org/web/packages/xtable/vignettes/xtableGallery.pdf I am trying to learn how to make a Latex table using R from the link above. However, instead of a Latex table as showed in the link, the R codes from the link generate actual Latex codes as follows: % latex table

[R] Miss lines in LaTex code generated by function xtable in R

2014-05-15 Thread Liao, Hongsheng
data(tli) ## Demonstrate data.frame tli.table - xtable(tli[1:10,]) digits(tli.table)[c(2,6)] - 0 print(tli.table,floating=FALSE) I used above R code to generate Latex code as below. However, Tex Live can't run the code after I code and paste it to Tex Live. The reasons are: at the very

[R] Bhat package and plkhci function

2012-04-24 Thread Liao, Hongsheng
Where can I download Bhat package? I need to use plkhci function in this package, which estimates confidence interval using likelihood ratio. Thanks. Hongsheng (Hank) Liao, PhD. Lab Manager Center for Quantitative Fisheries Ecology Old Dominion University 757-683-4571

[R] Continue to finish for loop even there is an error in one of rounds.

2009-07-30 Thread Liao, Hongsheng
I am trying to fit a logistic model to my 10 year data (1999-2008) by year. Codes like below: Year - c(1999: 2008) for(y in 1:length(year)) { file.input - paste(C:\\, year[y], \\data.csv, sep=) table - read.csv(file=fileinput, header=TRUE, as.is=TRUE, na.strings=c()) initial -