Displaying 20 results from an estimated 800 matches similar to: "Ways to work with R and Postgres"
2010 Jul 21
1
Package RPostgreSQL_0.1-6.tar.gz has been checked and built
Hi Dirk
I think there are problems with pg_config, the configure script of
RPostgreSQL checks for pg_config and got ¡°checking for pg_config...
/usr/bin/pg_config¡±. In Solaris 10u7 X64, three versions of PostgreSQL are
installed, there are in /usr/postgres/8.2(8.2.9) and
/usr/postgres/8.3(8.3.3), the corresponding bin files are in
/usr/postgres/<version>/bin and
2010 Nov 24
4
R encoding question
Hi,
I am using RpgSQL to retrieve data from a PostgreSQL database wich is
with encoding UTF8, and I have some Chinese character in one of the
columns, unfortunately R can't show it correctly.
> df <- dbGetQuery(con, "select * from test")
> df
a b
1 1 ????????\xa2
2 2 ???? EURO\xa1
I see the following option, do I need to change the encoding option to
show
2011 Nov 07
1
RpgSQL row names
Hello,
Using the RpgSQL package, there must be a way to get the row names into the
table automatically. In the example below, I'm trying to get rid of the
cbind line, yet have the row names of the data frame populate a column.
> bentest = matrix(1:4,2,2)
> dimnames(bentest) = list(c('ra','rb'),c('ca','cb'))
> bentest
ca cb
ra 1 3
rb 2 4
>
2011 Nov 08
2
multi-line query
Hello,
I'm using package RpgSQL. Is there a better way to create a multi-line
query/character string? I'm looking for less to type and readability.
This is not very readable for large queries:
s <- 'create table r.BOD("id" int primary key,"name" varchar(12))'
I write a lot of code, so I'm looking to type less than this, but it is
more readable from
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]]
2011 Mar 09
2
No response after click the "show Rules" button on Tab "Associate".
Hi,
I am using Rattle 2.6.4 with R 2.12.2 on win64, is this a bug ?
Following is the content after execute the associate analysis process:
Summary of the Apriori Association Rules:
Number of Rules: 23351
Summary of the Measures of Interestingness:
support confidence lift
Min. :0.1250 Min. :1 Min. :2.667
1st Qu.:0.1250 1st Qu.:1 1st Qu.:2.667
Median :0.1250
2018 Jul 24
2
oddity in transform
The idea is that one wants to write the line of code below
in a general way which works the same
whether you specify ix as one column or multiple columns but the naming entirely
changes when you do this and BOD[, 1] and transform(BOD, X=..., Y=...) or
other hard coding solutions still require writing multiple cases.
ix <- 1:2
transform(BOD, X = BOD[ix] * seq(6))
On Tue, Jul 24, 2018 at
2018 Jul 23
2
oddity in transform
Note the inconsistency in the names in these two examples. X.Time in
the first case and Time.1 in the second case.
> transform(BOD, X = BOD[1:2] * seq(6))
Time demand X.Time X.demand
1 1 8.3 1 8.3
2 2 10.3 4 20.6
3 3 19.0 9 57.0
4 4 16.0 16 64.0
5 5 15.6 25 78.0
6 7 19.8 42 118.8
>
2009 Sep 28
6
SAS user now converting to R - Help with Transpose
I am just starting to code in R and need some help as I am used to doing this
in SAS.
I have a dataset that looks like this:
Chemical Well1 Well2 Well3 Well4
BOD 13.2 14.2 15.5 14.2
O2 7.8 2.6 3.5 2.4
TURB 10.2 14.6 18.5 17.3
and so on with more chemicals....
I would like to transpose my data so that it looks like this:
Chemical WellID Value
BOD Well1 13.2
BOD Well2 14.2
BOD Well3 15.5
BOD
2009 Oct 20
1
RPgSQL installation problem
Hi everybody
I am trying to install RPsSQL and get the following error message:
When I do ./configure form the untarred source directory I get
loading cache ./config.cache
checking for crypt in -lcrypt... no
No crypt function found
When I use the Package installer in R I get
install.packages("/Users/christiaanpauw/tmp/RPgSQL/", , NULL, type =
"source")
Warning in
2003 Feb 11
4
postgres
Is anyone using R with postgres? I'd like to do so, but cannot seem to
find any reasonable explanation of how to do so.
Joshua Gramlich
Chicago, IL
2006 Aug 11
3
An apply and rep question
Hi list,
I'm sure the explanation must be laughably simple to the experts out
there, but I just could figure it out. I have a simple data frame that
looks like,
>head(da.off)
DDate OffP
1 2005-01-01 41.23
2 2005-01-02 44.86
3 2005-01-03 44.86
4 2005-01-04 43.01
5 2005-01-05 45.47
6 2005-01-06 48.62
where the first column DDate currently is character, and OffP is
numeric.
I want
2007 Sep 07
3
Delete query in sqldf?
Dear All,
Is sqldf equipped with delete queries? I have tried delete queries but
with no success.
Thanks in advance,
Paul
2009 Aug 12
2
Symbolic references - passing variable names into functions
Hello All,
I am trying to write a function which would operate on columns of a
dataframe specified in parameters passed to that function.
f = function(dataf, col1 = "column1", col2 = "column2") {
dataf$col1 = dataf$col2 # just as an example
}
The above, of course, does not work as intended. In some languages one
can force evaluation of a variable, and then
2006 Oct 25
1
sourcing dput output
Is this not supposed to work?
> dput(BOD, file = "/BOD.R")
> source("/BOD.R")
Error in attributes(.Data) <- c(attributes(.Data), attrib) :
row names must be 'character' or 'integer', not 'double'
> dput(iris, file = "/iris.R")
> source("/iris.R")
Error in attributes(.Data) <- c(attributes(.Data), attrib) :
2003 Feb 11
1
RPgSQL W2K
Hi,
i found tis message in the archive and have
got the same problems ?
John, perhaps you have found now a way
install RPgSQL for windows2000, or anybody other ?
many thanks for advance
christian
[SNIP]
I wonder whether anyone has succeeded in building either the RPgSQL or the
Rdbi.PGSQL and Rdbi packages for Windows. If so, would you be willing to
share either the binary package(s) or
2007 Nov 24
5
how to calculate the return?
Hi, R-users,
data is a matrix like this
AMR BS GE HR MO UK SP500
1974 -0.3505 -0.1154 -0.4246 -0.2107 -0.0758 0.2331 -0.2647
1975 0.7083 0.2472 0.3719 0.2227 0.0213 0.3569 0.3720
1976 0.7329 0.3665 0.2550 0.5815 0.1276 0.0781 0.2384
1977 -0.2034 -0.4271 -0.0490 -0.0938 0.0712 -0.2721 -0.0718
1978 0.1663 -0.0452 -0.0573 0.2751 0.1372 -0.1346
2003 Apr 16
1
unable to load package RPgSQL
Hi all,
I'm trying to install an add-on package for R called RPgSQL. Its role
will be to link R with a PostgreSql database. I work on a Linux machine.
However, I'm quite a newbie as far as R's concerned, and I don't manage
to install the package properly.
That's the steps I followed :
* downloading the package (archive)
* R CMD INSTALL /path/to/package.tar.gz (as
2009 Aug 25
1
Help with nls and error messages singular gradient
Hi All,
I'm trying to run nls on the data from the study by Marske (Biochemical
Oxygen Demand Interpretation Using Sum of Squares Surface. M.S. thesis,
University of Wisconsin, Madison, 1967) and was reported in Bates and Watts
(1988).
Data is as follows, (stored as mydata)
time bod
1 1 0.47
2 2 0.74
3 3 1.17
4 4 1.42
5 5 1.60
6 7 1.84
7 9 2.19
8 11 2.17
I then
2011 Jun 28
2
connecting R and PostgreSQL
Dear R-helpers,
I'm an absolute beginner using both R and PostgreSQL, but now I have to work with both programs. I need to connect R and my Postgres-database, but every attempt so far has failed (I tried using the RpgSQL package as well as RdbiPgSQL, the first, following this manual (http://code.google.com/p/rpostgresql/) didn't find any drivers for the database (step no. 1) whereas the