similar to: SQL like manipulations on data frames

Dear All, I am having a bit of problem using the DBI and RMySQL package. I have already installed DBI but now I want to connect to MySQL. So how do I do it. The CRAN package repository does not have RMySQL windows binary to install from? Regards, Indrajit Sen Gupta Business Analyst Mu Sigma Business Solutions Pvt Ltd #21/1-1, Nawab Towers Cunningham Road Bangalore 560 052, India Tel: +91 80

Why am I getting the error "Error: cannot allocate vector of size 512000 Kb" on a machine with 6 GB of RAM? I'm playing with some large data sets within R and doing some simple statistics. The data sets have 10^6 and 10^7 rows of numbers. R reads in and performs summary() on the 10^6 set just fine. However, on the 10^7 set, R halts with the error. My hunch is that

Is there a way to stream data into R so that it can be used in a command pipe? Most Unix commands read data via standard input and read the script from the command line. For example: $ seq 1 10 | sed -e 's/^/foo /' $ seq 1 10 | awk '{print "foo " $1}' $ seq 1 10 | perl -lane 'print "foo $F[0]"' In contrast, R seems to read the script

Is there a way to do text plots in R? I'd like to do some simple XY plots in R with the output in text (ascii). For example, with gnuplot I can do the following: echo 'set terminal dumb ; plot sin(x)' | gnuplot To generate a simple sin wave. Since I connect to a remote Linux machine using SSH, being able to generate a rough idea of what a plot will look like in text would be

Hello all, How can I increase/decrease the line length for screen wrapping? Currently when I run the following the output appears to wrap at just under 80 columns: > c(1:100) [1] 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 [19] 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 [37] 37 38 39 40 41 42 43 44 45 46 47 48 49

I am new to R ( and windows XP ) and am in the process of setting it up I put an options (repos=http://.fhcrc.org") file in my .Rprofile file and it works but that's all I put in and i don'tknow what to put in my .First function. I understand that .Rprofile is used for more general options and .First for options specific to that working directory. would someone mind to send me an

Does R have command or object name completion? R has several functions of modern shells built into it e.g. history mechanism, command-line editing, emacs key bindings. However, it doesn't seem to have command or object name completion. For example, in bash I can begin typing a command and then press the tab key to have the shell fill in the rest of the command (works for environment

Hello, Last week I have detected with Zabbix that a member of my Samba domain had been downloading at a rate of around 8 Mbps for two days and a half. When asking the person to whom belonged the machine, he didn't know he was downloading anything but he said he had observed his machine had slowed down since then. I took a tcpdump of the traffic before terminating his session on Windows

Hi, I am very new to R and I have written the following block of code to generate a gamma distribution for variable x (which is an array) and a function "y" whose array values depend on the individual array values of "x". The code is as follows: n=1000 x=rgamma(n,1.5,2) y=vector("numeric",n) for (i in 1:n){ y[i]=(2937/50000*exp(-1/1000*x[i])/x[i]) } now I want to

Hi, all. I'm trying to automate some regression operations in R leaving the possibility to modify the predictors in the regression. For example, I have saved in a list the results and then exported as a txt file, in which we can modify the predictors, putting for example lm(y~x^2) instead of having lm(y~x) as in the original model. Now, I need to import in R the txt file as a list to

Dear R folks: I wonder anyone has a elegent way of doing what I need to do. I have a data frame called with four columns: V1, V2, A1 and A2: V1 V2 A1 A2 A B 1.2 2.0 A D 1.2 4.0 A C 2.4 2.2 What I need to do is to convert it into the following data frame with a new column x, where x is just the stacked up of A1 and A2 placed with respective V1 and V2 in the first two

I have installed RedHat ES 3.0 It came with samba 3.0.0-14.3E.i386 I have no SWAT. Which one can I use? I downloaded samba-swat-3.0.0-1.test.rh90.i386.rpm and an rpm -i said it needs: samba 3.0.0-1.test.rh90 I downloaded samba-swat-2.2.7a-8.9.0.i386.rpm and an rpm -i said it needs: samba 2.2.7a Which SWAT do I need and where can I download it? thanks, in advance. Dean

Versions -------- (Libvirt locally built from a recent git commit -ec7b922): $ rpm -q libvirt-daemon-kvm qemu-system-x86 libvirt-daemon-kvm-1.2.6-1.fc20.x86_64 qemu-system-x86-2.0.0-1.fc21.x86_64 Test ---- [All images are qcow2 files.] We have this simple chain: base <- snap1 Let's quickly examine the contents of 'base' and 'snap1' images:

On 20 Jan 2016, at 18:23, Hans Wennborg <hans at chromium.org> wrote: > > On Wed, Jan 20, 2016 at 5:25 AM, Dimitry Andric <dimitry at andric.com> wrote: >> Unfortunately I'm having lots of trouble with rc1 at this point: >> * libcxxabi can't build, because it requires unwind.h, which we do not yet have on FreeBSD 10.x (Ed Maste is working on it for 11.x, but

Unfortunately I'm having lots of trouble with rc1 at this point: * libcxxabi can't build, because it requires unwind.h, which we do not yet have on FreeBSD 10.x (Ed Maste is working on it for 11.x, but that is not ready for general consumption). * The test-release.sh script has no option to disable only libcxxabi, you can only disable libcxx, libcxxabi and libunwind together (maybe this

Hello everyone, 9.0.0-rc2 was tagged yesterday from the release_90 branch at r368683. In the Git monorepo it's available as the llvmorg-9.0.0-rc2 tag. Source code and docs are available at https://prereleases.llvm.org/9.0.0/#rc2 Binaries will be added as they become available. The tag went in roughly one week behind schedule (see "Upcoming Releases" at https://llvm.org), but

Hi everyone, 9.0.0-rc1 was just tagged from the release_90 branch at r367217 (tagged as llvmorg-9.0.0-rc1 in the Git monorepo). Source code and docs are available at https://prereleases.llvm.org/9.0.0/#rc1 Binaries will be added as they become available. Please file bug reports for any issues you find as blockers of https://llvm.org/PR42474 Release testers: please start your engines, run the

Hello everyone, 9.0.0-rc5 was just tagged from the release_90 branch at r371837. In the Git monorepo, it's tagged as llvmorg-9.0.0-rc5. Source code and docs are available at https://prereleases.llvm.org/9.0.0/#rc5 Binaries will be added as they become available. There is only a single change from rc4 to rc5. Once more, the hope is that this will be the last release candidate and that we can

Hi, I've just tagged LLVM 9.0.1-rc3. Testers can begin testing and uploading binaries. This will be the last release candidate unless there is a major problem. I'm planning to tag the final release on Dec 19. -Tom

In my syslog I get many of these types of errors: ypserv [4818]: refused connect from 127.0.0.1:57124 to procedure ypproc_match [domain.com,passwd.adjunct.byname;-1) Any idea what this error is? TIA