Displaying 20 results from an estimated 9000 matches similar to: "Muliple SQL statements / Return percentage of rows"
2009 May 15
2
Help with loops
Hi
I am trying to create a loop which averages replicates in my data.
The original data has many rows. and consists of 40 column zz[,2:41] plus row headings in zz[,1]
I am trying to average each set of values (i.e. zz[1,2:3] averaged and placed in average_value[1,2] and so on.
below is my script but it seems to be stuck in an endless loop
Any suggestions??
for (i in 1:length(average_value[,1])) {
2009 May 15
1
Fw: Help with loops(corrected question)
--- On Fri, 15/5/09, Amit Patel <amitrhelp at yahoo.co.uk> wrote:
> From: Amit Patel <amitrhelp at yahoo.co.uk>
> Subject: Help with loops
> To: r-help at r-project.org
> Date: Friday, 15 May, 2009, 12:17 PM
> Hi
> I am trying to create a loop which averages replicates in
> my data.
> The original data has many rows. and consists of 40 column
> zz[,2:41]
2006 May 10
0
Passing Muliple Parameters with remote_function
<select name="media" id="media" onchange="<%= remote_function(
:url => { :action => :show_performer_categories,
:rate_group_id => @rate_group },
:with => "''media_id=''+this.value''"
) %>">
I''m guessing that''s wrong since WebRick does nothign when I
2011 Aug 25
0
plotting muliple CI ellipses for lm estimates
Hi,
I have read your post about plotting multiple CI ellipses and I would like too, but I don?t know how.
I would like to plot an ellipse for each group and I have slope and intercepts, but I don?t know what to put in the arguments shape and radius.
CAn you help me please?
1999 May 25
1
Muliple partial matches with pmatch
I am using R0.64.1 under Windows 95.
The help for `pmatch' states that:
If `duplicates.ok' is false multiple matches will result
in the value of `nomatch' being returned, and if it is
true, the index of the first matching value will be
returned.
The help for pmatch gives the following examples:
pmatch("m", c("mean",
2008 Apr 13
1
plotting muliple CI ellipses for EB estimates
I have empirical Bayes estimates for slopes and intercepts for a number of
subjects and I would like to plot the slopes and intercepts with confidence
ellipses. These ellipses would be based on the confidence intervals for the
slope and intercepts (forming the major and minor axis of each ellipse), and
the correlation in the slope and intercepts.
The ellipse function in the car library
2013 Nov 05
1
How can I use muliple cores of CPU in Windows or OS X?
Dear all,
I have about 50 pages of R codes and ran it in both OS X and Windows.
It takes at least haft a day to have the results. The running time is not very different in both Systems.
I found that R does not use all cores of CPU by default.
Can anybody help me to use all cores of CPU in my programming from the beginning or through programming in both OS X and Windows?
Many thanks your
2004 Dec 20
1
muliple plots with pairs (matrix of scatter plots)
I am trying to make a graph with 4 scatter matrixes plots and
couldn't do it. While trying to find a solution for this I also came
across the idea of giving different values to the same argument for
each of the lower and upper function but couldn't do it. (Examplified
below with the col argument). The first problem of plotting 4 scatter
matrixes in a graph is a problem of real
2011 Jun 22
2
Panic: doveadm quota get -A
Hi,
I'm new to the list and I'm using dovecot since 2 months. Still in progress to migrating from Stalker (Communigate Pro) to Dovecot.
Today I upgraded from Dovecot 2.0.13-0~auto+27 (used form the Mirror xi.rename-it.nl - stable-auto) to 2:2.0.13-0~auto+48.
List of installed packages:
ii dovecot-common 2:2.0.13-0~auto+48 secure mail server that supports
2010 Jun 21
2
Panic: file doveadm-print-table.c: line 56 assertion failed
Hi Timo,
`doveadm -f table mailbox status -u bar all inbox\*` aborts with:
Panic: file doveadm-print-table.c: line 56 (doveadm_calc_header_length):
assertion failed: ((value_count % hdr_count) == 0)
Backtrace is attached.
Regards,
Pascal
--
The trapper recommends today: c01dcofe.1017215 at localdomain.org
-------------- next part --------------
An embedded and charset-unspecified text was
2008 Sep 22
1
Ccreating methods on the fly / counting distinct field values
Hi,
I''m pretty new to ruby and rails, so apologies if this has been covered
before (I couldn''t find a thread on it).
I want to retrieve a count of records held in the DB for every distinct
value of an attribute.
E.g. given a class Address with a postcode field, I would like to retrieve
an array of ValueCount objects. The ValueCount object would hold the value
retrieved from
2006 Feb 22
2
loggin of sql statements
Is there a way to have rails log the sql statement that it runs. It
would be much easier for me to debug my code if I could actually see the
sql that active record is using.
Charlie
recentrambles.com -> use Time not DateTime
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2010 Dec 11
1
Can be Xapian used to perform standard SQL statements?
Hello,
I'm developing an HTTP application server dedicated to IR. The server side
languaje is Javascript throught the Webkit Javascript engine exposing
several C++ libraries conforming the commonjs specs.
My question is, can Xapian be used to perform standard SQL statements like
inserts or updates? I undestand that Xapian does it when you perform a query
or save a document but I haven't
2010 Oct 03
1
Package for converting R datasets into SQL Server (create table and insert statements)?
Hi,
R contains many good datasets which would be valuable in other
platforms as well. My intention is to use R datasets on SQL Server as
a sample tables. Is there a package that would do automatic conversion
from the dataset "schema" into a SQL Server CREATE TABLE statement
(and INSERT INTO statements)?
For example.
> str(cars)
'data.frame': 50 obs. of 2 variables:
$
2008 Sep 02
2
SSL fields as variables for SQL statements ...
Hi,
I was wondering if there is any possibility to access the status if a
user has provided a certificate, that has been accepted or not via
variables. And further if there is any way to get the value of SSL
certificate fields by use variables. I'd like to use those variables in
sql statements.
I then could assign a single certificate to a user, and make up passdb
sql statements, that
2007 Aug 15
1
Geodata SQL statements with multiple results in the controller
Hi Everyone-
In my project I need to take a zip code and get all the schools within
the selected mile radius of that zip code. In addition I will need to
check to see if the user selected any other items to add to the
search.
My problem is the geo code will return multiple results and I need to
get that result into the final sql string.
The flow is this:
Get the zip code and mile radius the
2017 Oct 19
0
[Bug 1193] New: Incorrect malloc for SQL statements and missing strings length check
https://bugzilla.netfilter.org/show_bug.cgi?id=1193
Bug ID: 1193
Summary: Incorrect malloc for SQL statements and missing
strings length check
Product: ulogd
Version: SVN (please provide timestamp)
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5
2010 Mar 24
2
translating SQL statements into data.table operations
I've recently stumbled across data.table, Matthew Dowle's package. I'm
impressed by the speed of the package in handling operations with large
data.frames, but am a bit overwhelmed with the syntax. I'd like to express
the SQL statement below using data.table operations rather than sqldf (which
was incredibly slow for a small subset of my financial data) or
import/export with a
2009 May 25
3
Interpolating variables within (RODBC library) SQL statements for MySQL
Hi everyone,
I am desperately looking for a method to interpolate strings within an SQL
statement as follows:
I get a lot of rows out of a database (in my example POSITION_to_ZIPCODE
Database with holds records for German ZIP Code <--> Gauss-Krueger
Coordinate System ) and want this to be selected and computed individually
row by row as follows:
library(RODBC)
channel <-
2004 Dec 13
3
Percentages in contingency tables *warning trivial question*
I hesitate to post this question in the light of recent threads, indeed
I have hesitated for several weeks, however I have come to a full stop
and really need some help if I am going to progress. I am a new user of
R for medical statistics. I have attempted to read all the relevant
documents, but would welcome any suggestions as to what I have missed.
I am trying to contruct "table 1"