Re: [R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)

read_excel in Hadley’s readxl package should handle your encoding problems. Writing Excel files on a Mac, however, still is somewhat messy. And you probably should post this kind of question on r-sig-mac On 02 Sep 2016, at 13:03, Kai Mx wrote: > > Hi all, > > I am hoping for some advice on h

[R] gene name problem in Excel, and an R analogue

Since many people commenting on the gene name problem in Excel essentially tell us This could never have happened with R I want to show you a somewhat related issue: ff1 <- tempfile() cat(file = ff1, "12345", "1E002", sep = "\n") xdf1 <- read.fwf(ff1, widths = 5, stringsAsFactors=FALSE) ff2 <-

Re: [R] ggplot2: geom_segment does not produce the color I desire?

Here are 2 solutions to you problem: If you only want to use one color (for possibly many arrows), this will work: ggplot()+geom_segment(mapping = aes(x = as.Date(test[,"date"]), y =y1, xend = as.Date(test[,"date"]),

Re: [R] interactive Map: Popups

I am quite happy with that package leaflet which is not yet on CRAN but available on Githib. https://github.com/rstudio/leaflet signature.asc Description: Message signed with OpenPGP using GPGMail __ R-help@r-proje

Re: [R] interactive Map: Popups

kage and its examples. It is awesome! > > Thanks, > Erin > > > On Thu, Jul 23, 2015 at 6:28 AM, Erich Neuwirth <mailto:erich.neuwi...@univie.ac.at>> wrote: > I am quite happy with that package leaflet which is not yet on CRAN > but available on Githib. > > ht

Re: [R] about R 3.2.0

If you are running R on Windows, there is the package installr which will help you with the process of upgrading. And item 2.8 in the R for Windows FAQ has some information about upgrading also. > On 25 Jul 2015, at 06:41, Waqas Shafqat wrote: > > Dear sir, > > I am using currently R 3.1.3. But

Re: [R] transpose a data frame according to a specific variable

library(tidyr) spread(DF,Year,Day) > On 09 Feb 2015, at 16:47, jeff6868 wrote: > > finalDF <- > data.frame(id=c("A","B","C"),"2000"=c(NA,NA,164),"2001"=c(120,NA,99), > "2002"=c(90,18,48),"2003"=c(54,217,NA),"2004"=c(NA,68,NA)) signature.asc Description: Message signed with OpenPGP using G

Re: [R] %>%

AFAIK dplyr imports magrtittr. So dplyr ses %>% from migrittr, it does not have its own version. > On Feb 17, 2015, at 22:19, Ben Bolker wrote: > > David Barron gmail.com> writes: > >> >> It's in the magrittr package. >> >> David > > It also exists in dplyr. > > (I would guess that it's

[R] tcltk problem

OSX 10.10.2 R 3.1.3 XQuartz installed. I am trying to run one of the tcltk demos This one works: tt <- tktoplevel() label.widget <- tklabel(tt, text = "Hello, World!") button.widget <- tkbutton(tt, text = "Push", command = function()cat("OW!\n")) tkpack(label.widget, but

Re: [R] tcltk problem

Thesw are demos for tclscrollbar I copied them from the help file to the console manually as the help file suggested. > On 12 Mar 2015, at 09:04, peter dalgaard wrote: > >> >> On 11 Mar 2015, at 23:41 , Erich Neuwirth > <mailto:erich.neuwi...@univie.ac.at>> wrote:

Re: [R] tcltk problem

. > On 12 Mar 2015, at 09:04, peter dalgaard wrote: > >> >> On 11 Mar 2015, at 23:41 , Erich Neuwirth > <mailto:erich.neuwi...@univie.ac.at>> wrote: >> >> OSX 10.10.2 >> R 3.1.3 >> XQuartz installed. >> >> I am trying to run one of t

Re: [R] Generate random numbers under constrain

You want random numbers within the n-dimensional simplex (sum xi <=1) The easiest solution of course would be creating n-dimensions vectors with iid uniform components on [0,1) and throwing away those violating the inequality. Since the volume of the n-dimensional simplex is 1/n! (factorial) this b

Re: [R] data format

This is the kind of problem the package tidyR has been designed for. > On 19 Aug 2015, at 16:29, minikg wrote: > > Hi, > > I have a dataset consisting of landmarks of each sample's coordinates as > given below. > > landmark X Y X Y X Y > P1 5

Re: [R] Spreadsheet math problem (exponentiation)

Let me add a little bit here: When using math formulas, one should know about the parsing rules form complex expression which do not have all the necessary parenthesis. Different systems do have different parings rules. In the case of a^b^c, the expression is ambiguus because (as mentioned in a

Re: [R] Spreadsheet math problem (exponentiation)

Methinks that any math teaching should make learners aware of the fact that math conventions are not laws of nature, and that ambiguous expressions may produce different values in different systems. I think -2^2=4 is perfectly reasonable. In my experience, most people after high school math do no

Re: [R] ggplot: combining geom's in function

I often look for examples in http://www.cookbook-r.com/Graphs/ > On 23 Oct 2015, at 18:27, Jeff Newmiller wrote: > > Have you looked at the qplot function in the ggplot2 package? > --- > J

Re: [R] Creating new variables in R

data <- within(data,variable3=pmax(variable1,variable2)) also should work if your variables are numeric. using dplyr and magrittr (which I recommend to all my students) it could be library(dplyr) library(magrittr) data %<>% mutate(variable3=pmax(variable1,variable2)) > On 26 Oct 2015, at 12:53

Re: [R] is.na behavior

I am not sure I undestand the issue. But if the question is to decidedif an expression evaluates to NA, using eval should solve the problem. In fact, I do not really understand what an NA expression, and not an expression evaluating to NA, means. signature.asc Description: Message signed with O

Re: [R] Can we use all the functions of R in visual studio? The Rmath.dll and R.dll seems only contain a part of R functions

There is statconnDCOM, whoch gives full R as a COM server which can be used from all he Visual languages. It is not free. There are cost free licenses for student and home use, but essentially it is a commercial product. Mor information can be found at www.statconn.com

Re: [R] choropleth packages (US)

ggplot2 also can do this with fortify geom_polygon Von meinem iPad gesendet > Am 06.12.2015 um 21:03 schrieb Benjamin Tyner : > > Hi > > I wish to draw a basic choropleth (US, by state) and am wondering if anyone > has any recommendations? I've tried the following thus far: > > 1. choroplethr

Re: [R] readRDS problem

?data will show you that data is a reserved word! > On 24 Feb 2016, at 11:02, Sigbert Klinke wrote: > > Hi, > > thanks, using > > test <<- readRDS (name) > > it worked. But why? > > Best Sigbert > > Am 24.02.2016 um 10:39 schrieb Michael Dewey: >> Try calling it something other than data.

Re: [R] .Call works in R 2 not in R 3

cutree is a function available in stats. So it might be worth a try to just replace .Call("R_cutree", tree$merge, k, PACKAGE = "stats”) by cutree(tree$merge,k) and see what happens. checking the source of cutree shows the following call ans <- .Call(C_cutree, tree$merge, k) so replacing

Re: [R] FUNCTION ctree

If you do ??ctree and the package partykit is installed, you will see that this function is defined in this package. So, you should run library(partykit) before running your function call If partykit is not installed, you need to install it. > On Mar 10, 2016, at 15:58, CHIRIBOGA Xavier wro

Re: [R] Persistent state in a function?

package memoise might help you > On 19 Mar 2016, at 17:45, Boris Steipe wrote: > > Dear all - > > I need to have a function maintain a persistent lookup table of results for > an expensive calculation, a named vector or hash. I know that I can just keep > the table in the global environment.

Re: [R] Compute the Gini coefficient

> On 30 Mar 2016, at 02:53, Marine Regis wrote: > > Hello, > > I would like to build a Lorenz curve and calculate a Gini coefficient in > order to find how much parasites does the top 20% most infected hosts support. > > Here is my data set: > > Number of parasites per host: > parasites = c(

[R] Install on Xenial

I am trying to install R-3.3.0 on Xenial. I followed the instructions on the corresponding CRAN page, and I added the GPG key. But after adding deb https://cran.at.r-project.org//bin/linux/ubuntu xenial/ to /etc/apt/sources.list and sudo apt-get update I get the following error: Err:7 https://cra

Re: [R] viewing data in something similar to 'R Data Editor'

On Windows, this could be done with rcom and Excel. rcom can use Excel as a server and put matrices into Excel ranges. The code you run in R could have a statement resending matrices so the current version is displayed. I could set up more conveniently what yo want if RGui had a way of automat

Re: [R] Rounding to the nearest 5

t.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Compu

Re: [R] A matrix calculation

as.vector(t(mat[7:1,])) On Aug 23, 2009, at 9:35 PM, David Winsemius wrote: There is another "matrix" strategy that succeeds, although it is clearly less economical that the transpose approach: matrix(mat[7:1, ], ncol=nrow(mat), byrow=TRUE) # will transpose the matrix I offer this only

Re: [R] [Fwd: Re: Video demo of using svSocket with data.table]

ry illustrative. So now, >>> imagine the debugging flexibility for long running tasks, and/or >>> combination of svSocket with browser()... But that's another story, >>> because svSocket does not work nicely with browser() for the moment. >>> >>> All th

Re: [R] teaching R

SE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Wor

Re: [R] Google's R Style Guide

But if the closing curly brace marks the end of the if part of an if else statement, the else keyword has to be on the same line as the closing brace. The code will not work if the else is on the next line AFAIK. On Aug 28, 2009, at 6:11 PM, hadley wickham wrote: An opening curly brace should

Re: [R] Sorting

; [18,] "jul" "1993" > [19,] "jun" "1993" > [20,] "mar" "1993" > [21,] "may" "1993" > [22,] "nov" "1993" > [23,] "oct" "1993" > [24,] "sep" "

Re: [R] Use of R in Schools

gt; and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___

[R] Evaluating expresssions as parameter values

I need to play games with an expression similar to the following one: print(xyplot(DepVar ~ Group|Covar, groups=Othergroup, data=mydf, pch = 18 ,main="Testcase",auto.key = TRUE)) The problem is that the formula argument (the first argument) an the groups argument are passed over from a

Re: [R] Evaluating expresssions as parameter values

Thank you, this works for my example. On Sep 22, 2009, at 9:17 PM, Gabor Grothendieck wrote: > > f <- function(fo, data, groups) { > g <- do.call("xyplot", list(as.formula(fo), groups = as.name > (groups), data)) > print(g) > } But xyplot allows expressions for the groups parameter a

Re: [R] Evaluating expresssions as parameter values

t(g) } f("yield ~ variety | site", data = barley, groups = "year") On Tue, Sep 22, 2009 at 4:20 PM, Erich Neuwirth wrote: Thank you, this works for my example. On Sep 22, 2009, at 9:17 PM, Gabor Grothendieck wrote: f <- function(fo, data, groups) { g <- do.call("

Re: [R] RExcel + RCOM + Linux

//stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Di

Re: [R] export tables to Excel files

ode. >> > > [[alternative HTML version deleted]] > > ______ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >

Re: [R] export tables to Excel files

www.talgalili.com> (Hebrew) | > www.biostatistics.co.il <http://www.biostatistics.co.il> (Hebrew) | > www.r-statistics.com <http://www.r-statistics.com> (English) > ------ > > > &g

Re: [R] Working with combinations

inations(3,2,letters[1:3])[,1]=="a" > [1] TRUE TRUE FALSE > >> combinations(3,2,letters[1:3])[ combinations(3,2,letters[1:3])[,1]=="a", ] > [,1] [,2] > [1,] "a" "b" > [2,] "a" "c" > >

Re: [R] Working with combinations

r. For example, suppose I am looking for the 10 two element combinations > of 1:5. Can you give me some psuedocode that shows how to do this? > After putting the code below in a loop I do not see how to restrict the > output to containing only numbers from 1:5. > thanks very much. &

Re: [R] Working with combinations

akes it produces all of the combinations? > > > > From: Erich Neuwirth > To: Herm Walsh ; r-help > Sent: Sat, March 6, 2010 9:12:13 AM > Subject: Re: [R] Working with combinations > > currCombin <- c(1,2) #this is the first possible combination 2 out if 5. >

Re: [R] rcom package

~~~ > > > > [[alternative HTML version deleted]] > > > > > __ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide

Re: [R] Executable for Production Use

_ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide >> http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. > &

Re: [R] Creating named lists

posting guide http://www.R-project.org/posting-guide.html >>> and provide commented, minimal, self-contained, reproducible code. >>> >>> > > > > __ > R-help@r-project.org mailing list > https://stat.ethz.ch/

Re: [R] Form using R

oject.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Comp

Re: [R] How good is R at making publication quality tables?

elp > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsit

Re: [R] Dataframe calculations

URES= as.vector(mapply(function(...)addDelays(...)$departs,starts,waits,travels)), ARRIVALS= as.vector(mapply(function(...)addDelays(...)$arrives,starts,waits,travels))) } -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit

Re: [R] Dataframe calculations

ovice. > Perhaps you or someone else could rerun your code on my original > dataframe and see why it did not yield the correct results. > > Thank you, > > Mike > > -Original Message- > From: r-help-boun...@r-project.org [mailto:r-help-boun...@r-project.or

Re: [R] Creating Excel-Charts via RDCOMClient

gt; RDCOMClient. (A clipboard solution which I developed some month ago are very > slow when using large data matrices.) > > So, could anyone help me solving the problem? > > Thanks, > > Michael Wolf > Von-Schonebeck-Ring 18 > D-48161 Muenster > > ___

Re: [R] another matrix problem

help. Bill __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Erich Neuwirth Didactic Center for Computer Science a

Re: [R] ?max (so far...)

roject.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Erich Neuwirth Didactic Center for Computer Science and Institute for Scientific

Re: [R] Automatic datasets creation from multiple data sheets in a single excel file

> > For reading individual worksheets, there is lots of code around. > > And a site search for "read excel worksheet" returns quite a few references. > > Dieter > > > > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer S

Re: [R] rpad ?

our students, but we do not have enough resource to take over maintenance. On 3/23/2010 8:00 PM, sjaffe wrote: > > Is anyone using rpad? Is there any documentation or examples beyond that in > the 'man' directory of the source? > -- Erich Neuwirth, University of Vien

Re: [R] rpad ?

, Bos, Roger wrote: > Erich, > > I use Rpad actively so I am disappointed to hear it is no longer being > updated. Would you be willing to share your modifications with the > list, or at least with me? > > Thanks, > > Roger > > > -Original Message- &g

Re: [R] Calling R from c in Windows XP

ted using gcc with R-2.10.0? > > If so, is it possible to write a simple interface using a c dll to call R > functions from a Visual Basic.net program? > > If so, is there a simple example? > > Thanks to all -- Erich Neuwirth, University of Vienna Faculty of Computer

Re: [R] Finding positions in array

z.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Sup

Re: [R] RCOM Save

) > A3R <- sh$Range("A28") > A3R[["Formula"]] <- "=Summe(A1:A27)" > A3RF <- A3R$Font() > A3RF[["Bold"]] <- TRUE > wkbk$Close(pfad) > system("taskkill /f /im Excel.exe") > > I tried a lot of possibilities (e. g. in the cl

Re: [R] "mantel.haenszel.test for trend in S-plus doesn't work i R"

t;Mantel-Extension-test chi-square =", round(chi2, 3), > "(df =", 1, ")", "p-value =", round(p, 6), "\n", > "Effect is \"", incr, "\" with increasing", attr( > dimnames(array), "names")[1], &qu

Re: [R] run R script from Excel VBA

www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at

Re: [R] loops and if statements

e(b == 'meep', 'oops', 'yay')) > d > > # Option 2 > a <- 1:4 > b <- c("meep", "foo", "meep", "foo") > d <- cbind(a, b) > r <- ifelse(d[,2] == 'meep', 'oops', 'yay') &

Re: [R] run R script from Excel VBA

R the > R file/code is done. > > thx > > On Fri, Apr 16, 2010 at 1:47 PM, Erich Neuwirth > mailto:erich.neuwi...@univie.ac.at>> wrote: > > Sub Doit() > RInterface.StartRServer > RInterface.RRun "whateveryoywanttodoinR" >

Re: [R] Image into Excel file from R

exc, file = wfile.img) > > res <- xls.image(wfile.img, "list") > checkIdentical(res, c("Grafik 1", fpics)) > } > > __ > R-help@r-project.org mailing list > https://stat

Re: [R] Evaluating expresssions as parameter values

Let us walk through my problem step by step: 1. print(xyplot(yield ~ variety | site,groups=year,data=barley)) 2. print(xyplot(as.formula("yield ~ variety | site"),groups=year,data=barley)) The above two statements work, the next one does not work 3. print(xyplot(as.formula("yield ~ variety |

Re: [R] launching two RGUI computations from two different Excel workbooks

Please send questions like this to the rcom mailing list. You can subscribe at rcom.univie.ac.at. On Sep 28, 2009, at 1:34 PM, sowh...@o2.pl wrote: Hello, I have the following problem: I have excel workbooks connected with R through RExcel package. Data are being loaded from excel, then th

Re: [R] RExcel

Please post this kind of questions to the rcom mailing list. You can subscribe at rcom.univie.ac.at __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide

[R] RCMD Rdconv debugging output

I am trying (on Windows XP, with R 2.10.0beta) to use RCMD Rdconv -t html myfile.Rd > myfile.html to convert some Rd files to html. I get a message that there are warning. How can I tell Rdconv to show me these warnings? -- Erich Neuwirth, University of Vienna Faculty of Computer Scie

Re: [R] RCMD Rdconv debugging output

Thanks Duncan, this solved my problem. Here is another thingy I noticed \title{RExcel - Using \R from within Excel} produces RExcel - Using list() from within Excel So the \R macro cannot be used in titles. Is this intentional? Duncan Murdoch wrote: > On 10/14/2009 7:45 AM, Erich Neuwi

[R] warnings details

. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 __ R-help@r-project.org mailing list https

[R] Rpad and R 2.10.0

2.9.2 gives clickable links in the browser. Furthermore, in both cases an empty graphics window opens. Has anybody else similar experiences? Can anybody offer advice? -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our

Re: [R] Excel-Export

project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464

Re: [R] Literature analysis

The screenshot shows your error. Just have a look at the error message in the bottom part of the window. Your csv file has more columns than column names. On Dec 14, 2009, at 2:42 PM, Schwan wrote: > I have uploaded the csv file here: > > http://s000.tinyupload.com/?file_id=79349565739733953435

Re: [R] Re ad & name multiple excel sheets using RODBC

gt;> is rather fast, but has some limitations in the non-commercial version. >> what limitations, i.e. features do you miss? >> >> > > Reading of named ranges. > > Dieter > -- Erich Neuwirth, University of Vienna Faculty of Computer Science

Re: [R] IP-Address

___ > > > [[alternative HTML version deleted]] > > __ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R

Re: [R] Excel Export in a beauty way

, reproducible code. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 __ R-help@r-project.org mailing

Re: [R] How to get commands history as a character vector instead of displaying them?

t; PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > > > > > No virus found in this incoming message. > Che

Re: [R] subset and "or" operator

ww.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > > > > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > V

Re: [R] 'for Loop'

; and provide commented, minimal, self-contained, reproducible code. > > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 _

Re: [R] naming vectors/ matrices in R

> In e[1] =A[, 1] : > number of items to replace is not a multiple of replacement length > > It thinks I am trying to replace the first element of e with the first > column of A. > > is there any other way in which I can achieve this? > > Thanks in advance > >

Re: [R] Tinn-R (Version 2.2.0.2) dose not support R 2.9.0 very well

blem can help me. >> >> Thanks for your attention! >> [[alternative HTML version deleted]] >> >> >> __ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the pos

Re: [R] Help with RExcel (running code)

> Thanks! > > __ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, se

Re: [R] Tables to export to excel

se of Death Crossed by sex e then by group ages. > > Is it possible to have such crosstab sent to an excel file so I could > easilly report. > > Thanks in advance > > Caveman > -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer

Re: [R] how to open excel 2007 (.xlsx) file in R

RExcel mention in the link below can transfer data from Excel 2007 to R. But you have to be on Windows, and you probably have to have Excel 2007. it might work if you have Excel 2003 with the (free) compatibility package installed. On Jan 19, 2010, at 2:09 PM, Gabor Grothendieck wrote: > See > h

Re: [R] problems with constrained optimization

Bad starting value. Try c(3/5,4/5) On Aug 19, 2013, at 1:33 PM, wrote: > I tried ti run a simple example with function solnp() from Rsolnp: find > max(x+y) on a unit circle x*x+y*y=1. The answer should be x=y=1/sqrt(2) > with max=sqrt(2). > > Here are my code and results > > #

Re: [R] Rexcel

Free support for RExcel is available by subscribing to the mailing list at rcom.univie.ac.at and posting questions to the list. On Aug 22, 2013, at 7:04 PM, Jeff Newmiller wrote: > This is not on topic for this mailing list. See the Statconn website for > support for RExcel. __

Re: [R] transform variables

Have a look at the packages reshape and reshape2 They were written with this type of problems in mind. On Aug 26, 2013, at 1:04 PM, catalin roibu wrote: > Dear all! > > I have a data frame composed by 13 columns (year, and 12 months). I want to > transform this data base in another like this >

[R] Slight misinformation in OSX version of R

I just installed R on a Mac without any traces of earlier versions. It exhibited a well know problem: WARNING: You're using a non-UTF8 locale, therefore only ASCII characters will work. Please read R for Mac OS X FAQ (see Help) section 9 and adjust your system preferences accordingly. The infor

Re: [R] export tables to excel files on multiple sheets with titles for each table

;> zz <- file("example.dat", "a+b") >>> cat("\"TITLE extra line",file = zz, sep = "\n") >>> write.table(tab, file=zz, row.names=F,sep="\t") >>> close(zz)} >>> write.excel(head(USArrests)) >>>

Re: [R] export tables to excel files on multiple sheets with titles for each table

M, Whit Armstrong wrote: > It isn't beautiful, but I use this package to write excel files from linux. > > http://github.com/armstrtw/Rexcelpoi -- Erich Neuwirth Didactic Center for Computer Science and Institute for Scientific Computing Universi

Re: [R] re. Mathematica and R

.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- Erich Neuwirth Didactic Center for Computer Science and Institute for Scientific Computing University of Vi

Re: [R] re. Mathematica and R

.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > -- Erich Neuwirth Didactic Center for Computer Science and Institute for Scientific Computing University of Vi

Re: [R] Help!

If you assume that the variance is the same in all your subsets, you can do an lm analysis with your subset classification as a factor. You could also analyze the interaction between factors and between factors and your numeric independent variable. You also should consider repeated measurement met

Re: [R] rcom and safearray type of data

rcom has its own mailing list. Please subscribe to this list at rcom.univie.ac.at and post your question there. On 9/21/2010 2:53 PM, Alex Bird wrote: > > Hello there, > > I started to use rcom package and there were no problems until I tried to > call some external function (method) which ret

[R] file.info returning NA

Windows 7, R-2.11.1 and R-2.12.0beta When I do file.info(list.files(getwd())) I get what I expect, a dataframe with a lot of variables, especially isdir, which tells me if the named object is a file or a directory. In the result of file.info(list.files(paste(R.home(),"library",sep="/"))) all

Re: [R] Extracting elements from a nested list

> >> __ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contain

Re: [R] Extracting elements from a nested list

Thanks again! > > > > > Kind regards, > Greg > > On Oct 18, 2010, at 1:33 PM, Erich Neuwirth wrote: > >> You probably need mapply since you have 2 list of arguments which you >> want to use "in sync" >> >> mapply(function(x1,x2)x1[[x2]],a

Re: [R] Implementing R's recycling rule

On 10/19/2010 11:47 AM, Rainer M Krug wrote: >> x[n %% length(x)] gives you the same answer as rep(x, length.out=n)[n], >> without having to create the longer vector. >> n %% length(x) may return 0 and in that case, x[n %% length(x)] will not give the result you expect. x[((n - 1) %% length(x

Re: [R] R-Excel Macro mode

RExcel has its own mailing list, rcom-l. Please subscribe on rcom.unvie.ac.at and post your question on that list. On 10/27/2010 1:29 PM, Puijman, R. wrote: > I'm using R-Excel's macro mode to make an R based Excel tool for inventory > management. It's quite a lot of R-code which I made in R at

Re: [R] how to save this result in a vector

My guess is that what you want probably is best done by using ecdf. You might want to look it up in the docs. 1-ecdf(test)(x) Will give you the percentage of values in test larger than x. On 11/1/2010 2:24 AM, Changbin Du wrote: > Thanks Joshua! Yes, i is not going up sequentially by 1, as i he

  1   2   >