[R] Re : merge files after cor.test

From: justin bem <justin_bem_at_yahoo.fr>
Date: Tue 05 Sep 2006 - 20:52:45 GMT


To merge two file you need to have the same key in both file. you can get what you need with de cbind function.  

 What you did is not (I think ! it may be wrong) a case to use merge function.

Dear All,

Suppose I have 2 files:
# first one : testid.csv
A
B
C
D
E

> (id<- read.table ("testid.csv",col.name=c("id")))   id
1 A
2 B
3 C
4 D
5 E

# second file is the result file I calculate from cor.text, which shows the
correlation coefficient.
> cor.value.t

          1 2 3 4 5

1 1.0000000  0.2156213  0.31000492  0.22282154  0.1822277
2 0.2156213  1.0000000 -0.31183893  0.42681488  0.3421535
3 0.3100049 -0.3118389  1.00000000 -0.02801885 -0.1307732
4 0.2228215  0.4268149 -0.02801885  1.00000000  0.1454049
5 0.1822277  0.3421535 -0.13077317  0.14540493  1.0000000

# I tried to merge these two files together.
# what I expected is like this:

A 1.0000000  0.2156213  0.31000492  0.22282154  0.1822277
B 0.2156213  1.0000000 -0.31183893  0.42681488  0.3421535
C 0.3100049 -0.3118389  1.00000000 -0.02801885 -0.1307732
D 0.2228215  0.4268149 -0.02801885  1.00000000  0.1454049
E 0.1822277  0.3421535 -0.13077317  0.14540493  1.0000000


# but after I used (output<-merge(id,cor.value.t)), which shows 25 lines
(below):

   id 1 2 3 4 5

1   A 1.0000000  0.2156213  0.31000492  0.22282154  0.1822277
2   B 1.0000000  0.2156213  0.31000492  0.22282154  0.1822277
3   C 1.0000000  0.2156213  0.31000492  0.22282154  0.1822277
4   D 1.0000000  0.2156213  0.31000492  0.22282154  0.1822277
5   E 1.0000000  0.2156213  0.31000492  0.22282154  0.1822277
6   A 0.2156213  1.0000000 -0.31183893  0.42681488  0.3421535
7   B 0.2156213  1.0000000 -0.31183893  0.42681488  0.3421535
8   C 0.2156213  1.0000000 -0.31183893  0.42681488  0.3421535
9   D 0.2156213  1.0000000 -0.31183893  0.42681488  0.3421535
10  E 0.2156213  1.0000000 -0.31183893  0.42681488  0.3421535
11  A 0.3100049 -0.3118389  1.00000000 -0.02801885 -0.1307732
12  B 0.3100049 -0.3118389  1.00000000 -0.02801885 -0.1307732
13  C 0.3100049 -0.3118389  1.00000000 -0.02801885 -0.1307732
14  D 0.3100049 -0.3118389  1.00000000 -0.02801885 -0.1307732
15  E 0.3100049 -0.3118389  1.00000000 -0.02801885 -0.1307732
16  A 0.2228215  0.4268149 -0.02801885  1.00000000  0.1454049
17  B 0.2228215  0.4268149 -0.02801885  1.00000000  0.1454049
18  C 0.2228215  0.4268149 -0.02801885  1.00000000  0.1454049
19  D 0.2228215  0.4268149 -0.02801885  1.00000000  0.1454049
20  E 0.2228215  0.4268149 -0.02801885  1.00000000  0.1454049
21  A 0.1822277  0.3421535 -0.13077317  0.14540493  1.0000000
22  B 0.1822277  0.3421535 -0.13077317  0.14540493  1.0000000
23  C 0.1822277  0.3421535 -0.13077317  0.14540493  1.0000000
24  D 0.1822277  0.3421535 -0.13077317  0.14540493  1.0000000
25  E 0.1822277  0.3421535 -0.13077317  0.14540493  1.0000000


Is anybody know why it outputs 5 times?

Thanks a lot!

Nina

    [[alternative HTML version deleted]]



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.

        [[alternative HTML version deleted]]



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Wed Sep 06 08:20:41 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Thu 07 Sep 2006 - 07:51:18 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.