Displaying 20 results from an estimated 4000 matches similar to: ""nonstandard" column names"
2007 Mar 23
6
Updating a worksheet in Excel file using RODBC
Hello!
I have no problem reading Excel files (each worksheet in the file is a "table" which can be read - at least in my case).
What I would like to do is to read such a table, change it (just the contents, not the format) and write it back, and this I can not do. I am getting the following error messages (3 slightly different attempts):
> sqlSave(con, x, tablename =
2007 Jun 14
3
Responding to a posting in the digest
Is there a convenient way to respond to a particular
posting which is a part of the digest?
I mean something that will automatically quote the
original message, subject, etc.
Thank you!
Moshe Olshansky
m_olshansky at yahoo.com
2005 Sep 07
1
solving a system of nonlinear equations
What is the "classic" R function for solving a (possibly over
determined) system of non-linear equations?
Thank you!
Moshe Olshansky
e-mail: moshe.olshansky@brevanhoward.com
The information transmitted is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or
2008 Jul 10
5
rounding
Hi,
Round(0.55,1)=0.5
Round(2.55,1)=2.6
Can this be right?
Thanks,
Ed
[[alternative HTML version deleted]]
2008 Aug 24
3
Igraph library: How to calculate APSP (shortest path matrix) matrix for a subset list of nodes.
Dear R Users,
I have a network of 25000 total nodes and a list of 500 node which is a
subset of all nodes. Now I want to calculate the APSP (all pair shortest
path) matrix only for these 500 nodes.
I would appreciate any help.
Thanks in advance
Dinesh
--
Dinesh Kumar Barupal
Research Associate
Metabolomics Fiehn Lab
UCD Genome Center
451 East Health Science Drive
GBSF Builidng
University of
2020 Mar 17
2
strange bahaviour of predict.lm
Hello,
Below is my code:
> A <- matrix(rnorm(10*3),ncol=3)
> b <- runif(10)
> reg <- lm(b ~ A)
> A1 <- matrix(rnorm(5*3),ncol=3)
> A1 <- as.data.frame(A1)
> b1 <- predict(reg,A1)
Warning message:
'newdata' had 5 rows but variables found have 10 rows
? And instead of being an array of length 5, b1 is of length 10 and is identical to reg$fitted.values
I
2009 Aug 13
3
Solutions of equation systems
Hello all!
Maybe it's a newbie question(in fact I _am_, a newbie), but I hope
you'll find the solution.
I have an equation system which has k equation and n variables (k<n).
I would like to obtain a description of the solutions (which can be the
equation of lines or a plane, or everything else) with the lesser degree
of freedom, obviously using R.
In other words, I would like to
2007 Oct 19
2
Declaring variables in R
Please forgive me if my question is answered in Help
FAQ no. 23481739...
In language like C every variable must be declared
before it can be used.
In VBA, if a variable has not been declared it is
assumed to be of a special type (Variant).
In R (and Matlab) variables do not have to be
declared. This is convenient, but in a large program
one can make a typo which will be extremely difficult
to
2007 Aug 07
5
small sample techniques
If my sample size is small is there a particular switch option that I need to use with t.test so that it calculates the t ratio correctly?
Here is a dummy example?
รก =0.05
Mean pain reduction for A =27; B =31 and SD are SDA=9 SDB=12
drgA.p<-rnorm(5,27,9);
drgB.p<-rnorm(5,31,12)
t.test(drgA.p,drgB.p) # what do I need to give as additional parameter here?
I can do it manually but
2004 Aug 17
1
An entire data frame which is a time-series?
I have :
raw <- read.table("monthly.text", skip=3, sep="|",
col.names=c("junk", "junk2",
"wpi", "g.wpi", "wpi.primary", "g.wpi.primary",
"wpi.fuel", "g.wpi.fuel", "wpi.manuf", "g.wpi.manuf",
2008 Jul 08
8
Sum(Random Numbers)=100
Hi R,
I need to generate 50 random numbers (preferably poisson), such that
their sum is equal to 100. How do I do this?
Thank you,
Shubha
This e-mail may contain confidential and/or privileged i...{{dropped:13}}
2007 Nov 08
1
finite mixture model (or latent class)
Dear Listers,
My post might be somewhat OT.
Currently, I am trying to use flexmix to build a finite mixture model.
For instance, I am getting the prior probability and coefficients for
each latent class from training data. Is there a way to get the
posterior probablity and prediction of a new dataset?
What I am thinking is to apply the prior prob and coefficient from
training set to testing data
2007 Jun 07
1
Creating an Access (.mdb) database using R
Hello!
I have a short question: Is it possible to create a
(non-existing) Access database using R (and if yes,
how)? I need to create a new database and then insert
a few tables into it.
Thank you in advance,
Moshe Olshansky
m_olshansky at yahoo.com
2007 Jul 19
3
help with heatmap - how to remove annoying "X" before numeric values?
Hello All,
I have a simple question based on how things are labeled on my heat map;
particularly, there is this annoying "X" that appears before the numeric
value of all the labels of my columns.
Let's say I have the following silly data, stored in "temp.txt"
1905 1910 1950 1992 2011 2020
Gnat 0.08 0.29 0.29 0.37 0.39 0.43
Snake
2007 Aug 17
1
[BioC] function to find coodinates in an array
The arr.ind in the which function does the job very nicely!!!
Thank you everyone for the suggestions!
Ana
>
>
>---- Mensaje Original ----
>De: marc_schwartz at comcast.net
>Para: m_olshansky at yahoo.com
>Asunto: Re: [BioC] [R] function to find coodinates in an array
>Fecha: Thu, 16 Aug 2007 21:53:44 -0500
>
>>If I am correctly understanding the problem, I think
2004 Aug 21
3
Puzzled at lm() and time-series
I tried toy problems and there doesn't seem to be a basic problem
between lm() and ts objects:
X = data.frame(x=c(1,2,7,9), y=c(7,2,3,1))
lm(y ~ x, X)
X <- lapply(X, function(x) ts(x, frequency=12, start=c(1994,7)))
lm(y ~ x, X)
and this works fine - whether you do an lm() before or after making ts
objects, it's okay.
But I have a situation where things aren't okay.
2007 Aug 11
1
binomial simulation
hello,
I asked about this simulation a few days ago, but still i can't get what i
need.
I have 2 units: icu and regular. from icu I want to take 200 observations
from binomial distribution, when probability for disease is: p=0.6.
from regular I want to take 300 observation with the same probability: p=0.6
.
the distribution to detect disease when disease occurred- *for someone from
icu* - is:
2009 Jun 11
1
Thusnelda - Floating point exception in encoder_toplevel.c:209
Hi all,
I've been hitting the odd floating point exception errors using the
new alpha encoders. They're encoding a live stream so I can't reproduce
the crash on demand, and it might only happen once every few days so
it's been fun trying to get a backtrace. The crash happens in a fairly
scary block of code, I wouldn't have a clue where to begin trying to fix it!
2013 Mar 19
1
creating a new variable.
Hello, all.
The following is for my own research.
I have attached the relevant data in pdf from Transparency International. I am only interested in the "CPI 2010 scores" column.
I am interested in creating a variable for several of these countries. The idea is, they will become a country level aggregate IV "corruption". I am running models on about 10 countries,
2009 Sep 24
2
Downloading data from from internet
Hi all,
I want to download data from those two different sources, directly into R :
http://www.rateinflation.com/consumer-price-index/usa-cpi.php
http://eaindustry.nic.in/asp2/list_d.asp
First one is CPI of US and 2nd one is WPI of India. Can anyone please give
any clue how to download them directly into R. I want to make them zoo
object for further analysis.
Thanks,
--
View this message in