Displaying 20 results from an estimated 1000 matches similar to: "RSQLite NA on input"
2017 Dec 14
1
match and new columns
Hi Bill,
I put stringsAsFactors = FALSE
still did not work.
tdat <- read.table(textConnection("A B C Y
A12 B03 C04 0.70
A23 B05 C06 0.05
A14 B06 C07 1.20
A25 A23 A12 3.51
A16 A25 A14 2,16"),header = TRUE ,stringsAsFactors = FALSE)
tdat$D <- 0
tdat$E <- 0
tdat$D <- (ifelse(tdat$B %in% tdat$A, tdat$A[tdat$B], 0))
tdat$E <- (ifelse(tdat$B %in% tdat$A, tdat$A[tdat$C], 0))
2017 Dec 13
2
match and new columns
Thank you Rui,
I did not get the desired result. Here is the output from your script
A B C Y D E
1 A12 B03 C04 0.70 0 0
2 A23 B05 C06 0.05 0 0
3 A14 B06 C07 1.20 0 0
4 A25 A23 A12 3.51 1 1
5 A16 A25 A14 2,16 4 4
On Wed, Dec 13, 2017 at 4:36 PM, Rui Barradas <ruipbarradas at sapo.pt> wrote:
> Hello,
>
> Here is one way.
>
> tdat$D <- ifelse(tdat$B %in% tdat$A,
2017 Dec 14
0
match and new columns
Use the stringsAsFactors=FALSE argument to read.table when
making your data.frame - factors are getting in your way here.
Bill Dunlap
TIBCO Software
wdunlap tibco.com
On Wed, Dec 13, 2017 at 3:02 PM, Val <valkremk at gmail.com> wrote:
> Thank you Rui,
> I did not get the desired result. Here is the output from your script
>
> A B C Y D E
> 1 A12 B03 C04 0.70 0 0
2017 Dec 13
3
match and new columns
Hi all,
I have a data frame
tdat <- read.table(textConnection("A B C Y
A12 B03 C04 0.70
A23 B05 C06 0.05
A14 B06 C07 1.20
A25 A23 A12 3.51
A16 A25 A14 2,16"),header = TRUE)
I want match tdat$B with tdat$A and populate the column values of tdat$A
( col A and Col B) in the newly created columns (col D and col E). please
find my attempt and the desired output below
Desired output
2017 Dec 13
0
match and new columns
Hello,
Here is one way.
tdat$D <- ifelse(tdat$B %in% tdat$A, tdat$A[tdat$B], 0)
tdat$E <- ifelse(tdat$B %in% tdat$A, tdat$A[tdat$C], 0)
Hope this helps,
Rui Barradas
On 12/13/2017 9:36 PM, Val wrote:
> Hi all,
>
> I have a data frame
> tdat <- read.table(textConnection("A B C Y
> A12 B03 C04 0.70
> A23 B05 C06 0.05
> A14 B06 C07 1.20
> A25 A23 A12 3.51
2013 Mar 15
1
Postfix/Amavisd/Clamd - Mail send failing
Dear All
With help from you all I am now at better stage. Special thanks to Robert.
Atleast I am able to run all the required services (postfix, amavisd, clamd
etc).
I sent a mail from my gmail, I received at my newly setup domain/mailbox.
I am facing issue while sending the mail outside.
>From maillog I realized, two issues are there.
*1. Virus scan failed. The error log is as below *
2007 Jan 02
1
RMySQL adn FC6 - install fail
Dear anybody
I am running Fedora Core 6 with the latest version of R.
When I try to install the package RMySQL I get this message:
* Installing *source* package 'RMySQL' ...
creating cache ./config.cache
checking how to run the C preprocessor... /lib/cpp
checking for compress in -lz... no
checking for getopt_long in -lc... no
checking for
2001 Jun 05
2
a bug? (PR#968)
--T4sUOijqQbZv57TR
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Dear R,
I would like to report what I think is a bug in R. I am running R
within emacs on a Digital AlphaStation. See the version information
at the end of my R session for details. I also attach a copy of the
file that is read in the `read.table' command.
Here's my R session, with a few
2000 Dec 07
2
Heteroskedasticity in R
Hi all,
I just discovered R a couple of days ago and I must say it rocks. I've been
looking for heteroskedasticity tests and couldn't find any, however.
Particularly, I've been told in one of my courses on econometrics of White's
method (>< white.test()).
The test's statistic is beta / sqrt(W), where W is Var(beta) "? la White",
that is the beta(i) matrix is
2007 Mar 15
1
Problem installing SystemVision from MentorGraphics
Hi,
I have a problem installing SystemVision from MentorGraphics in wine. The
problem is with the packaged Java Runtime 1.3.1.
The error output when installing is:
Exception in thread "main" java.lang.ExceptionInInitializerError:
java.lang.RuntimeException:
Unable to create a suitable default GraphicsConfiguration. Try changing your
Display Settings.
at
2004 Apr 01
1
YUV Format
I posted this the other day... but it didn't get delivered...
-------------------------------------------------------------------
I'm getting stuck into a theora decoder for directshow... i was just wondering if someone could give me some info.
What output format does theora use ?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwmt/html/YUVFormats.asp
2019 Dec 02
0
Running dovecot proxy as different user
I thought, I read somewhere I could prevent chroot with[1] but I am
still getting chroot errors[2].
drwxrwxr-x 2 10053 101 6 Dec 2 16:54 empty
drwxr-x--- 2 10053 101 73 Dec 2 17:00 login
drwxr-x--- 2 10053 101 44 Dec 2 17:00 token-login
[1]
service anvil {
chroot =
}
[2]
Dec 2 17:07:07 c04 dovecot: stats: Fatal: chroot(/var/dovecot/empty)
failed: Operation not permitted
Dec 2
2010 May 30
0
New package RSQLite.extfuns and minor upgrade for RSQLite
RSQLite.extfuns provides SQLite extension functions for use with
RSQLite. The package is a wrapper of extension functions written by
Liam Healy and made available through the SQLite website
(http://www.sqlite.org/contrib).
You can make the extension functions available on a per db connection
basis like this:
library("RSQLite.extfuns")
db <- dbConnect(SQLite(), dbname =
2010 May 30
0
New package RSQLite.extfuns and minor upgrade for RSQLite
RSQLite.extfuns provides SQLite extension functions for use with
RSQLite. The package is a wrapper of extension functions written by
Liam Healy and made available through the SQLite website
(http://www.sqlite.org/contrib).
You can make the extension functions available on a per db connection
basis like this:
library("RSQLite.extfuns")
db <- dbConnect(SQLite(), dbname =
2008 Feb 29
1
RSQLite error
Ein eingebundener Text mit undefiniertem Zeichensatz wurde abgetrennt.
Name: nicht verf?gbar
URL: https://stat.ethz.ch/pipermail/r-help/attachments/20080229/e3eaec7a/attachment.pl
2008 Apr 09
0
AnnotationDBI and RSQLite installation problem
Hi All,
I tried to install AnnotationDBI
like so:
source("http://bioconductor.org/biocLite.R")
biocLite("AnnotationDbi")
and got this error:
....
Loading required package: RSQLite
Error in dyn.load(file, ...) :
unable to load shared library '/RHEL3/local/lib64/R/library/
RSQLite/libs/RSQLite.so':
/RHEL3/local/lib64/R/library/RSQLite/libs/RSQLite.so: undefined
2009 Mar 16
1
errors when install RSQLite
Dear all,
I am trying to install RSQLite package since I want to install "sqldf", and
I used
>> install.packages("RSQLite") first, which gave Error message as below:
make: *** [RS-DBI.o] Error 1
chmod: cannot access `/usr/lib/R/library/RSQLite/libs/*': No such file or
directory
ERROR: compilation failed for package 'RSQLite'
** Removing
2010 Aug 13
2
64 bit RSQLite
Hi folks,
Ubuntu 10.04 64 bit
Where can I find 64 bit RSQLite?
It seems not there;
RSQLite: SQLite interface for R
http://cran.r-project.org/web/packages/RSQLite/index.html
TIA
B.R.
Stephen L
2008 May 19
1
RSQLite and undefined symbol:sqlite3_bind_in
Hi All,
I tried to install AnnotationDBI
like so:
source("http://bioconductor.org/biocLite.R")
biocLite("AnnotationDbi")
and got this error:
....
Loading required package: RSQLite
Error in dyn.load(file, ...) :
unable to load shared library '/RHEL3/local/lib64/R/library/
RSQLite/libs/RSQLite.so':
/RHEL3/local/lib64/R/library/RSQLite/libs/RSQLite.so: undefined
2010 Jun 10
1
HOW to install RSQLite database
Please let me know where i have to type below thing to RSQLite database get
installed.Please let me know the solution.Thanks in advance
RSQLite -- Embedding the SQLite engine in R
(The RSQLite package includes a recent copy of the SQLite
distribution from http://www.sqlite.org.)
Installation
------------
There are 3 alternatives for installation:
1. Simple installation:
R CMD