similar to: R-beta: data.entry()

I have a question on the use of return(). (Nothing on it in the docs I have) The test code below gives the error: Error: Object "x" not found when I do: thingy2(). How should it be fixed? Thanks very much for any help! (My original solution to this sort of problem was to use global variables x<<-... y<<-...) Bill Simpson ----------------------------- thingy<-function(k)

I use R for data management and ongoing data analysis for amongst other things, a multi-center medical research project. I have found Google spreadsheets to be a fantastic way for all collaborators to be on the same page. Furthermore, Google Forms allows one to capture data from respondents and effortlessly write it to a google spreadsheet. Currently, one has to manually download the spreadsheet

Dear Group, I hope someone out there can help me with this. I am building a Rails 2.0 application for a customer. The customer has a number of Excel spreadsheets which he would like his customers to open and complete online then submit the completed spreadsheet to him via email. A typical scenario would be: (1) The ''empty'' spreadsheets are provided as a list on the web site.

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

Hi, I'm using RGoogleDocs/RCurl to update a Google Spreadsheet. Everything worked OK until this morning, when my ability to write into spreadsheet cells went away. I get the following weird error: Error in els[[type + 1]] : subscript out of bounds Looking at the Google Docs API changelog, I see the following: http://code.google.com/apis/spreadsheets/changelog.html Release 2010-01 (July 14,

DeaR all, I'd like to know how to create an Excel file with multiple spreadsheets from R. I searched the help files and found [1] but it is not what I want to do. Let's say I have a data frame called DF as in the following code # Some data set.seed(123) ID<-sample(5,100,replace=TRUE) X<-rnorm(100) Y<-rpois(100,10) Z<-X*Y DF<-data.frame(ID,X,Y,Z) str(DF) I'd like to

I have an arbitrary number of spreadsheets that I want to consolidate into a single data frame. The spreadsheets all have the same structure: location, depth1Reading, depth2reading, depth3reading, depth4reading, depth5reading The spreadsheets have their reading date in their file name. This gets parsed out and added to the data frame as a factor. The file name gets recorded in the data

On Thu, Nov 5, 2020 at 7:30 AM Mircea Trofin via llvm-dev < llvm-dev at lists.llvm.org> wrote: > There are currently 1350 owner-less failures in the spreadsheet > <https://docs.google.com/spreadsheets/d/1o6q3XH1n3DDyyccnYZ_kVfhFbTDzC_S09e973_cwYuw/edit#gid=0>. > These seem to be the larger areas there. > > If you see an area you have ownership or expertise in, please

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

I unfortunately haven't received any responses about this problem. We (the company I work for) are willing to discuss payment to someone who is willing to quickly contribute a fix to the RGoogleDocs/RCurl toolchain that will restore write access. Please contact me directly if you're interested. Thank you, -Harlan Harris On Tue, Jul 20, 2010 at 10:19 AM, Harlan Harris

There are currently 1350 owner-less failures in the spreadsheet <https://docs.google.com/spreadsheets/d/1o6q3XH1n3DDyyccnYZ_kVfhFbTDzC_S09e973_cwYuw/edit#gid=0>. These seem to be the larger areas there. If you see an area you have ownership or expertise in, please sign up for fixing the tests by Monday, Nov. 9. Otherwise, I will "blanket-add" --allow-unused-prefixes=true to the

On Thu, Nov 5, 2020 at 10:46 AM Mircea Trofin <mtrofin at google.com> wrote: > > > On Thu, Nov 5, 2020 at 10:40 AM David Blaikie <dblaikie at gmail.com> wrote: > >> >> >> On Thu, Nov 5, 2020 at 7:30 AM Mircea Trofin via llvm-dev < >> llvm-dev at lists.llvm.org> wrote: >> >>> There are currently 1350 owner-less failures in the

People, I thought I needed to have some familiarity with NNs for some of my current (non-profit, brain-related) projects so I started looking at various programming environments including R and I got this working: http://gekkoquant.com/2012/05/26/neural-networks-with-r-simple-example however I needed pictures to help understand what was going on and then I found this:

On Thu, Nov 5, 2020 at 10:40 AM David Blaikie <dblaikie at gmail.com> wrote: > > > On Thu, Nov 5, 2020 at 7:30 AM Mircea Trofin via llvm-dev < > llvm-dev at lists.llvm.org> wrote: > >> There are currently 1350 owner-less failures in the spreadsheet >> <https://docs.google.com/spreadsheets/d/1o6q3XH1n3DDyyccnYZ_kVfhFbTDzC_S09e973_cwYuw/edit#gid=0>.

We have some Excel spreadsheets stored on our Samba 2.2.8 fileserver. The permissions are set such that some users can write to these and some cannot, but they can all read them (the world-readable bit is set). When a user with read/write access tries to open the spreadsheet, there is no problem. The user is happy and productive and outside the sun is shining. Excellent! Have a biscuit! When a

I reproduce from memory my exhaustive look into this issue. RODBC uses the Microsoft ODBC DLL's developed by Microsoft. These DLL's perform an automatic determination of column type based on the contents of the first N rows of cells in each column, where N [0,16]. N may be set in the Windows system registry, and there are a few other things that may be set in the system registry which

Hi David Thanks you for reply, are you sure about this? Windows and Samba SMB byte range locking feature doesn't allow this by locking regions of a single file ? From: "David Bear" <dwbear75 at gmail.com> To: "Dante F. B. Colò" <dante.colo at stwbrasil.com> Cc: "samba" <samba at lists.samba.org> Sent: Friday, April 7, 2017 1:59:56 PM

Is there a gem that will present things in a spreadsheet-like style? I tried searching via both Google and rubygems.org and found mainly things to import and export .xls[x] and Google Spreadsheets. There was also the Exercise gem, which had zero documentation about what it *does*, which doesn''t make me confident in using it. Why do I ask? I''ve made a little app

Hi folks, I have imported data from an Excel spreadsheet. Columns in that spreadsheet are named "name", "x", and "y", and several sets of those columns appear in the worksheet. For example: name x y name x y test1 1 3 test2 4 4 test1 2 2 test2 5 5 test1 3 1 test2 6 6 When I import these data into R, into a dataframe, I end up with something like this:

I would also look at https://pandoc.org perhaps which can export a number of formats... And for spreadsheets https://github.com/jqnatividad/qsv is my goto weapon. Can also read and write XLSX and others. A sample document or two would always be helpful... el On 29/12/2023 21:01, CALUM POLWART wrote: > It sounded like he looked at officeR but I would agree > > content <-