Re: [R] Matching rows in a Data set? I'm Stuck!!

2010-03-03 Thread BioStudent
I have not explained this properly. I meant to say if the ID vales of the rows in each file match, print the data into a new dataframe with this structure ID DATA1 2345 VALUE1 VALUE2 where value1 is from the first dataset and value2 is from the 2nd -- View this message in context: http://n4.

[R] Matching rows in a Data set? I'm Stuck!!

2010-03-03 Thread BioStudent
Hi, I'm having (yet another) problem with R. I have a few data sets that have this sort of format dataset1 ID DATA 1234 value 2345 value 3456 value dataset2 ID DATA value 2345 value value What i really want to do is write an R script that says "if the ID of dataset1 and 2 match (

Re: [R] Matching rows in a Data set? I'm Stuck!!

2010-03-03 Thread BioStudent
Unfortunately its complaining that 'by.x' and 'by.y' specify different numbers of columns'. I don't really see why that matters if your matching tbh... I'm having a few problems. Merge is definitely what I want but my files are way too big and i'm having memory trouble. Plus I figures out the I

Re: [R] Matching rows in a Data set? I'm Stuck!!

2010-03-03 Thread BioStudent
Thanks! I'm just trying to do it now but having issues with memory... test <- merge(file1, file2, by.x = "col1") will this give me the output I was hoping for ID VALUE1 VALUE2 ? Thanks -- View this message in context: http://n4.nabble.com/Matching-rows-in-a-Data-set-I-m-Stuck-tp1576432p157

[R] Mutliple sets of data in one dataset....Need a loop?

2010-01-20 Thread BioStudent
Hi I'm hoping someone can help me I am a relative newbie to R. I have data that is in a similar format to this... Experiment Score1 Score2 X -0.85 -0.02 X -1.21 -0.02 X 1.05 0.09 Y -1.12 -0.07 Y -0.27 -0.07 Y -0.93 -0.08 Z 1.1 -0.03 Z 2.4 0.09 Z -1.0 0.09 Now I can easily have a look at the

Re: [R] Mutliple sets of data in one dataset....Need a loop?

2010-01-21 Thread BioStudent
Hi Thanks for all your help Its a little difficult to follow those examples as all seem so different and its hard to see how I do what I want to my data from the help files but i'll try... -- View this message in context: http://n4.nabble.com/Mutliple-sets-of-data-in-one-dataset-Need-a-loop-tp1