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]]
It would be a form that is filled daily, but some fields were tabulated and other fields would be filled with only the opinions of users. Currently, my form is a Word document that is the filling and printed. At the end of every month they are analyzed and the reasons for delays are tabulated and the graphs created. I wish the print was not necessary. Furthermore, the reasons would be tabulated automatically. Please let me know if I were clear. Thanks for you attention Nilza Barros On Fri, Mar 12, 2010 at 2:21 PM, Ista Zahn <istazahn@gmail.com> wrote:> HI Nilza, > I don't think this question is well-specified. What kind of form are > you talking about? An html form? > > -Ista > > On Fri, Mar 12, 2010 at 9:49 AM, Nilza BARROS <nilzabarros@gmail.com> > wrote: > > 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]] > > > > ______________________________________________ > > 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<http://www.r-project.org/posting-guide.html> > > and provide commented, minimal, self-contained, reproducible code. > > > > > > -- > Ista Zahn > Graduate student > University of Rochester > Department of Clinical and Social Psychology > http://yourpsyche.org >-- Abraço, Nilza Barros [[alternative HTML version deleted]]
Hi Nilza,
I think your solution should be to create a google spreadsheet and then read
it.
Here is an example code for reading a google spreadsheet:
supplements.data.0 <-
read.csv("http://spreadsheets.google.com/pub?key=0Aqe2P9sYhZ2ndFRKaU1FaWVvOEJiV2NwZ0JHck12X1E&output=csv")
I used this trick here:
http://www.r-statistics.com/2010/02/nutritional-supplements-efficacy-score-graphing-a-bar-plot-of-current-studies-results-using-r/
And I found out about it from here:
http://blog.revolution-computing.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html
You will need to know how to create a google form that will feed a google
spreadsheet:
Here is a simple video tutorial:
http://www.youtube.com/watch?v=IzgaUOW6GIs<http://www.youtube.com/watch?v=IzgaUOW6GIs&feature=related>
(This video explains your situation very well :) )
Good luck.
Tal
----------------Contact
Details:-------------------------------------------------------
Contact me: Tal.Galili@gmail.com | 972-52-7275845
Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) |
www.r-statistics.com (English)
----------------------------------------------------------------------------------------------
On Fri, Mar 12, 2010 at 4:49 PM, Nilza BARROS <nilzabarros@gmail.com>
wrote:
> 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]]
>
> ______________________________________________
> 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.
>
[[alternative HTML version deleted]]
Hi Nilza, I just wrote a more detailed answer to your question in the following post: Google spreadsheets + google forms + R = Easily collecting and importing data for analysis<http://www.r-statistics.com/2010/03/google-spreadsheets-google-forms-r-easily-collecting-and-importing-data-for-analysis/> I copy it here: First view the following video (2:50 min) which explains what google spreadsheets are http://www.youtube.com/watch?v=muVUA-sKcc4 Then view the next video (2 min), which explains what using google forms with google spreadsheet is all about http://www.youtube.com/watch?v=IzgaUOW6GIs The next step for you is to access the spreadsheet without having to make it public is to go thorough this tutorial<http://www.omegahat.org/RGoogleDocs/run.pdf> on how to use the R package RGoogleDocs <http://www.omegahat.org/RGoogleDocs/>. If you feel comfortable to publish the google spreadsheet, there is a simpler tutorial for you here<http://blog.revolution-computing.com/2009/09/how-to-use-a-google-spreadsheet-as-data-in-r.html>. And you could see examples of using this method here <http://chartsgraphs.wordpress.com/2009/09/11/co2-emissions-changes-in-atmospheric-levels/> and here<http://www.r-statistics.com/2010/02/nutritional-supplements-efficacy-score-graphing-a-bar-plot-of-current-studies-results-using-r/> . I hope this helps. Tal ----------------Contact Details:------------------------------------------------------- Contact me: Tal.Galili@gmail.com | 972-52-7275845 Read me: www.talgalili.com (Hebrew) | www.biostatistics.co.il (Hebrew) | www.r-statistics.com (English) ---------------------------------------------------------------------------------------------- On Fri, Mar 12, 2010 at 4:49 PM, Nilza BARROS <nilzabarros@gmail.com> wrote:> 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]] > > ______________________________________________ > 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. >[[alternative HTML version deleted]]
Tal Galili <tal.galili <at> gmail.com> writes:> > Hi Nilza, > I just wrote a more detailed answer to your question in the following post: > Google spreadsheets + google forms + R = Easily collecting and importing > data for analysis<http://www.r-statistics.com/2010/03/google-spreadsheets-google-forms-r-easily-collecting-and-importing-data-for-analysis/> on Fri, Mar 12, 2010 at 4:49 PM, Nilza BARROS <nilzabarros <at> gmail.com> wrote:> > > 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.There is also a package called RGoogleData that can import data from Google Spreadsheets (even when they are not public). It has one benefit over RGoogleDocs; RGoogleData can download a spreadsheet as a csv file to your harddrive. You can then read the csv file into R - read.csv(). Those steps can easily be written into a script so that you do not have to manually futz with them each time. The benefit of the csv download is that it is very fast. Both the RGoogleDocs and the RGoogleData are slow in reading the spreadsheet into R. I understand, but may be wrong, that Google Stores all the data as HTML and its API spits it out as xml which these r packages then need to parse out line by line. The csv treatment by comparison is instantaneous. Only one big problem. As of a few months ago, RGoogleData has stopped working for me. I think it is still working for its writer, Adrian Dragulescu. Adrian has been very generous with his time in trying to help me. He predicts that he will go back to exploring his package once Google updates their API. Try it out. I would love to hear what happens. http://r-forge.r-project.org/projects/rgoogledata/