[R] Cleaning date columns

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 = c("prochi", "da

[R] Rserve: failed to find config file

Dear R users, I've installed Rserve for R version 2.11.0 on x64 Windows 7. I've added the Rserve_d and Rserve files to the /bin/ folder where the R.exe is installed in the program files. I have also created an Rserv.cfg file that contains the following text: remote enable auth disable plai

Re: [R] Finding the two most recent dates

Dear all, Thanks very much for the replies and for the help. This whole data set consists of about 7000 individuals who have had multiple blood pressure measures taken over time so I just used one individual as an example. I'm sorry if it looked like homework...it isn't. Jim your solution wo

[R] Finding the two most recent dates

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"), bp_date = st

[R] impute2mach GenABEL conversion problem

Hi, I've been trying to use the impute2mach function in the GenABEL library. I unfortunately cannot make a working example as when I scale down the files I no longer get an error message. The error message that I get on the full file is: Error in checkSlotAssignment(object, name, value) :

Re: [R] How to take the average of multiple rows

The aggregate function is great. THanks for this post. -- View this message in context: http://n4.nabble.com/How-to-take-the-average-of-multiple-rows-tp848880p1754315.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.o

Re: [R] inner join sqldf

Dear Gabor, require(sqldf) file(description="http://n4.nabble.com/file/n1593282/test_sql_psd.txt";, open="") file(description="http://n4.nabble.com/file/n1593282/test_sql_tsf.txt";, open="") test_sql_psd <- read.table(file="http://n4.nabble.com/file/n1593282/test_sql_psd.txt";, header=TRUE, se

[R] inner join sqldf

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 inf

Re: [R] sqldf not joining all the fields

Sorry! It is the end of the day for me. So dput(x) structure(list(prochi = c("CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713"), prescribed_date = c("22/06/2001", "28/04/2000", "10/04/2000", "03/07/200

Re: [R] sqldf not joining all the fields

The y_data file has over 9000 rows in it so I thought it would be more practical to give you the file to download -- View this message in context: http://n4.nabble.com/sqldf-not-joining-all-the-fields-tp1590786p1590833.html Sent from the R help mailing list archive at Nabble.com. __

Re: [R] sqldf not joining all the fields

y_data <- read.table("feb_267_presc_items_tsf.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, blank.lines.skip = TRU

Re: [R] sqldf not joining all the fields

dput(x_data) structure(list(prochi = c("CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713", "CAO713"), prescribed_date = c("22/06/2001", "28/04/2000", "10/04/2000", "03/07/2000", "09/01/2001", "16/10/2001", "16/08/20

Re: [R] sqldf not joining all the fields

http://n4.nabble.com/file/n1590804/feb09_267_presc_items_tsf.txt feb09_267_presc_items_tsf.txt is the total file for y so if I use the command line with the total data for y then I get the output specified in z Thanks, Natalie -- View this message in context: http://n4.nabble.com/sqldf-not-jo

[R] sqldf not joining all the fields

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

Re: [R] ordering columns in a data frame

Thanks David. Leaving off the tilde was the problem. -- View this message in context: http://n4.nabble.com/ordering-columns-in-a-data-frame-tp1587294p1587491.html Sent from the R help mailing list archive at Nabble.com. __ R-help@r-project.org maili

[R] ordering columns in a data frame

Dear R users, I have the following data frame: PROCHIdate_admission 2 CAO713 1999-12-11 4 CAO713 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 2

[R] Date conversion problem

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 PROCHIDtDeath icdcucd date_admission1 date_admission_2 CAO00

Re: [R] Subset using partial values

Thanks very much David and Henrique for your help. It has made my life much simpler. -- View this message in context: http://n4.nabble.com/Subset-using-partial-values-tp1576614p1577792.html Sent from the R help mailing list archive at Nabble.com. __

Re: [R] Subset using partial values

Thanks again for the help but what I am having trouble with is that I get: 1012 CAO0103166 01/04/1999 I200 1016 CAO0103166 03/05/2000 I200 1024 CAO0103166 20/06/1997 I209 1025 CAO0103166 25/02/1999 I209 1027 CAO0103166 27/08/1999

Re: [R] Subset using partial values

Hi, That was a good suggestion but I should have been more specific, PROCHIDate_admission main_condition CAO3121534 15/08/2006 I501 28394 CAO3121534 18/04/1999 I251 28395 CAO3121534 18/10/1993 4109 28396 CAO3121534 1

[R] Subset using partial values

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 1238I201 1239I202 Now let's say that I use the Subset function. Ordinarily I would use it a

Re: [R] Matching Problem

Dear Dennis, Thanks the a[a %n% b] function worked well for me. THanks, for the help, Natalie -- View this message in context: http://n4.nabble.com/Matching-Problem-tp1565841p1565910.html Sent from the R help mailing list archive at Nabble.com. __ R

Re: [R] table data as input to the function

Hi, You need to put your table into a data frame by using read.table. You can then do statistical analyses on the data frame. Natalie -- View this message in context: http://n4.nabble.com/table-data-as-input-to-the-function-tp1565827p1565842.html Sent from the R help mailing list archive at N

[R] Matching Problem

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" "CAO1535

Re: [R] R on 64-Bit…

I'm using R for x64bit on my Windows machine and I haven't had any problems. I've installed a number of packages for data analysis and they all seem to work. -- View this message in context: http://n4.nabble.com/R-on-64-Bit-tp1563895p1563910.html Sent from the R help mailing list archive at N

Re: [R] Comparing two date columns

Dear David and Mark, Thanks very much for your help. THey were actually in date format so pmin works really well. I didn't realise that you could use it on dates that is why I was trying to coerce the date into a numeric. Thanks for both suggestions and I will remember to use a working example

[R] Comparing two date columns

Hi everyone, I have another fairly simple question. I want to take the earliest of two dates from these two date columns. I've tried converting the dates to numbers and just get a vector full of NA's. I've also tried using the chron function to compare the two and have been unsuccessful. I th

Re: [R] Rearranging a data frame for multiple observations

Dear Henrique, THanks this works in the way that I need it to. THanks for your help. Natalie -- View this message in context: http://n4.nabble.com/Rearranging-a-data-frame-for-multiple-observations-tp1562780p1562949.html Sent from the R help mailing list archive at Nabble.com. __

Re: [R] Rearranging a data frame for multiple observations

Hi Jim, Your method works really well except that I lose the format of my dates and I'm not sure how to fix this? THanks, Natalie -- View this message in context: http://n4.nabble.com/Rearranging-a-data-frame-for-multiple-observations-tp1562780p1562836.html Sent from the R help mailing list ar

[R] Rearranging a data frame for multiple observations

Hi there, I think I'm struggling with a fairly simple problem but can't seem to solve it. I have multiple observations for one unique identifier. Ultimately I want to end up with one line per identifier with multiple observations in rows. I'm really stuck any help would be really appreciated.