Displaying 20 results from an estimated 400 matches similar to: "Rmysql - dbWritetable"
2010 Oct 03
2
Read file
Dear R-users,
I would like to know how could I read a file with different lines lengths.
I need read this file and create an output to feed my database.
So after reading I'll need create an output like this
"INSERT INTO TEMP (DATA,STATION,VAR1,VAR2) VALUES (20100910,837460, 39,390)"
I mean, each line should be read. But I don`t how to do this when these
lines have different
2010 Mar 12
4
Form using R
Hi, R users
We can create a form using R?
I would like to create a form where the information can be read by R.
Itneeds to be updated daily because I have to tabulate the reasons for
delays
in the generation of numerical models products.
I really appreciate any help,
Thanks in advance,
Nilza Barros
[[alternative HTML version deleted]]
2010 Apr 22
2
legend problem
Dear R users,
I have been plotting several graphics in only one page. I intend to plot
only one legend in each page.
Since the graphics are inside a loop I have to do it automatically.
The main problem is that inside the loop I work with differente types of
variables, I mean , the range is different for each one.
I have already tried :
par(xpd=TRUE)
pos<-par("usr")
2010 Sep 27
3
Output Graphics GIF
Dear R users,
How could I managed graphics in GIF format? What I have been doing is
graphics in *.ps or *.eps and after I convert them using CONVERT (from
ImageMagick) but the output quality is not good. Since these graphics will
be use for other users they must have a better image quality.
I really appreciate any help,
--
Abraço,
Nilza Barros
[[alternative HTML version deleted]]
2012 Feb 12
2
Reading data from a worksheet on the Internet
Dear R-users,
I have to read data from a worksheet that is available on the Internet. I
have been doing this by copying the worksheet from the browser.
But I would like to be able to copy the data automatically using the url
command.
But when using "url" command the result is the source code, I mean, a html
code.
I see that the data I need is in the source code but before thinking
2010 Feb 10
2
manipulate missing dates in a graphics a vector
Dear all,
I am trying to identify the days absent in a vector so as to be able to
display missing data in the graphics in .It should be done automatically
since the graphics will be generated for different periods of the year.
I have been trying to do a function below but it did not work. I really
appreciate any help
ordados <- function(datas,var)
{
ind <- !datas %in% var # find the
2011 May 09
2
Using NULL to my data?
Dear R users,
I am reading data from a file where there are some missing that are
represented by -9999.00.
I am using the command below.
=====My original data ===========
PARM = TMPC;T12X;T12N;DWPC;PALT;SKNT;DRCT;P24M;CLCL
STN YYMMDD/HHMM TMPC T12X T12N DWPC PALT
SKNT
DRCT P24M CLCL
820420 110429/1200 22.50 -9999.00
2005 Dec 14
0
SAS.xpt/STATA.dta, field descriptions, and dbWriteTable
Hello all,
I have a large database (~100MB in 13 relational
files) that made its way to me in two formats. The
files were sent in both SAS xport and STATA, thanks, I
am told, to stat-transfer. The two files, ostensibly,
contain the same data, just in different formats.
My goal: Move these files to MySQl without the help of
SAS or STATA (which I do not have).
The tools I am using are:
1.
2012 Jun 12
1
Not able to write to PostgreSQL database using "dbWriteTable"
Dear R User's
Please help me to debug this issue. I am trying to write some data ( i=
6) to PostgreSQL database, but it not writing.
Is there any issue in the way I use "dbWriteTable"?
++++++++++++++++++ Source Code ++++++++++++++++++++++++
library("DBI")
library("RPostgreSQL")
drv1 <- dbDriver("PostgreSQL")
i=6
connAE1 <- dbConnect(drv1,host
2010 May 07
2
Package RPostgreSQL : Problem with dbWriteTable
Un texte encapsul? et encod? dans un jeu de caract?res inconnu a ?t? nettoy?...
Nom : non disponible
URL : <https://stat.ethz.ch/pipermail/r-help/attachments/20100507/f5128631/attachment.pl>
2011 Dec 02
2
help in dbWriteTable
hi
I need some help in dbWriteTable.
I'm not able to insert the rows in the table if the column order are not
same in the database and in the dataframe which i'm inserting. Also facing
issue if the table is already created externally and inserting it thru
dbWrite.
is there some way that we can sepecify the rownames in the dbwrite..or any
method which will solve my problem
--
View
2017 Aug 29
0
DBI::dbWriteTable syntax error apparently from quotes
Double quotes are not legal SQL syntax. Use single quotes.
--
Sent from my phone. Please excuse my brevity.
On August 29, 2017 2:21:44 AM PDT, Eric Berger <ericjberger at gmail.com> wrote:
>I have been successfully using RODBC for a long time (years) to connect
>to
>MS SQL Server from R.
>This week I wanted to try using odbc but I am seeing some problems
>which
>may be
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 =
2007 Jun 06
1
Question: RMySQL bulk load/update one column, dbWriteTable()?
Hi,
I have a question reading using RMySQL trying to load one R vector into a
table column. To be more specifically, the table is there populated. Now I
add a new column and want to populate this.
Can some colleagues on this list teach me how to do this? I know how to
write one R object/table into MYSQL table using dbWriteTable. But in this
situation, I just want to do one column.
Thanks
2009 Jun 30
0
dbWriteTable in loop
Hi,
I have to write the results of a loop in a database, and
I'm using dbWriteTable(con, "output", data).
Is it possible to use something like
for(i in 1:n)
...
tmp <- sprintf("output%s", i)
dbWriteTable(con, tmp, dati)
to write in the database each table produced by each run of the loop?
if not, do you have alternative solutions?
thanks in advance
--
View this
2011 Nov 08
1
dbWriteTable with field data type
Hello,
When I do:
dbWriteTable(con, "r.BOD", cbind(row_names = rownames(BOD), BOD))
...can I specify the data types such as varchar(12), float, double
precision, etc. for each of the fields/columns?
If not, what is the best way to create a table with specified field data
types (with the RpgSQL package/R)?
Regards,
Ben
[[alternative HTML version deleted]]
2010 Oct 22
0
dbWriteTable
I'm having a strange problem with dbWriteTable ... I have the dbWriteTable
inside a batchloop.
dbWriteTable(con,"mutual_funds",tmp_MF_Data_F,append=T,row.names=F) # append
rows to the data table
The data gets updated for the first 3 loops (out of say 100) but then there
is no error and data doesn't update.
The command is getting executed without a problem but the
2012 Jan 16
1
dbWriteTable(con, access_log, overwrite = F).....
I am new to R.
My goal is to make a crosstable from a Apache access.log, which I want
to load into PostgreSQL database at first to
learn more abour R and DBI and datatypes. When the I have got the
access.log in the database I will try to make the
crosstable!
Trying to load the Apache access.log into PostgreSQL I get an error.
dbWriteTable(con, access_log, overwrite = F);
returns
Error in
2017 Aug 29
2
DBI::dbWriteTable syntax error apparently from quotes
I have been successfully using RODBC for a long time (years) to connect to
MS SQL Server from R.
This week I wanted to try using odbc but I am seeing some problems which
may be related to how I set up my driver and/or connection.
The dbWriteTable manual page gives as an example command:
dbWriteTable( pDB$con, "mtcars", mtcars[1:5,])
When I try this I get the following error
Error:
2011 Aug 31
2
dbWriteTable error message
I am at loss of what is going on here ...
I am trying to write to a SQLite database:
con <- dbConnect(dbDriver("SQLite"), dbname="pres-docs.rqda")
I have a data frame that is 889 rows by 7 columns. The column number
and types agree with the database table columns and column type.
dbWriteTable(con, "fileAttr", DF.4, row.names=FALSE, overwrite=TRUE)
Then I get