search for: book1

Dear R-help I would like to read Excel Spreadsheets using odbcConnectExcel() in RODBC, but data in the first row can not be read. For example, I tried to read Excel file 'Book1.xls' in the current Work Directory with the following data (Range("A1:B5") in Excel), 1 19 2 27 3 61 4 76 5 98 My commands and the result are as follows. > library(RODBC) > Book1 <- odbcConnectExcel("Book1.xls") > X <- sqlQuery(Book1, "select * from [S...

R-helpers I have 120 small Excel sheets to read and I am using library(xlsReadWrite): one example below. I had hoped to read sheets by looping over a list of numbers in their name (eg Book1.xls, Book2.xls, etc). I thought I had seen examples which used eval-parse-paste in this way. However, I have not been able to get it to work.. 1. is this a feasible approach? 2. if not advice would be welcome. 3. Equally, advice about a better approach would also be v. welcome....

It would be nice if the 00check.log file also included this part of the output: Running ?bladder.R? Comparing ?bladder.Rout? to ?bladder.Rout.save? ... OK Running ?book1.R? Comparing ?book1.Rout? to ?book1.Rout.save? ... OK Running ?book2.R? Comparing ?book2.Rout? to ?book2.Rout.save? ... OK etc. The survival package has enough test scripts that it exceeds my terminal's scroll bar; I have to either watch closely or run R CMD check survival >&...

...WS 4.0 and samba 3.0.0 on Debian Linux, kernel 2.4.21. 1. Run Excel and create a sheet. Save it to the Samba server. No problem. 2. Close the sheet and open a new one (File->New). 3. Try to save the new sheet over the first one and Excel gives the error: "Cannot save the file. 'H:\test\Book1.xls' is not a valid file name." 4. Click 'ok' and click 'Save' in the still existing Save As window. It replies: "The file Book1.xls already exists. Do you want to replace the existing file?". 5. Click "yes" and it works. So, in #3 above, it should have...

...oreign key and a pubrole_id foreign key. What I want to do is query the DB using AR so that I can get a list of all publications that belong_to a particular author, and group the results by the pubrole.role_name (Author, Joint Author, Editor, etc.) so that the results look something like: Author book1 info book2 info etc. Joint Author book1 info book2 info Editor etc. Can anyone suggest how to do this, or point to an example that already exists? Thanks. -- Posted via http://www.ruby-forum.com/.

Suppose I have two columns of entries, how can I get the union of the two columns? Please note: I input my columns through excel. These entries have text format in excel. Also, out of curiosity, how can I find out the data type of a data frame ? > a <- read.csv("book1.csv") > a n1 n2 1 apple soda 2 orange apple 3 soda green 4 red yellow 5 white blue 6 white > union(a$n1,a$n2) [1] 2 3 5 4 6 1 I want the actual names instead of the indexes.

I have a problem with ruby on rails validation total_book_toy.rhtml ================ <%= text_field ''book1'', ''title1'' %> <%= text_field ''book2'', ''title2'' %> I want to validate these text_field so user can''t insert same title. However, I was stuck how to do it. Or maybe you have another way how to do it. Any suggestion, pl...

...at the approx and approxfun function that seem to do this function, but not fully understand them. I was wondering if someone could help with writing commands to do the following based on the attached file's example: ? ID#1 and ID?#2 both have response parameters ("MEASUREMENT" in the Book1.txt file) for a given time point ("TIME (hours)" in the Book1.txt file). Using linear extrapolation?I would like to be able to compute the percent time spent in the "MEASUREMENT" range of 9 to 10, for ID#1?and ID#2, together and?individually.?? ? in the attached simple example,...

...create_table :people do |t| t.column :name ,:string end ------------------model class Book < ActiveRecord::Base belongs_to :person end class Person < ActiveRecord::Base has_many :books end ------------------in console , try the following: book=Book.create(:name=>''book1'') kevin=Person.create(:name=>''kevin'') kevin.books # should be empty [] book.person=kevin book.save kevin.books # why still nothing ??? Person.find(kevin.id).books # have books! --~--~---------~--~----~------------~-------~--~----~ You received this message beca...

Why the result is coming as NULL. Can anyone help. I want to find the outliers for a reference setwd("D:/AZ") library("RODBC") cdb_cnct <- odbcConnectExcel("Book1.xls") cdb_frame <- sqlFetch(cdb_cnct, "Sheet1") odbcClose(cdb_cnct) rm(cdb_cnct) x<- cdb_frame$Publication >=1990 & cdb_frame$Publication <=2012 invalid <- cdb_frame[!x, c("Reference")] invalid ________________________________ Notice: The information co...

...r is coming as "error in data.frame(...., check.names = FALSE): arguments has differents counts of rows: 0, 18" for the following code. Can you please help? Thank you Devarayalu library(ggplot2) setwd("D:\\General Check list") library(RODBC) conn <- odbcConnectExcel ("Book1.xls") Orange1 <- sqlFetch (conn, "Sheet2") odbcClose(conn) rm(conn) unique(Orange1$BSCHSTAT) -> change pdf("xxx.pdf") for (j in 1:length(change)){ ((Orange1$BASCHGAUT == "8-item scale")&(Orange1$BSCHSTAT == change[j])) -> b FD <- Orange1[b, ] uniq...

Hi all, Can anybody debug the following programme, as I am getting some Junk graphs in the pdf. Please find the attached raw data file. Thank you Regards Rayalu library(ggplot2) setwd("D:\\General Check list") library(RODBC) conn <- odbcConnectExcel ("Book1.xls") Orange1 <- sqlFetch (conn, "Sheet3") odbcClose(conn) rm(conn) #CDAI Change unique(Orange1$BSCHSTAT) -> change pdf("xxx.pdf") for (j in 1:length(change)){ ((Orange1$BASCHGAUT == "8-item scale")&(Orange1$BSCHSTAT == change[j])) -> b FD <- Oran...

...he TDM11B has its own IRQ (according to lspci -v). lspci -v shows the card as 0000:01:04.0 Communication controller: Tiger Jet Network Inc. Tiger3XX Modem/ISDN interface I'm following the instructions in http://www.asteriskdocs.org/modules/tinycontent/content/docbook/current_v1/docs-html/book1.html. I'm using the Asterisk/Zaptel software that's on the CD that came with the TDM11B. It has version 1.0.7. The zaptel driver loads fine. The problem I'm having is with the wcfxs driver. matsuri:~# modprobe zaptel matsuri:~# modprobe wcfxs /lib/modules/2.4.27/misc/wcfxs.o:...

Hi I would like to transform a data frame like Subject Item Score Subject 1 Item 1 1 Subject 1 Item 2 0 Subject 1 Item 3 1 Subject 2 Item 1 1 Subject 2 Item 2 1 Subject 2 Item 3 0 .... *to * Subject Item1 Item2 Item3 .....Item N Subject1 1 0 1 Subject2 1 1 0 ........ SubjectP.. Apologize for the simple nature of my query but I am stuck.

...wdg.de> wrote: > On 30.10.2010 13:50 (UTC+1), Santosh Srinivas wrote: > >> A more usable problem input would definitely help ... use dput to send a >> reproducible sample to the group >> >> Think the below should solve your problem >> >> read.csv("Book1.csv") >>> >> Subject Item Score >> 1 Subject 1 Item 1 1 >> 2 Subject 1 Item 2 0 >> 3 Subject 1 Item 3 1 >> 4 Subject 2 Item 1 1 >> 5 Subject 2 Item 2 1 >> 6 Subject 2 Item 3 0 >> >> library("resh...

...these are seperated out into two tables: book_borrowers and movie_borrowers and therefore 2 different activerec objects: BookBorrower and MovieBorrower This particular screen will display something like this (plz excuse formatting): Name Has Borrowed ------- ------------------- Ron Book1, Book2, Movie4 Bob Book3 Tom Movie1 Paging seems quite simple if I would like to display either books or movies that you have borrowed in a table but I''m struggling a bit in paging over the combination. I''ve played with having a seperate object that combines the two...

Dear Sir, I am using RClimDex. I get following error. Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings, : scan() expected 'a real', got 'T' I have done copy paste of climate data from excel file to notepad and tried to upload. I do not have any knowledge about programming languages. Please help me. Regards, Binaya Pasakhala -- View this

Hi, You might want to first read http://www.digium.com/handbook-draft.pdf which explains most of the basic stuff. Most of the questions you'll have will be answered on http://www.voip-info.org or by reading http://www.asteriskdocs.org/modules/tinycontent/content/docbook/current_ v1/docs-html/book1.html Oh, and most questions have also been answered on this mailing list so look at http://lists.digium.com/pipermail/asterisk-users/ for the mailing list archives. When you've read that and understand what you're doing you should be well on your way :) Guills > -----Original Message-...

Dear all, I would like to import a range of cells (e.g. F10:K234) from an Excel worksheet to R. I have looked for documentation on RODBC and RDCOMClient but I was not able to find enough information to solve my problem and all the examples I have seen were dealing with an entire worksheet, not a range of cells. Thanks, Jean-Noel Jean-Noel Candau INRA - Unit? de Recherches Foresti?res

...for storename in next trip, storename in previous trip etc... and also # days between trips to each store for each customer...(an example for Butter dataframe with new derived variables would be...) Dataset needs to be sorted by CustID, TripDate, Store before creating derived variables (dataset3)Book1.xlsx CustID TripDate Store Butter NextTripstore previoustripstore daysbetweentrips 1 6-Jan-12 c 3 a - - 1 9-Jan-12 a 3 - c - 2 31-Aug-12 a 3 a - - 2 24-Sep-12 a 3 - a 24 Point of creating multiple item level...