similar to: Small enhancement for CMD check

I''ve got a publications table that contains an author_id foreign 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.

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

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.

Dear users, In a study with recurrent events: My objective is to get estimates of survival (obtained through a Cox model) by rank of recurrence and by treatment group. With the following code (corresponding to a model with a global effect of the treatment=rx), I get no error and manage to obtain what I want : data<-(bladder)

Hello R-help. I am trying to make a stacked barplot where the color of the sections of each bar depend on another variable. > myData[1:11,] score percent marker cellType Malignant 1 0 100.00000 ESR1 (ER) Bladder.M(5) TRUE 2 0 80.00000 PAX8 Bladder.M(5) TRUE 3 1 20.00000 PAX8 Bladder.M(5) TRUE 4 0 100.00000 ESR1 (ER) Brain.N(3) FALSE 5 0

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 <-

The expected number of bladder cancer over next 20 years a tire industry is 1.8. Poission distribution is assumed to hold and 6 reported deaths are caused by bladder cancer among the employees. Trying to find how unusual this event is. > ppois(q=6, lambda=1.8, lower.tail = TRUE, log.p = FALSE) [1] 0.9974306 not sure if ppois is the right one to use and the parameters... thx much

Hello, In package survival should be a dataset bladder1. http://stat.ethz.ch/R-manual/R-devel/library/survival/html/bladder.html I can not open it (not found). Both bladder and bladder2 are there. Thanks, Petra

Using Office2K (Word & Excel) on NTWS 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

I''m looking for a smooth way to implement paging over a combination of two tables. My application tracks which books and movies you have borrowed from me. For reasons that make sense elsewhere in the application, these are seperated out into two tables: book_borrowers and movie_borrowers and therefore 2 different activerec objects: BookBorrower and MovieBorrower This particular screen

> On Apr 16, 2018, at 3:20 PM, David Winsemius <dwinsemius at comcast.net> wrote: > >> >> On Apr 16, 2018, at 2:58 PM, Therneau, Terry M., Ph.D. via R-devel <r-devel at r-project.org> wrote: >> >> A user asked me about this and I can't figure it out. >> >> tmt% R >> R Under development (unstable) (2018-04-09 r74565) --

Dear volunteer: I am a graduate student of medcine in china.And now,I am devoting myself to constructing a nomograms of bladder cancer.I want to do it with R-project.However, I do not know how to construct a nomograms with R-project.I want to get yours help,thank you! I wish you can tell me the operating procedure of the R-project. And I apologize for my english,it is poor,sorry!

I'm new to R and some what new to the world of stats. I got frustrated with excel and found R. Enough of that already. I'm trying to test and correct for Heteroskedasticity I have data in a csv file that I load and store in a dataframe. > ds <- read.csv("book2.csv") > df <- data.frame(ds) I then preform a OLS regression: > lmfit <- lm(df$y~df$x) To

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

Dear all, Good day! I have a problem in reading Excel files in R and appending them to each other. Suppose we have several Excel files in a directory with headers and want to use R to append them in a single file with an additional variable in the final file indicating from which files the data come from. As I have many Excel files and their sizes are very big I should write a loop in R to do

Hello all, i found something wrong (or maybe i was wrong?) this looks like a rectiverecord bug , can anyone help me to point out what''s going on? ------------------migration create_table :books do |t| t.column :name,:string t.column :person_id,:integer end create_table :people do |t| t.column :name ,:string end ------------------model class

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,

Hello all: While I'm recovering from gall bladder surgery, I thought I'd do something useful (since sitting up is about the only comfortable position I can find)... like create a HOWTO Samba (-2.0.7-21ssl) on RH7 (w/ xinetd-2.1.8.9pre14). I have already sent off the request to the HOWTO coordinator at linuxdoc.org (has anyone noticed that the listed email address

dear professor: I am a doctor of urinary,and I am developing a nomogram of bladder tumor.Now I have a problem about this. I have got the result like this through analysing the dataset "exp11.sav" through multinominal logistic regression by SPSS 17.0.(the Sig. is high,that is good ,it is just aexperimental data ) Parameter Estimates Ya B Std. Error Wald df Sig. Exp(B) 95%

Hi all, Error 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)