search for: madana_babu

Hi all, I have R installed on a box, which is running on a machine with 16 core and Redhat - Linux. I am handling huge (size of dataset will be 5 GB) dataset. Lets assume that my data is in the form of structured (multiple) logs. I access the data by using all.files(). Since by default basic version of R utilizes single core, the processing of my analysis code is taking too much time. I got to

Hi All, I want to join a table (Dataset) that is created in R with a table that is in oracle database. Can some one help me in accomplishing this task in R? Example Code: library(RODBC) DB_CONNECT <- odbcConnect("DSN_NAME") TABLE_JOIN <- sqlQuery(DB_CONNECT, "SELECT * FROM DB_TABLE WHERE COL_1 NOT IN (SELECT COL_1 FROM DATA_SET_R) ") Regards, Madana -- View this

Hi all, I have the following sql query that I am executing on a machine with single core. I want to know how can I execute the same sqery on a maching that is running with 4 cores. Please provide me the code. NEW_TABLE <- rhive.query("SELECT A, B, COUNT(C) FROM TABLE_A WHERE A>='01-01-2012'") Also let me know how can I leverage only 2 / 3 cores of the machine.

Hi all, I have multiple data frames created with equal number of columns in each data frame by using mclapply() on multicore processor. The data frames are like DF[[1]], DF[[2]], ... DF[[150]]. Now i want to bind (Similar like rbind()) all these data frames and create one single data frame called DF so that i can have the complete data for further analysis. Can someone help me in performing this

Hi i have the data in the following format: rent,100,1,common,674 pipe,200,0,usual,864 car,300,1,uncommon,392:jump,700,0,common,664 car,200,1,uncommon,864:snap,900,1,usual,746 stint,600,1,uncommon,257 pull,800,0,usual,594 where as i want the above 6 lines data into 8 lines as below (Spliting row 3 & 4 at : and sending to a new row): rent,100,1,common,674 pipe,200,0,usual,864

...etting errors while running the below codes. Can anyone identify and let me know where did i go wrong??? Thanks in anticipation :) library(RODBC) myconn <- odbcConnect("RDATABASE") myconn RODB Connection 6 Details: case=nochange DSN=RDATABASE Description=Database for R UID=Madana_Babu WSID=IBLPN1B049040 Trusted_Connection=Yes NEWDATASQL1 <- sqlFetch(myconne, CampaignDataLarge) Error in odbcTableExists(channel, sqtable) : object 'CampaignDataLarge' not found NEWDATASQL2 <- sqlFetch(myconne, CampaignDataLarge, colnames = FALSE, rownames = TRUE) Error in odbc...

Hi Friends, Kindly let me know whether is it possible to install R project in a Server (Remote) desktop, which can be accessed by many users by logging in with their credentials... Another concern is if i want to work with huge dataset (millions of records) what should be the system configuration? (currently i am getting an error : Cannot allocate vector of size 16.7 Mb) Regards, Madana -- View

Hi Friends, I am working on R-2.9.0 and i want to connect oracle through R, but i could not find ROracle (zip file for windows) on CRAN Packages. Can anyone suggest me how to connect Oracle from R in windows platform? I would be grateful if u can provide me code aswell. Thanks & Regards, Madan -- View this message in context:

Hi Friends, Currently i am using R-2.9.1. I am new to R and i am in learning stage. Can any one tell me whether R allows WAR file installation? Other concerns i have are: 1. Does R allows WAR file installation? 2. Does R has a web server or application server concept? 3. Can we create login credentials in R? Kindly clarify these things... Regards, Madana -- View this message in context: