similar to: Query an Access database based on a date attribute (Tudor Bodea)

Dear useRs, I would like to query an Access database through R based on a date attribute but, unfortunately, I fail to do so. For example, the table test_table of the test.mdb looks like: ID cd market competitor dd price 1 1 2007-11-20 atl-bos delta 2007-11-20 210 2 2 2007-11-20 atl-bos delta 2007-11-21 190 3 3 2007-11-20 atl-bos delta 2007-11-22

It seems that Access needs that you surround the dates with a # symbol. You probably need something like. res <- sqlQuery(channel, "select * from test_table where market = 'atl-bos' and competitor = 'delta' and dd = #2007-11-20#") Hope this helps, Stefano -----Messaggio originale----- Da: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org]Per

Dear useRs: Is there a way to include a raster image (e.g., .gif, .jpg, .bmp) representing a company logo, a school logo, etc. into an R graphic? For example, it would be nice to be able to include the logo of the school into the charts that a student produces for her dissertation. Similarly, while working on a competitive analysis, it would be nice to be able to replace the names of the

Hi, I have a test_table where the dim is 62220 by 73 (row by col) I would like to partition the rows into 170 equal parts (170 tables where each is of dim 366 by 73), and rearrange them horizontally. The source codes I have: for (i in 1:170) { c = cbind(c,test_table[(367*i+1):(367*(i+1)),2:73]); } Unfortunately, using for loop and cbind for a table of this size

Dear UseRs: I intend to write a package to handle the basic operations a revenue management analyst has to deal with on a regular basis (e.g., demand untruncation, capacity allocation, pricing decisions, etc.). Following the directions posted by Peter Rossi (Making R Packages under Windows: A Tutorial, January 2006) I was able to build an interim package that currently consists of one simple

Dear useRs, Do you know, by any chance, if it is possible to write a string in the header/footer of a pdf file created during a plot session? To make sure that I know what R script generated a certain chart, I would like to add the path to the working directory into the header/footer of the corresponding pdf file. Thank you. Tudor -- Tudor Dan Bodea Georgia Institute of Technology School of

Dear useRs: Please provide me with your thoughts on an issue related to the design of a production level system. For example, let?s suppose that I need to run the same R script for a finite sequence of items (e.g., in the energy industry, I may need to asses the profitability of all gas stations in the state of Florida). For each of the items, the R script accesses some remote databases, gets

Hi, table1D() below can be up to 60x faster than base::table() for the 1D case. Here are the detailed speedups compared to base::table(). o With a logical vector of length 5M: 11x faster (or more if 'useNA="always"') o With factor/integer/numeric/character of length 1M and 9 levels (or 9 distinct values for non-factors):

useRs, Don't know if this requires a bug report, but using the read.spss function on files written by the new SPSS 12.0 produces the following warning message: Warning message: C:\data\spss.sav: Unrecognized record type 7, subtype 13 encountered in system file. The data files appear to be read correctly. The warning likely results from changes to the file format due to SPSS increasing

i found model allway query this sql: SHOW FIELDS FROM test_table if my code needn''t know table structure, how to remove it? -- Posted via http://www.ruby-forum.com/.

Dear R users: Is there a way to append selectively to components of a list (if possible, loops are to be avoided)? To illustrate the point, in the example below, I would like to append 99 to vector b of the list l. > l <- list(a=c(1), b=c(2,3), c=c(4,5,6)) > l $a [1] 1 $b [1] 2 3 $c [1] 4 5 6 As you may expect, the result should look like: > l $a [1] 1 $b [1] 2 3 99 $c [1] 4 5

Please use a descriptive subject and not tag onto a prior thread for new topics. Assuming the first row is time 1 and the second row is time 2 and so on try: diff(log(P)) On 6/15/06, Wong, Kim <kwong at nymex.com> wrote: > > Hi, thank you all for the help. > > The split function works very well. > > I have an additional question. If I have a matrix of prices (row = 30,

Dear list, How can I add the mean and standard deviation to each of the boxplots using the example provided in the boxplot function? boxplot(len ~ dose, data = ToothGrowth, boxwex = 0.25, at = 1:3 - 0.2, subset = supp == "VC", col = "yellow", main = "Guinea Pigs' Tooth Growth", xlab = "Vitamin C dose mg",

After 25 years of using SPSS syntax I am having some problems adapting to R. It would be a huge help for people like myself to have an introductory help document, like "R for SPSS Users". Such a document would jump start SPSS users by covering the use of the foreign function to read ".sav" files, then show equivalent R syntax for the most common SPSS procedures. Once

I've started a "tribe" for discussing R and sharing scripts. Tribe.net is one of the popular on-line social communities, like "Friendster". Visit and see if it is a forum that you find useful. To join the "tribe" you will need to register with Tribe.net. I hope it will be of help to newbies, although I'm new to R myself. Here is the url:

Hello I do not know very much about statistics (and English language too :-( ), then I come in search of a clarification (explanation): I found two distinct results on KURTOSIS and I do not know which of them is the correct one. Any aid will be welcome! klebyn ################ CODE rnorm(1000) -> x library(moments) kurtosis(x) skewness(x) detach("package:moments")

Hello, I wanted to share with a colleague a few R functions that I wrote. To this purpose, I created a small package on my machine (Unix) and emailed it to her. Now she is having troubles installing the package on her Windows machine. It seems that on her side, install.packages looks for a "zip" file - while I have created a "tar.gz" file. I tried to build the package with the

SuperRedCloth v1.160 and svn rev 163 don''t work the textile commands that specify table headers instead of table data. Here''s a simple test: require ''superredcloth'' w = "|_. a|_. b|_. c|\n|1|2|3|" h = SuperRedCloth.new(w).to_html puts h <table> <tr> <td>_. a</td>

> From: Spencer Graves [mailto:spencer.graves at pdf.com] > > Martin says, "This is another instance of S-Plus following R > behind and doing it incompatibly [with a reason?] ... ." > > This is one example of a major issue in "how to wage and win a > standards war", discussed by Shapiro and Varian (1998) > Information Rules >

Check out the proposed prices when this is approved. BELL CANADA REPORT ON THE ECONOMIC EVALUATION FOR THE TARIFF REVISION OF Bell Canada's Access Services Tariff Item 315 ? Zero-Dialed Emergency Call Routing Service (0-ECRS) *2 March 2006 TABLE OF CONTENTS Page 1.0 GENERAL 3 1.1 Purpose of the Study 3 2.0 SERVICE DESCRIPTION 3 2.1 Service Characteristics 3 2.2