Displaying 6 results from an estimated 6 matches for "assigntable".
Did you mean:
assignable
2001 Aug 15
1
Re: R: Mailing Lists
Is it true that append=T does not work in assignTable() in RMySQL ?
More specifically: I cannot append a data.frame to an existing table
in a MySQL database, although I can use the same data.frame to
create a new table.
Even more specifically:
> assignTable(con,"employee",dita,append=T)
Error in execStatement.MySQLConnection(con, state...
2003 Apr 23
0
MySQL
Dear laurent,
> But there are lots of commands I found in R docs which are "not found",
> such as getTable. Deprecated (I successfully used dbListTables) or do I
> simply miss a package ?
>From RMySQL\NEWS:
* added (almost) trivial convenience RS-DBI functions getTable(),
assignTable(), existsTable(), and removeTable(). They all mimic the
corresponding R/S get(), assign(), exists(), and remove(), and they
all work with a connection object and an sql table name (NOT generic
SQL queries); assignTable() assigns a data.frame object (or coerceable)
to the database. (The...
2007 Aug 27
4
Problem with save or/and if (I think but maybe not ...)
...MySQL
for (i in 1:length(p0fichiers))
{
donnees<-read.table(p0fichiers[i], quote="\"", sep=";", dec=",",
skip=18)
jourheure<-paste(donnees$V1, donnees$V2, sep=" ")
donnees[1]<-jourheure
donnees<-donnees[,-2]
# assignTable(con, "Datatable", donnees, append=TRUE) - Ne marche pas
dbWriteTable(con, "Datatable", donnees, append=TRUE)
rm(donnees, jourheure)
}
# Idem avec les fichiers d'extension .Px en chargant toutes les lignes
(skip=0)
# Amelioration possible : creer une fonctio...
2005 Sep 15
1
Coefficients from LM
Hi everyone,
Can anyone tell me if its possibility to extract the coefficients from the
lm() command?
For instance, imagine that we have the following data set (the number of
observations for each company is actually larger than the one showed...):
Company Y X1 X2
1 y_1 x1_1 x2_1
1 y_2 x1_2 x2_2
1 y_3 x1_3 x2_3
(...)
2 y_4 x1_4 x2_4
2 y_5 x1_5 x2_5
2 y_6 x1_6 x2_6
(...)
n y_n x1_n x2_n
n
2005 Oct 27
2
RSQLite problems
Hi, I'm experimenting with using (R)SQLite to do data management. Here are
two little problems that I've encountered:
1. The presence of ',' in string values causes trouble since ',' is also the
delimiter used in the SQL statement.
2. A newline '\n' line attached to the last string value of each row.
Some examples:
> library (RSQLite)
Loading required
2002 Oct 16
5
Database newbee problem...
Hi all,
This is a potentially very stupid question about MySQL <-> R
interaction, but I have not been able to solve it.
I'm just trying to connect R to my MySQL databse, and gets this:
> library(RMySQL)
Loading required package: methods
> m <- dbDriver("MySQL")
> con <- dbConnect(m,group="testdb")
Process R segmentation fault at Wed Oct 16 07:04:30