similar to: inner join sqldf

Dear R users, I have two data frames that were read from text files as follows: x_data <- read.table("x.txt", header = TRUE, sep = "|", quote = "\"'", dec = ".",as.is = TRUE,na.strings = "NA",colClasses = NA, nrows = 3864284, skip = 0, check.names = TRUE,fill=TRUE, strip.white = TRUE,

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

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 -

Dear R help, I have the following data frame: structure(list(prochi = c("ind_1", "ind_1", "ind_1", "ind_1", "ind_1", "ind_1", "ind_1", "ind_1", "ind_1", "ind_1"), date_1st_event = structure(c(14784, 14784, 14784, 14784, 14784, 14784, 14784, 14784, 14784, 14784 ), class = "Date"),

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

Hi Everyone, I have the following problem: data <- structure(list(prochi = c("IND1", "IND1", "IND1", "IND2", "IND2", "IND2", "IND2", "IND3", "IND4", "IND5"), date_admission = structure(c(6468, 6470, 7063, 9981, 9983, 14186, 14372, 5129, 9767, 11168), class = "Date")), .Names =

Hi, I have a problem with function match. I might not be using it properly? I have two character vectors that contain a unique identifier: gtype_prochi <- ("CAO1524452" "CAO0966182" "CAO9209719" "CAO4436178" "CAO3761898" "CAO3529266" "CAO2427148" "CAO8829776" "CAO2517174" "CAO5371418"

Hi everyone, I would like to subset a data.frame using partial values. For example I have the following data.frame: PROCHI Main_condition 1234 411 1235 4110 1236 4111 1237 I20 1238 I201 1239 I202 Now let's say that I use the Subset function. Ordinarily I would use it as follows Subset(x, Main_condition=="411"|Main_condition=="4110" etc to get

Hi All, I have a character data.frame that contains character columns and date columns. I've manage to convert some of my character columns to a date format using as.Date(x, format="%m/%d/%y"). An example of one of my dates is PROCHI DtDeath icdcucd date_admission1 date_admission_2 CAO0004563 <NA> <NA> 2005-09-01 <NA> CAO0073505