similar to: sqldf not joining all the fields

Hi, I have two dataframes that have some common columns. I would like to join them by the common columns prochi and prescribed_date as there are duplicate prochis but they will be made unique by date. I tried doing an inner join but that just duplicated the columns whereas I would like the information from the test_sql_tsf to fill the NAs in the test_sql_psd common columns. require(sqldf)

I'm trying to export a graph (any form is good). I'm trying to export one that uses plot() then lines(). however, it seems that the jpeg format and the pdf format only takes the first line plot, and doesn't even consider the additional plots. My code is the following: output_file<-paste(filez,".pdf",sep="") pdf(output_file) plot((x_data) ~ (y_data), main =

Dear R users, I have the following data frame: PROCHI date_admission 2 CAO0000713 1999-12-11 4 CAO0000713 1999-10-25 21 CAO0001743 1989-05-04 25 CAO0001743 1996-09-12 26 CAO0001743 1989-05-17 27 CAO0001743 1987-09-17 28 CAO0001743 1987-09-19 29 CAO0001743 1988-01-27 36 CAO0001747 2004-03-21 38 CAO0001747 2004-03-22 39

This maybe a basic question, but I have spent several hours researching and I could not get an answer, so please bear with me. The problem is with time series in the package tseries. As the example below shows, the time series can get misaligned, so that bad results are obtained when doing regressions. I found a way to do this correctly, but I find it rather cumbersome. My question is: is there a

Hello All: I have been working with <a href="http://ruby-pdf.rubyforge.org/pdf-writer/index.html">Austin Ziegler''s PDF::Writer</a> as a means to produce PDF documents from my Rails app. I am stumped on how to iterate through a collection of items and output them in a table format. The way I have tried it so far only returns the last item in the collection -

Hi folks, This is post no. 2, with technical information of how I set up the Linux PCs, and additional information about setting up the server shares. It will give the basic outlines to those trying to setup something similar, using another Linux distribution. I will not go into any detail about setting up the OS, and similar tasks, as it is assumed that the interested reader has got the

Dear All, I want to change file names. I have file0.1_data.RData (I have several files whose names are file0.x_data.Rdata) I want to rename it to file1_data.RData How can I do it? Thank you for saving my time! [[alternative HTML version deleted]]

If x is a data.frame containing a column of mode character, this column is changed to a factor after applying fix(x). Example: R> x_data.frame(a=1:3,b=letters[1:3],c=c("hansi","pepi","karli")) R> x$c_as.character(x$c) R> is.character(x$c) [1] TRUE R> is.factor(x$c) [1] FALSE R> fix(x) ## I change "karli" to "sepp" R> x$c [1]

I have an Everex laptop (ick, but it was super cheap) that has an Atheros wireless NIC in it, but I can't seem to get it to connect to my wireless in-home LAN. Here's what I've done so far (that isn't working) - any suggestions? [root at marktop mark]# lspci | grep Ether 00:12.0 Ethernet controller: VIA Technologies, Inc. VT6102 [Rhine-II] (rev 7c) 05:01.0 Ethernet controller:

I recently had to uninstall PokerStars and WINE will not allow me to preform the reinstallation. I have also tried installing other programs with no success. I contacted PokerStars support but they said it'll be at least 2 days before their Linux guy was in. What they wanted was my WINE log files by going in through the terminal. Thats all they could tell me until 2 days from now. I have no

I''ve got a field in a database that contains a string of ids. I want to be able to remove an item from that list and save the list again. The only way I saw how to do this was to convert it to an array and back to a string again. The variable names are for an example. This code works, but I don''t think that it''s efficient. It''s all in my controller.

I tried a date by date forecast of a time series and it seems to be too wild. How can I aggregate the date into weeks or months as required? Thanks. The input looks like ID datadate("YYYY-MM-DD") value_for_day -- ----- ------- -- ------ -------- and I want to be able to change it to ID dataweek value_for_week or

On our CentOS 7 servers I see there is a new kernel available when doing yum update: kernel 3.10.0-1062.12.1.el7 kernel-devel 3.10.0-1062.12.1.el7 However I am not able to find any announcement at redhat.com for this kernel. The only announcement I find is this from CentOS: https://www.mail-archive.com/centos-announce at centos.org/msg11573.html However that CentOS announcement links to

Hello all, I'm using samba 2.2.3a-12 from the debian woody distribution (kernel 2.4.18, ppc), and I have the following problem: The modification time returned by "ls" is wrong (tipically 1/1/1970), except when I directly access (1) one single file, (2) from outside of the mounting point. (A bit confusing, but I give an example below:) My mounting point is

On Thu, 28 Nov 2024 17:41:47 +0100 Peter Milesson via samba <samba at lists.samba.org> wrote: > Hi folks, > > This is post no. 2, with technical information of how I set up the > Linux PCs, and additional information about setting up the server > shares. It will give the basic outlines to those trying to setup > something similar, using another Linux distribution. I will

Hello, Just wanting to introduce the CentOS community to the OpenICDL project in the hope that we may be able to collaborate. OpenICDL is an open source project that aims to develop and maintain a Free/Open Source version of the training materials used to ready students for the International Computer Driving License certification. We are presently developing release 2.0 of the OpenICDL

Hi! I get high cpu usage on my laptop (yes im running Centos on my laptop) after my last update. At the beginning i though it was libvrtd but after stopping it gnome monitor keep showing high cpu usage although i couldnt find the app that was responsible for it with the top command. I searched my log files and I saw alot of iwlwifi message. I had to turn off wifi in order to stop high cpu

http://bugzilla.mindrot.org/show_bug.cgi?id=369 ------- Additional Comments From devel at pitux.com 2002-09-10 19:19 ------- I confirm that this bug does exist. It's especially annoying since we use here a lot of scripts which check for the return values of scp to indicate success or failure. In fact it does the good thing on nonexistent files/dirs/etc, but fails in case of auth

Hi R-users,   I would like to transform my data using gamma, my data are ahll, bhall and dp1 as shown below:   > ahall      ah1  ah2  ah3  ah4  ah5  ah6  ah7  ah8  ah9 ah10 ah11 ah12 [1,] 0.9 1.01 1.24 1.85 1.85 2.45 3.67 3.02 3.06 2.33 1.86 0.96   > bhall        bh1   bh2   bh3   bh4  bh5   bh6   bh7   bh8   bh9  bh10  bh11  bh12 [1,] 48.39 44.26 37.34 29.93 33.5 26.54 20.26 25.73 20.14

Hi I have question where I run web form. Now on this form I have one field with link select user. This link will pop up new window with javascript and on this window I have form with items which end user can select. Once selection is done end user press button Select User. Now I need to close that javascipt window and send back value of that selection back to form and to the field which has