Displaying 20 results from an estimated 200 matches similar to: "Slow reshape from 5x600000 to 6311 x 132"
2012 Mar 15
1
eigenvalues of matrices of partial derivatives with ryacas
Hello,
I am trying to construct two matrices, F and V, composed of partial
derivatives and then find the eigenvalues of F*Inverse(V). I have the
following equations in ryacas notation:
> library(Ryacas)
> FIh <- Expr("betah*Sh*Iv")
> FIv <- Expr("betav*Sv*Ih")
> VIh <- Expr("(muh + gamma)*Ih")
> VIv <- Expr("muv*Iv")
I
2010 Jul 23
2
decimal seperator
Hi R-List,
I have a question regarding R-language formats, I think. I am producing a
series of graphs (using plot, barplot, barchart, and bwplot, using either
text or mtext to place values on the graphs) and tables for a Francophone
country. In fact, I have already done so. However, while they are pleased
with the results they've requested I convert all of my decimal points into
the French
2008 Aug 28
1
[LLVMdev] Export maps and -fvisibility-inlines-hidden
Apologies for the cross-post, this effects both clang and llvm.
I was looking into the startup time of clang on small files
(
http://lists.cs.uiuc.edu/pipermail/cfe-commits/Week-of-Mon-20080818/007171.html
)
and discovered that a significant amount of our startup time was being
spent in the linker resolving weak symbols. At least on Darwin, this was
actually the dominant factor in our startup
2003 Mar 14
4
Am I getting the best performance?
Okay, I've been chasing performance for a while now. I have no idea if I
should be trying to get better performance or if I'm getting all I can out
of my hardware. Here is the information:
/sbin/hdparm -I /dev/hdd
/dev/hdd:
ATA device, with non-removable media
Model Number: ST328040A
Serial Number: 7BY034XB
Firmware Revision: 3.07
Standards:
2014 Apr 30
1
[Bug 10579] New: --xattr internal abbrev error
https://bugzilla.samba.org/show_bug.cgi?id=10579
Summary: --xattr internal abbrev error
Product: rsync
Version: 3.1.0
Platform: All
OS/Version: Mac OS X
Status: NEW
Severity: major
Priority: P5
Component: core
AssignedTo: wayned at samba.org
ReportedBy: samba at haravikk.com
2001 Mar 16
2
Installation problems
When I try to install the tinc RPM I am missing
[root@relay buytaert]# rpm -vih tinc-1.0pre2-1.i386.rpm
error: failed dependencies:
libgmp.so.2 is needed by tinc-1.0pre2-1
[root@relay buytaert]# ls /usr/lib/libgmp.so.3
/usr/lib/libgmp.so.3
[root@relay buytaert]# rpm -qf /usr/lib/libgmp.so.3
gmp-3.1.1-3
This seems to be a too recent version.
So I tried compiling it and got the following
2012 Nov 02
1
can not read table in dbReadTable
> tbs<-dbListTables(con)
>
> tbs
[1] "lowend" "time" "week30" "week33" "week39" "week42"
> my.data.copy <- dbReadTable(tbs, "week42")
Error in function (classes, fdef, mtable) :
unable to find an inherited method for function "dbReadTable", for signature "character",
2012 Nov 06
0
How to read all table in r using dbreadTable, autimatically read in whenever I save new table in SQLite db
HI,
I got the problem.
I use the following query to read table individually, how can I read all tables autimatically rather than typing "week42" "week33" in dbReadTable?
library(RSQLite)
library(sqldf)
drv <- dbDriver("SQLite")
con<-dbConnect(drv, "sqlite.db")
dbListTables(con)
#dbRemoveTable(con, "week39")
dbDisconnect(con)
2009 Dec 24
1
How to dbReadTable() only a limited number of rows? (RMySQL)
I only want to load a limited number of rows by dbReadTable(). I don't
see an option in the help. Is there an option to do so?
2011 Jul 01
1
RMySQL, RODBC, dbReadTable and ISO-8859-1 (Spanish data)
Hello R users,
I am reading data into R from RMySQL or SQLite databases which are in
Spanish language. I am using RMySQL library and function dbReadTable but I
could not get characters with ñ and tilde, instead R does put ?.
In the past I could manage it modifying the R options as (using windows):
op <- options()
op$encoding <- "iso-8859-1"
options(op)
but now in ubuntu it did
2008 Nov 06
1
RMySql inserts \r when using dbWriteTable
I am using R 2.8 and the latest versions of RMySQL on a Windows XP 64 bit
machine.
I was wondering if someone could help me figure out how to use dbWriteTable
without inserting \r into my table. Consider the following code snippet,
which is
run after I connect to my database.
myDFOut = dbReadTable(conn, "myDF")
print(myDFOut)
myDFIn = data.frame(x=paste("x", 1:5, sep =
2005 Feb 01
2
How to get a table of MySQL database as a matrix variable in R
It seems that the dbReadTable() method provided by RMySQL could not
get rid of the headers, neither the index column... So
1. Can I use read.table() method to get a table of MySQL database?
>From the help document the argument of 'file' of read.table() method
could be a connection...
2. How can I obtain a matrix from the database table contains all
elements except the headers and the
2008 Aug 11
1
Unwanted carriage returns storing dataframes with dbWriteTable
If I save a dataframe with a character-typed last column to a relational
database with dbWriteTable, the values in the last column of the
resulting table in the database will have a '\r' (carriage return)
appended. If I read back the dataframe with dbReadTable the last column
in the resulting dataframe has also '\r' appended (see protocol below).
Setting or unsetting sql-mode
2002 Dec 18
1
A little problem handling logicals in RMySQL under R1.6.1
There is a little problem in handling logicals in RMySQL:
# here is the MySQL connection
> con
<MySQLConnection:(1816,0)>
# here is the data frame
> print(a<-data.frame(x=c(TRUE,FALSE),y=c(FALSE,TRUE)))
x y
1 TRUE FALSE
2 FALSE TRUE
# as promised, the two data frame columns are identified as logicals and
# the field types are set to tinyint
> field.types <-
2007 Oct 01
2
xyplot
Hello,
I am calling the following code with the loop! It makes 3 out graphs but empty! COuld you help me plase on that? Thank you in advance
z1 <- dbConnect(MyData, "something", "A1", "A2")
for (tt in c("xyz", "abc", "m1")) {
message(paste("Here", tt, "!!!"))
mydata <- dbReadTable(z1, tt)
2001 Mar 19
3
generic database access methods
I've been putting together a package that defined generic methods for
database access. The packages is called "Rdbi." It borrows as much as
possible from existing database packages / proposals. I'd like to start
a discussion about the proposed interface. Here's what I've come up
with so far:
#
# Rdbi: connectionMethods.R
#
dbConnect <- function(dbObj, ...)
2010 Apr 30
0
RMySQL and dates
I am trying to read and write database tables that have a date field in
them.
I am constructing a data.frame, then using dbWriteTable to create the
table and dbReadTable to read it.
>datatbl<-data.frame( dates, trialnum, fooddel, ethdel, trialtime,
trialtype, deliveries, food, ethanol, fcumrec, dcumrec, rrf, rrd)
>ifelse(startdate==filelist,
2005 Apr 02
2
RMySQL question
Dear List,
I have this little problem:
I work with adiacency matrix like:
data me you
me 0 1
you 1 0
I store those matrix in a mysql database
actually I use RMySQL with:
res<-dbSendQuery(connection, "SELECT * FROM table")
myDataFrame<-fetch(res)
to retrive the table, and I have
data me you
1 io 0 1
2 tu 1 0
I would like the first column to be seen
2012 Mar 27
1
RSqlite UPDATE command problem
All:
I am using RSqlite and want to be able to update individual values in a
record, such as with this simple example:
library(RSQLite)
drv<-dbDriver("SQLite")
con<-dbConnect(drv,"test.db")
my.data<-data.frame(countries=c("US","UK","Canada","Australia","NewZealand"),vals=c(52,36,74,10,98))
2012 Nov 06
1
how Can make function for selecting the products
HI.
I make this code:
getdata<-function('a','b','c' ,'d','e','f'){
drv <- dbDriver("SQLite")
con<-dbConnect(drv, "sqlite.db")
lt<-dbListTables(con)
myf<-data.frame(NULL)
for (i in 1:length(lt))
{
myfile<-dbReadTable(con,lt[i])
myfile1<-myfile[-c(14:44)]
myfile1$MODEL<-gsub(" ",