search for: guxiaobo1982

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

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

Hi, Since we can?t access Google Groups here in China, so please forgive me if anyone has asked this question before. Sincerely Xiaobo Gu

Hi, I post this message to the general r-help list hoping anyone within a wider range have suggestions: There are three ways to integration R and postgres, especially on 64bit Microsoft windows Platform, 1. via RODBC package, which has 32 bit and 64 bit version for windows 2. via RPostgres interface, which only has 32bit version currently 3. via plr for Greenplum, which only supports a

Hi, I am trying to write a function do cast columns of data frame as factor in a loop, the source is : as.factor.loop <- function(df, cols){ if (!is.null(df) && !is.null(cols) && length(cols) > 0) { for(col in cols) { df[[col]] <- as.factor(df[[col]]) } } } source('D:/ambertuil.r') x <- 1:5 y <- 2:6 df <- data.frame(x=x, y=y)

...raries in /usr/bin is 8.1.11 and it seems a 32bit one, and I can¡¯t find the 64bit version bins for 8.1.11. I'll try uninstall 8.1.11 and install 8.2.9, and my question is how to let RPostgreSQL configure script find the 64bit pg_config. Xiaobo Gu On Tue, Jul 20, 2010 at 10:32 PM, ¹ËС²¨ <guxiaobo1982@gmail.com> wrote: > Hi Dirk, > > I think this discussion should help : > http://stackoverflow.com/questions/1836333/how-can-i-compile-64-bit-postgres-bindings-for-perl-on-solaris, > are there environment variables I can set to point to 64bit libraries, or I > can set the 64bit...

...; > Today's Topics: > > 1. RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64 crash > (Xiaobo Gu) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sat, 15 Jan 2011 10:34:55 +0800 > From: Xiaobo Gu <guxiaobo1982@gmail.com> > To: r-devel@r-project.org > Subject: [Rd] RPostgreSQL 0.1.7 for Windows 64 causes R.2.12.1 Win64 > crash > Message-ID: > <AANLkTinvoub-z_Le1GVPYswnqTsW1P6MZzLZsztois9K@mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi,...

Especially for large ff objects. Xiaobo.Gu [[alternative HTML version deleted]]

Hi Does anybody know how to create ff objects with data reading from stream objects, such as data reading from PostgreSQL database through RPostgreSQL. For this purpose although we can save the data to a csv file through external tools and then read it through csv readers, but it requires one more data read and write operation, which is of high I/O cost for large datasets. Xiaobo.Gu

Hi, I see the following is the credit scoreing in R guide : m2<-glm(formula = good_bad ~ checking + duration + history+ purpose +amount + savings + employed + installp + marital + coapp +age + other + depends + telephon + foreign +checking:amount What does checking:amount mean? Regards, Xiaobo Gu

[This email is either empty or too large to be displayed at this time]

Hi, The Transparency Layer feature of Oracle R Enterprise overcomes the RAM limitation of R, and can take advantage of multiple core processing of the database server by translating R expression into SQL, what about building a open source version of the transparency layer for relational databases? Xiaobo Gu

Hi, The read.csv.ffdf function in package ff will create the ff object physical file in the default directories, I am trying to let the files created in the paths users specify, I think the point is to make use of the asffdf_args parameter, I have a test CSV file named D:\rtemp\fftest.csv, the content of the file is as following: col1,col2,col3 1,"amber",2.4 2,"linda",4.5

Hi, After reading the slices from ff project site I know ff can be used with snowfall to achieve parallel processing, I want to know is it the only way, can we combine package foreach and ff, especially in a SMP server, with doMC and multicore behind foreach. Xiaobo.Gu [[alternative HTML version deleted]]

Hi, Can rattle utilize parallel processing mechanisms such as foreach? Can rattle analyze ff objects ? Xiaobo.Gu [[alternative HTML version deleted]]

Hi, Can the plenty of analytical functions provided by base R and contributed packages be called with ff objects as parameters directly, or do we have to write special version of the functions for ff objects? If it is the latter case, is there a list of functions which support ff objects already. Xiaobo.Gu [[alternative HTML version deleted]]

Hi Team, Can you please tell me the rules of assignment in R, by value or by reference. >From my about 3 months of experience of part time job of R, it seems most times it is by value, especially in function parameter and return values assignment; and it is by reference when referencing container sub-objects of container objects, such as elements of List objects and row/column

Hi, I am running the examples in page 70 of the ff package document, but it failed with the following error > cat("let's create some ff objects\n") let's create some ff objects > n <- 8e3 > a <- ff(sample(n, n, TRUE), vmode="integer", length=n, filename="d:/tmp/a.ff") > b <- ff(sample(255, n, TRUE), vmode="ubyte", length=n,

Hi, x1 <- c(as.Date("20110101","%Y%m%d"),as.Date("2012-01-01","%Y-%m-%d")); x2 <- c("1","2"); ddf <- data.frame(x=x1,y=x2); ddf[["y"]] <- as.factor(ddf[["y"]]) write.arff(ddf, file="D:/ddf.arff") Content of ddf.arff is @relation ddf @attribute x numeric @attribute y

Hi, I saved the following as a UTF-8 encoded file named amberutil.r as.factor.loop <- function(df, cols){ if (!is.null(df) && !is.null(cols) && length(cols) > 0) { for(col in cols) { df[[col]] <- as.factor(df[[col]]) } } df } And got this warning message, > source('D:/ambertuil.r') Warning message: In readLines(file) : incomplete final line