Displaying 8 results from an estimated 8 matches for "test_tabl".
Did you mean:
test_table
2006 Jun 15
4
help with table partition
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]);...
2007 Nov 13
2
Query an Access database based on a date attribute (Tudor Bodea)
...Bodea asked:
>In this context, I try to get all the records for which market is atl-bos,
>competitor is delta and dd is 2007-11-20 (first record above). To do this I used
>># channel <- odbcConnectAccess("test.mdb")
>>res <- sqlQuery(channel, "select * from test_table where market = 'atl-bos'
>>and competitor = 'delta' and dd = 2007-11-20")
>Does any of you know what it is going on?
Try this:
res <- sqlQuery(channel, "select * from test_table
where market = 'atl-bos'and competitor = 'delta' and dd = {...
2007 Nov 13
1
R: Query an Access database based on a date attribute
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 conto di Mark Wardle
Inviato: marted? 13 novembre 2007 11.59
A:...
2007 Nov 12
2
Query an Access database based on a date attribute
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 180
4 4 2007-11-20 atl-bos united 2007-11-20 205
5...
2013 Aug 09
1
a fast table() for the 1D case
...s <- array(t2)
dimnames(ans) <- list(as.character(x2))
names(dimnames(ans)) <- "x" # always set to 'x'
class(ans) <- "table"
ans
}
table1D() also fixes some issues with base::table() that can be exposed
by running the tests below.
test_table <- function(FUN_NAME)
{
FUN <- match.fun(FUN_NAME)
.make_target <- function(target_names, target_data)
{
ans <- array(target_data)
dimnames(ans) <- list(as.character(target_names))
names(dimnames(ans)) <- "x"
class(...
2006 Feb 27
1
rails activerecord
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/.
2006 Jun 15
0
log returns (was: Re: help with table partition)
...u, 15 Jun 2006 09:38:29 -0400
> From: "Wong, Kim" <kwong at nymex.com>
> To: <r-help at stat.math.ethz.ch>
> Subject: [R] help with table partition
>
> > 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:
> >
> >
> >
> &g...
2007 Mar 24
3
Patch for superredcloth to enable textile table headers
...#39;th'' : ''td''
+ "\t\t\t<#{tdtype}#{pba(opts)}>#{opts[:text]}</#{tdtype}>\n"
end
def tr_open opts
"\t\t<tr#{pba(opts)}>\n"
[~/dev/rails/why/superredcloth]$ svn up
At revision 163.
[~/dev/rails/why/superredcloth]$ ruby test_table.rb
<table>
<tr>
<td>_. a</td>
<td>_. b</td>
<td>_. c</td>
</tr>
<tr>
<td>1</td...