similar to: can not read table in dbReadTable

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)

Hello, I am new to R and am having difficulty formatting numerical output from a regression analysis. My code iteratively performs linear regression on a dataset while excluding certain data ranges. My code: rm(list = ls(all = TRUE)) sink("outfile") dat <- read.table("testdat", sep="\t", header=TRUE) int = 0.2 for (x in c(0:20)) { subdat <- subset(dat, time

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?

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

Hello everyone, as stated in the topic ? I would like to know which of above works better with wine... I will be buying laptop soon, and will probably have to chose one of above. Yes I know both Intel and ATI drivers for Linux sucks ? but I would like to know which of them sucks more ;], Nvidia will probably not be an option because of my current cash limitation (beside, I already got pretty

Hello. When i upgraded wine from 0.9.46 to 0.9.53 i noticed a annoying thing. When i run Baldur's Gate II - Shadows of Amn (and Icewind Dale II) on normal fullscreen mode they work fine. If i enable the "emulate a virtual desktop" option so that it runs on a window, it works fine until another window gets on top of the wine window. For example, i run xterm and run wine. If i click

Dear all I use aggregate with variables of type numeric and dates. For type numeric functions, such as sum() are very fast, but similar simple functions, such as min() are much slower for the variables of type 'dates'. The difference gets bigger the larger the 'id' var is - but see this sample code: dts <- dates(c("02/27/92", "02/27/92",

Does anyone know if Windows XP Pro (Service Pack 2) will have difficulty using a Samba share that is larger than 2 TB? Windows seems to be able to read and write from a share that is larger than 2 TB -- for instance, Windows will tell me that a share is 4 TBs in size, and if I have 1.5 TBs stored on it, it will tell me that 2.5 TB are free. But as soon as 2 TB of data have been written

Hi, recently we (oVirt) have started discussing whether the way virt-v2v handles import from OVA files is good. And I would be interested in ideas how it can be improved. It is likely somebody already gave some thought to this problem. TL;DR: Extracting the OVA before import is a problem for large VMs (in sizes of TBs). Can we change something to prevent the extraction and work directly over

Newbie question (just joined the list) Is anyone running Ruby on Rails in a teaching environment? Regards John John Colby BA, MBCS, PGCertE Lecturer, Department of Computing, The Business School Room F316, Galton Building, University of Central England, Franchise Street, Perry Barr, Birmingham B42 2SU Tel: +44 (0) 121 331 6937, Fax +44 (0) 121 331 6281, Mobile: 07795 215 912

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 =

I have two samba servers (version 2.2.2-2, debian sid) with identical configuration. One stands in the server room and is part of the server subnet. the other is in the normal 'user' subnet. I added both server (several times!) to the win2000 domain. the procedure was identical. Both have secret.tbs files of 8192 bytes opposite to the 6xx bytes which they have when they are not joined to

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

On 5/25/24 10:20, Rowland Penny via samba wrote: > There doesn't seem to be anything really wrong with your smb.conf > files, but it does seem that not only are you having problems with > different Samba fileservers, you are also having problems with > different domains. Yes. Probably I wasn't clear: I've seen this in different setups at different customers'.

The Wine development release 1.2-rc2 is now available. There are no new features in this release, only bug fixes, since we are in code freeze. If you find a new feature that's a bug. The source is available from the following locations: http://ibiblio.org/pub/linux/system/emulators/wine/wine-1.2-rc2.tar.bz2 http://prdownloads.sourceforge.net/wine/wine-1.2-rc2.tar.bz2 Binary packages

I have a dataset that's a few hundred thousand rows from a database (read in via dbreadTable). The database is like: > str(measures) `data.frame': 609363 obs. of 5 variables: $ vih.id : int 1 2 3 4 5 6 7 8 9 10 ... $ vi.id : int 1 2 3 4 5 6 7 8 9 10 ... $ vih.value: chr "0" "1989" "0" "N/A" ... $ vih.date : chr

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

Hi everyone, I'm trying to archive to a remote host but the size of the data to copy is prohibitively large to consider doing the sync over the wire (it's TBs of raw video), so i was wondering if it was possible to use a usb attached storage device as the transport medium. Is it possible for rsync to compare the two systems (over the network) finding any newer or different files on the

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 <-

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)