similar to: RODBC: How to Retrieve a Column as Rownames?

Dear Colleagues, does anybody know how to aggregate a data.frame using different functions for different columns? Sincerely ___________________ Markus Preisetanz Consultant Client Vela GmbH Albert-Roßhaupter-Str. 32 81369 München fon: +49 (0) 89 742 17-113 fax: +49 (0) 89 742 17-150 mailto:markus.preisetanz@clientvela.com

Dear Colleagues: I have 3 numeric variables (say x, y, z) in a data.frame and want to draw a 2D-scatterplot with the 3rd dimension as color, if possible without having to convert the whole thing to an appropiate matrix for image() manually. Can e.g. scatterplot3d do something like this? There's a function xyz.convert, but I couldn't find the way to use it properly. Sincerly,

Dear Colleagues, I've been looking for a function that can perform a tree analysis, similar to CHAID or QUEST. The key point is that in this case the variables are not binary but nominal (10 different values), so "tree" (from the tree package) won't work. Does anybody know help? Sincerely, ___________________ Markus Preisetanz Consultant Client Vela GmbH

Dear Colleagues, does anybody know how to add dimnames to an image. Right now I'm using image(as.matrix(df3), col=brewer.pal(9,"Blues")) where df3 is a data.frame. dimnames(as.matrix(df3)) delivers [[1]] [1] "RFM_A1" "RFM_A2" "RFM_A4" "RFM_A5" "RFM_A7" "RFM_B3" "RFM_B6" "RFM_B7"

Dear R Specialists, when trying to cluster a data.frame with about 80.000 rows and 25 columns I get the above error message. I tried hclust (using dist), agnes (entering the data.frame directly) and pam (entering the data.frame directly). What I actually do not want to do is generate a random sample from the data. The machine I run R on is a Windows 2000 Server (Pentium 4) with 2 GB of

Dear Colleagues, I would like to only inspect rules that contain a certain label substring on the rhs. In this special case the item labels are built like this: <itemtype>_<itemvalue> e.g. "Artikelgruppe_E0815" what I want to do is only show rules where "Artikelgruppe" is contained in the rhs - has anybody an idea how this could work? Sincerely

Dear Collegues, does anybody know how I can place a legend at a sensible position in a star diagram automatically? The legend should tell the name of the variable (from colnames) for every color used. Sincerely, Markus ___________________ Markus Preisetanz Consultant Client Vela GmbH Albert-Roßhaupter-Str. 32 81369 München fon: +49 (0) 89 742 17-113 fax:

Dear Collegues, it seems like there is a problem with the image()-method in the package arules. Using an ordninary matrix works fine: image(matrix(rnorm(200), 10, 20), axes = FALSE, col=brewer.pal(9, "Blues") ) delivers an image with blue colors and no axes. Using an object of the class "associations" (arules package) does not work: image(items(ta.eclat), axes = FALSE,

Hi group, My case has N physicians with each seeing M patients. One physician could have seen a group of patients, or, a patient could have been seen by multiple number of physicians. In order words, there are overlaps. Now, I have the following NxM matrix Patient#1 Patient#2 Patient#3 ....... Patient#m Physician#1 1 0 1 ....... 0 Physician#2

Ein eingebundener Text mit undefiniertem Zeichensatz wurde abgetrennt. Name: nicht verf?gbar URL: https://stat.ethz.ch/pipermail/r-help/attachments/20060807/7f387274/attachment.pl

Hello, after putting ADO.rb into Directory \ruby\lib\ruby\site_ruby\1.8\DBD\ADO\ I created a Rails-Application with MS SQL Server 2000 as Database. Everything works fine, but into the nvarchar-Field "notice" i can''t store more than about 50 or 60 characters MS SQL Server Query analyzer says, this field has a length of 510 characters. What can i do to save up to the 510

I have installed active admin and also add my model -controller rate_professor there.......I can add/delete/edit data using active admin ...but if I click on submit button of my form in rate_professor controller ... I can see whatever I added in the index page ........but I don''t want to see that one.....I want to find the information(whatever I added by clicking submit button) on

Hi, all. I'm using RODBC to query a SQL Server 2005 database, and am experiencing terribly slow performance. I assume I'm doing something wrong, but I'm not doing anything fancy, so I'm stumped. My setup: Core 2 Duo 2GHz, Win XP, 2GB RAM R 2.7.1 RODBC (latest from CRAN, not sure the version - how to tell?) SQL Server 2005 MS Access 2003 SQL Native Client ODBC driver (DSN =

In order to coerce Rails 1.2.x into supporting Unicode values for an attribute in a model, I found I had to do the following: 1) Change the underlying column type from varchar to nvarchar. 2) Prepend any quoted values going into nvarchar columns with a capital-letter-N, e. g. ''unicode'' becomes N''unicode'' In order to accomplish this, I modified

Calling function "sqlFetch" in library(RODBC) and specifying a character string as 2nd argument, I get an error I don't understand: library(RODBC) channel <- odbcConnect("mydatabase.mdb", case="msaccess") sqlFetch(channel, "mytable") # this works fine tabname <- "mytable"; sqlFetch(channel, tabname) # this gives an error: # Error in

Hi, Thanks for showing me how to use RODBC and odbcConnect. Now works nicely. The question I've got now is: noms <- list.files(pattern=".DBF") # removing extension names: noms <- sapply(noms, function(x) as.character(strsplit(x,".DBF")) , USE.NAMES=F) for (i in 1:length(noms)) { s <- sqlFetch(bdades, noms[i]) # etc. } But it seems that sqlFetch()

I am using the following: library(RODBC) chan = odbcConnectExcel("rats-lda") rats.lda = sqlFetch(chan, "data") close(chan) And getting the following error message: > library(RODBC) Error in library(RODBC) : there is no package called ?RODBC? > chan = odbcConnectExcel("rats-lda") Error: could not find function "odbcConnectExcel" > rats.lda =

Hi List, I used to access a Paradox database using RODBC, but since last week I am not able anymore to fetch any table which has a name longer than 11 or 12 characters. Here is the the pattern of my code, nothing spectacular: library(RODBC) channel2<-odbcDriverConnect('DSN=xxx') #table names with up to 11 characters still work sqlFetch(channel2, 'abcdefghijk') #table names

I have some questions about the RODBC package. library(RODBC) # required for those who want to repeat these lines 1st, I noticed that the following sequence does not work: channel <- odbcConnextExcel("test.xls") tables <- sqlTables(channel) name1 <- tables[1, "TABLE_NAME"] # this should be the name plan1 <- sqlFetch(channel, name1) # bang!

Dear all, I successfully set up a local MySQL-database. Connecting via RODBC is not problem, the same in fetching 3 of 4 tables. But trying to connect to table 4 fails. > author<-sqlFetch(test,"author") Error in fromchar(unclass(x)) : character string is not in a standard unambiguous format In principle I understand that error message, but I don't know any solution.