similar to: RODBC problem

Dear All, I am given a set of files names as: velocity1.txt velocity2.txt and so on. I am sure there must be a way to read them automatically in R. It is really taking me longer to read them than to analyze them. Anybody has a suggestion to help me out with this? Many thanks Lorenzo

Hello R community: I'm encountering unexpected behaviour as I download string data from MySQL using the RODBC package. The unexpected behaviour is that the last character of the string is truncated. As far as I can see, this happens when some strings are of length 501 or more. Here's how to reproduce this behaviour. ## In MySQL, pick a database and run this: CREATE TABLE test ( v1

When updating to the very last version of RODBC under freebsd 6.1 the errors below pop up but RODBC compiles till the end and, it seems, to work properly. What are those errors about? Vittorio .............................................. checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... grep: error while

Hello, I'am currently experiencing some problems with the odbcCloseAll() and odbcClose() function. I'm trying to connect an R script to a MySQL 5.0 database using RODBC1.1-7 and the MySQL ODBC Driver v.3.51 on a Windows XP Machine. At first everything seems fine. The script connects, reads and writes data but when it comes to odbcCloseAll() it crashes and hangs forever. Unfortunately I

Hi. I am trying to get data from mysql database using a couple of queries. I do one query to find out the indexes. Then i need to use these indexes in another query, but i keep getting errors. Here is something: numb <- dbSendQuery(con2, "select distinct(comparison) from table1") count <- fetch(numb, -1) my.matrix <- as.matrix(count) rs <- dbSendQuery(con2, "select

I've defined the function getFunNames <- function(FUN){ if (!is.list(FUN)) fun.names <- paste(deparse(substitute(FUN)), collapse = " ") else fun.names <- unlist(lapply(substitute(FUN)[-1], function(a) paste(a))) fun.names } which gives what I want : > getFunNames(mean) [1] "mean" > getFunNames(ff) [1] "ff" >

I think I asked a similar question 3 years ago to the Splus list and I think the answer was no or noone answered so noone should spend more than 5 minutes on this because it could definitely be a waste of time. My question is whether the function below can be rewritten without a for loop. apply is fine if it can be done that way but i doubt it. I call it a lot and would prefer to not loop.

Hi R-Experts, How can I show all the relevant measures like mean, median, min. value, max. value, outlier in a single boxplot diagram? Suppose I have a data set c(2,4,5,7,12,14,15,13,8,5,23,98,11) Sumanta Basak. [[alternative HTML version deleted]]

Hi All, I,m trying to do a GARCH simulation in R 2.3.0 release in Windows XP. I've seen garchsim function but that is for garch (1,1) and ?garch gives an example for ARCH simulation. Can anyone help me how can i extend the help shown in ?garch to GARCH simulation? Please help me in this regard. Thanks, Sumanta Basak.

Hi all R-Experts, I'm facing one problem in yahoo data downloading. I'm suing Windows XP, R 2.2.0, and i'm using yahoo.get.hist.quote function to download data. I need 500 companies of S&P index daily 'closing price' data for last ten years. My questions are: 1) I have all the ticker names of S&P 500 companies in a .csv format. I'm reading those names in R and

Hi R-Experts, Can anyone tell me how Bloomberg data can be directly downloaded to R? Is there any package? Sumanta Basak. ------------------------------------------------------------------------------------------------------------------- This e-mail may contain confidential and/or privileged infor...{{dropped}}

Hi R-Experts, I have a vector of length 72. I want to break it into 12 parts and want to take standerd deviation of each group. Please help me in this regard. Thanks, Sumanta. --------------------------------- [[alternative HTML version deleted]]

Hi All, I have a (331*12) matrix. I wan t to braek it into 28 parts each window having 12 rows, so that each matrix become (12*12) matrix. How can i do this. Thanks, Sumanta. --------------------------------- Send instant messages to your online friends - NOW [[alternative HTML version deleted]]

Hi All, Can you please tell me if i write a function, and want to return certain object, can "R" work on it? I know this works in S-Plus. function(x) { ....... a<-...... reaturn(a) } Does this work in "R"? Thanks, Sumanta. --------------------------------- What makes Sachin India's highest paid sports celebrity?, Share your knowledge on Yahoo! India Answers

Hi All, Currently I'm working in FIGARCH process [Fractionally Integrated Generalized Autoregressive Conditional Heteroscedasticity]. I've already got the codes to do the process in S-Plus. Can anyone help me to do it in R? Thanks, SUMANTA BASAK. ------------------------------------------------------------------------------------------------------------------- This e-mail may

Hi All, I need a basic help from you. I've built a function like this, windowlength<-function(x) { z <- rep(seq(0,331,by=x-1)+1, each=2) zz <- z[-c(1,length(z))] ind <- as.data.frame(matrix(zz, nr=2)) j<-lapply(ind, function(x) mat[x[1]:x[2],]) cat("For",x/4,"month

Hi R-Experts, I'm having a problem with reading a large data file which is in .csv format and size is 120 MB (app.). I was trying to use RODBC package but I found RODBCconnectExcel function only. And can I convert this file to .dbf format? How can I read this file? And also let me know if this was a file in .sas7bdat format, what should I do? Thanks in advance.

Hi All, I have certain combinations for which I have some value, e.g. 0 1 20 0 2 15 1 1 40 1 2 52 Now I need to sort this list for which I'll get the combination against the lowest value. In this case, 15, and the combination will be 0 2. -- SUMANTA BASAK. [[alternative HTML version deleted]]

Hi All, Currently I'm using DSE package for Kalman Filtering. I have a dataset of one dependent variable and seven other independent variables. I'm confused at one point. How to declare the input-output series using TSdata command. Because the given example at page 37 showing some error. rain <- matrix(rnorm(86*17), 86,17) radar <- matrix(rnorm(86*5), 86,5) mydata <-

Hi, I'm trying to work with TsayData in fSeries package. How can i fetch any time series data of this package. Please advice. Thanks, Sumanta Basak. Send instant messages to your online friends http://in.messenger.yahoo.com