Displaying 20 results from an estimated 300 matches similar to: "SQL query with Multicore option on R -linux"
2011 Jul 20
4
R on Multicore for Linux
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
2011 Jul 25
2
Binding multiple data frames into single data frame
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
2011 Jul 14
5
Splitting one column value into multiple rows
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
2012 Aug 02
1
Joining R Local Dataset with Table from Database
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
2016 Apr 15
1
help on moving data from local to HDFS using RODBC in R
Hi,
I have requirement to move the data from Linux local path( ex
/home/user/sample.txt) to hadoop HDFS using RODBC in R
I knew that we can move the data using rhive comamnds like *rhive.put*
and *rhive.get
*but looking for similar commands using RODBC as well.
I would appreciate for your inputs.
Regards,
Divakar
Phoenix, USA
[[alternative HTML version deleted]]
2012 Nov 07
6
how to generate a set of random numbers that sum to 1 with uniform distribution of elements
Hi,
I am looking for a way to generate a matrix of random numbers in a way that
each row of the matrix would sum to 1 and that the numbers in the columns of
the matrix would have a uniform distribution. So far I have found several
ways to create random numbers that would sum to 1, but then the distribution
of the individual elements is more or less skewed - there are much more
small numbers than
2012 Oct 23
0
Rserve-PHP client warning
i connected Rserver successfully. can do some functions like
rnorm(),print(),etc...
i am connecting R with Hive-hadoop
i have installed library "RHive" which will take care of connection
but when i am connecting it throws warning..like
"Warning: type 7 is currently not implemented in the PHP client."
code:-->
2011 Aug 31
1
[PATCH] hivex: Add byte runs for nodes and values
This patch adds byte run reporters for node and value metadata in the
hivexml program. Each byte run represents the offset and length of a
data structure within the hive, one per node, and one or two per value
depending on the length of the value data. In order to add this
metadata reporting, the following changes were put in place:
* Split value_key function into value_key and value_key_len.
*
2012 Mar 05
0
Having a problem with R installation as a shared library
Hello All,
I suspect I am having a problem with my R installation, something that has
to do with "--enable-R-shlib".
Can someone explain if this is something that I can fix using apt-get?
More specifically:
I am having trouble getting installing the RHive package.
I Installed R from scratch, following the instructions in (for example):
http://cran.ru.ac.za/bin/linux/ubuntu/
2014 Aug 04
6
[hivex] Segfault for an integer value to node_set_value
Hi,
When an integer argument is passed as value, node_set_value
segfaults. Reproducer is at the end of this message
The backtrace points at hivex-py.c, function get_value. While obj
is non-NULL, `bytes = PyUnicode_AsUTF8String (obj);` returns NULL.
Kind regards,
Peter
https://lekensteyn.nl
#!/usr/bin/env python3
import hivex, sys
h = hivex.Hivex(sys.argv[1])
print(h)
val = {
2014 Aug 16
7
[hivex] [PATCH 0/6] Python fixes for node_set_value
Hi,
This patch series is based on a prior patch[1], splitting off changes as
requested and incorporating feedback from Richard Jones. It introduces type
validation to avoid segmentation faults (instead, it reports an exception) and
fixes handling of the bytes type in Python 3.
Major changes since that series:
- Drop newly introduced support for integer types for DWORD/QWORDS
- Reject Unicode
2009 May 05
1
Working with R from Remote desktop
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
2009 Oct 27
1
WAR file installation
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:
2005 Nov 03
1
System error 53 has occurred. The network path was not found.
Hi gurus,
Am using Win XP professional and SUSE 9.3 professional and samba version is
3.0.13-1.1
am able to access my XP machine from samba server using smbclient
\\<xp<file://\\<xp>machine name>\<share drive>
but when i give
net view \\<samba <file://\\<samba> server>
it gives following error
"System error 53 has occurred. The network path was not
2012 Sep 20
2
VarBrul in R
Several years ago there were R implementations of a socio-linguistics
analysis method called Variable Rule Analysis namely rbrul and r-varb. Both
neither of the sites listed (in the method's WikiPedia page
http://en.wikipedia.org/wiki/Variable_rules_analysis ) appear to be online
any more (one was at UPenn and the other at Indiana). Does anyone know a)
whether the code for either or both of
2023 Mar 09
1
web address for R-project
? Thu, 9 Mar 2023 14:43:49 +0100
G?ran Brostr?m <gb at ehar.se> ?????:
> Is it someone's mirror (authorized) of R-project?
It's not currently in the official list of mirrors [*], but anyone can
create a CRAN mirror for their own needs as long as they don't overload
the CRAN master site: https://cran.r-project.org/mirror-howto.html
NexR call themselves a "total data
2023 Mar 09
1
web address for R-project
I got the link cran.nexr.com from a person who claimed that it is the
home of R-project, and indeed, it looks right.
But it doesn't feel right, so I wonder what is going on. Is it someone's
mirror (authorized) of R-project?
Thanks, G?ran
2012 Sep 17
3
I want to send the vector a into the Object A.......
a=c(1,2,3)
b=c(23, 24, 25)
x=c("a", "b")
#if (length(x[1]) == 0) {cat("x[1] is having 3 elements")}
Suppose I want to send the vector a into the Object A,
um getting only "a" as the ouput for Object A but not getting required output as the vector with the elements 1, 2, 3 with the following code
A<- x[1]
How to code it?
Can anyone help?
Notice: The
2018 May 02
0
Merging dataframes
Hi,
I'll coded your example into R code:
Table_A <- c('abc at gmail.com', 'John Chan', '0909')
Table_A <- rbind(Table_A, c('bcd at yahoo.com', 'Tim Ma', '89089'))
colnames(Table_A) <- c('Email', 'Name', 'Phone')
Table_A
Table_B <- c('abc at gmail.com', 'John Chan', 'M',
2018 May 02
2
Merging dataframes
Thanks - Peter, Eivind, Rui
Sorry, I perhaps could not explain it properly in the first go.
Trying to simplify it here with an example - Say I have two dataframes as
below that are NOT equally-sized data frames (i.e., number of columns are
different in each table):
Table_A:
Email Name Phone
abc at gmail.com John Chan 0909
bcd at yahoo.com Tim Ma