similar to: Embed R code in online database

Both of these applications fulfill a great need of mine: to read data directly from google spreadsheets that are private to myself and one or two collaborators. Thanks to the authors. I had been using RGoogleDocs for the about 6 months (maybe more) but have had to stop using it in the past month since for some reason that I do not understand it no longer reads google spreadsheets. I loved it. Its

Hi, R users We can create a form using R? I would like to create a form where the information can be read by R. Itneeds to be updated daily because I have to tabulate the reasons for delays in the generation of numerical models products. I really appreciate any help, Thanks in advance, Nilza Barros [[alternative HTML version deleted]]

Dear R-experts! I am working on some meta-analysis using the metafor package. I would like to extract values of the confidence intervals of the effect sizes of the single studies from an rma object. Those values are printed out when plotting a forest plot using the forest function on the rma object, however I was not able to locate them. Many thanks for your help! Jokel [[alternative HTML

Dear R communitiy, I am trying to use multiple functions for aggregation within a function call for dcast. However this seems to result in an error. Also I have not managed to make dcast() work with fun.aggregate=sd. Please find attached some example code using the ChickWeight data. Many thanks for your help! Jokel #Chick weight example names(ChickWeight) <- tolower(names(ChickWeight))

Dear R experts, I have conducted a power calculation in order to estimate the number of subjects needed to detect an effect size of d=0.28 (cohen's d) for a difference between two independent groups (alpha level should be 0.05 and the effect should be detected with 80% probability). The results from the code below indicates that I would need n=400 subjects (200 in each group). This is seems

Dear R-experts! I am currently running a meta-analysis with the help of the great metafor package. However I have some difficulties setting up my raw data to enter it to the meta-analysis models. I have a group of subjects that have been measured in two continuous variables (A & B). I have the information about the mean of the two variables, the group size (n) and the standard deviations of

I am thinking about writing a new open source spreadsheet application since I think the spreadsheet applications out there (Microsoft Excel, LibreOffice Calc, etc.) do not have some features that I would really like to use. I would like the spreadsheet to recalculate very fast and wondered if it would make sense to use LLVM to calculate the cell values quickly. Each cell of a spreadsheet

Mats, Thanks for your feedback. I guess I should elaborate on one of the features I would like to implement. In today's spreadsheets if you want to crunch a lot of data, you usually put the data in rows and put expressions in cells to the right of the data and repeat those cells for every row of the data. I would like to create a spreadsheet system that can process the same quantity of

Dear R-experts! Running a meta-analysis (using the magnificent metafor-package), I use cohen's d as a main outcome measure in a random-effects model. For most of the samples cohen's d is derived form a comparison of two groups (A & B). However some studies report results from an ANOVA (one-factor with three levels: C,D,E) whereas two groups (C,D) correspond to one group in the other

Dear R-experts! In a meta-analysis (metafor) I would like to assess the effect of two categorical covariates (A & B) whereas they both have 4 levels. Is my understanding correct that this would require to dummy-code (0,1) each level of each covariate (A & B)? However I am interested in the main-effects and the interaction of these two covariates and the dummy-coding would only allow to

Is there an easy way to read the value of the cells rather than the formula?So for instance in a cell whose value was created by simply using the value from the cell immediately to the left in the Google spreadsheet I would prefer to get the value rather than =RC[-1] When one exports with Google Spreadsheets as a csv then that does not happen. I am using the following line of code in R

Dear R-experts, The forest.rma() function from the metafor package creates nice forest plots for presenting the results of a meta-analysis. These plots can be annotated for e.g. giving names to the columns. E.g. as in the documentation of the package: data(dat.bcg) ### meta-analysis of the log relative risks using a random-effects model res <- rma(ai=tpos, bi=tneg, ci=cpos, di=cneg,

Hi I am using package RODBC version 1.0-1 under R version 1.7.1 on Windows XP Pro. I am having problems writing a new table to an (Excel) database using sqlSave. I connect to an empty Excel spreadsheet using odbcConnectExcel (which, I believe, uses the Microsoft Excel Driver DSN). Then I try and save a new table to the database(spreadsheet) using SqlSave, but obtain an error message. Below is

Hello, I'm trying to figure out how to use the RGoogleDocs package from OmegaHat, and am having a bit of trouble. I emailed Duncan Temple Lang directly, but didn't receive a response, so I thought I'd try here to see if anyone else can help. I'm using 32-bit R 2.10.1 (Mac OS X), I built RGoogleDocs 0.4-0 from source, and I'm using XML 3.1-0 and RCurl 1.2-0. If I use

Hi, I used RODBC to import data from an Excel spreadsheet "*.xls", but some columns were returned as zeros. When I looked at these columns in Excel, I found that thery are results of formula calculations and not entry. My question is: Is there any parameter or command I need to use in order to overcome this problem? Thank you Ahmad Abu Hammour

Hi! There's nothing on the calendar for this month? Anton just mentioned to me that it was today, so just trying to clear up some confusion. Thanks, Joey On 12 September 2012 04:12, Wojciech Meyer <wojciech.meyer at gmail.com> wrote: > Renato Golin <rengolin at systemcall.org> writes: > > > Just a reminder, the Cambridge LLVM Social is this Wednesday, 7:30pm >

Just a reminder, the Cambridge LLVM Social is this Wednesday, 7:30pm at the Cambridge Blue. http://www.the-cambridgeblue.co.uk/blueroadmap.html If you haven't done so yet, you can subscribe to our calendar to know when the next one will be: https://www.google.com/calendar/embed?src=as5fh066i94qthrkct1lv7rojo%40group.calendar.google.com&ctz=Europe/London

Renato Golin <rengolin at systemcall.org> writes: > Just a reminder, the Cambridge LLVM Social is this Wednesday, 7:30pm > at the Cambridge Blue. > > http://www.the-cambridgeblue.co.uk/blueroadmap.html > > If you haven't done so yet, you can subscribe to our calendar to know > when the next one will be: > >

A common process when data is obtained in an Excel spreadsheet is to save the spreadsheet as a .csv file then read it into R. Experienced users might have learned to be wary of dates (as I have) but possibly have not experienced what just happened to me. I thought I might just share it with r-help as a cautionary tale. I received an Excel file giving patient details. Each patient had an ID

I am a new R user and I have a question of embedding R to generate png On Debian, I installed R by source code. Now I want to embed R in an application which name is MyApp, and run the following syntax: png(filename="/tmp/Rplot%03d.png) example(rect) dev.off() Unfortunately I get the following error message: Error in X11(paste("png::", filename, sep = ""), width,