Dear All, I have a cluster (.csv) file and need to extract the values of col1 based on Col2 and store it. For instance, if Col2 = 1 it should store the values Bat, Hat and Mat. Then, the stored values have to be searched in a similarity matrix file to get the scores and average. For example in cluster 1, I need to get the scores between Bat-Hat, Bat-Mat, Hat-Bat, Hat-Mat, Mat-Bat, Mat-Hat. Lastly, need to print the average score of (Bat-Hat, Bat-Mat), (Hat-Bat, Hat-Mat), and (Mat-Bat, Mat-Hat). To do so, any help with R script would be greatly appreciated. Many thanks in advance. Col1Col2 Bat 1 Hat 1 Mat 1 Dog 2 Cow 2 Ant 2 Man 3 Bun 3 Pen 3 Bat Hat Mat Dog Cow Ant Man Bun Pen Bat 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 Hat 0.9 0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 Mat 1.8 1.9 0 2.1 2.2 2.3 2.4 2.5 2.6 Dog 2.7 2.8 2.9 0 3.1 3.2 3.3 3.4 3.5 Cow 3.6 3.7 3.8 3.9 0 4.1 4.2 4.3 4.4 Ant 4.5 4.6 4.7 4.8 4.9 0 5.1 5.2 5.3 Man 5.4 5.5 5.6 5.7 5.8 5.9 0 6.1 6.2 Bun 6.3 6.4 6.5 6.6 6.7 6.8 6.9 0 7.1 Pen 7.2 7.3 7.4 7.5 7.6 7.7 7.8 7.9 0 Best regards Padhu
Reg:K-Means cluster/Matrix Analysis
2 messages · Padmanabhan Anbazhagan, Bert Gunter
Sounds like homework. This list has a no homework policy. See the posting guide linked below, which says: "*Basic statistics and classroom homework:* R-help is not intended for these." Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Sat, May 15, 2021 at 7:35 AM Padmanabhan Anbazhagan <ababubio at gmail.com> wrote:
Dear All,
I have a cluster (.csv) file and need to extract the values of col1 based
on Col2 and store it. For instance, if Col2 = 1 it should store the values
Bat, Hat and Mat. Then, the stored values have to be searched in a
similarity matrix file to get the scores and average. For example in
cluster 1, I need to get the scores between Bat-Hat, Bat-Mat, Hat-Bat,
Hat-Mat, Mat-Bat, Mat-Hat. Lastly, need to print the average score of
(Bat-Hat, Bat-Mat), (Hat-Bat, Hat-Mat), and (Mat-Bat, Mat-Hat). To do so,
any help with R script would be greatly appreciated. Many thanks in
advance.
Col1Col2
Bat 1
Hat 1
Mat 1
Dog 2
Cow 2
Ant 2
Man 3
Bun 3
Pen 3
Bat
Hat
Mat
Dog
Cow
Ant
Man
Bun
Pen
Bat
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
Hat
0.9
0
1.1
1.2
1.3
1.4
1.5
1.6
1.7
Mat
1.8
1.9
0
2.1
2.2
2.3
2.4
2.5
2.6
Dog
2.7
2.8
2.9
0
3.1
3.2
3.3
3.4
3.5
Cow
3.6
3.7
3.8
3.9
0
4.1
4.2
4.3
4.4
Ant
4.5
4.6
4.7
4.8
4.9
0
5.1
5.2
5.3
Man
5.4
5.5
5.6
5.7
5.8
5.9
0
6.1
6.2
Bun
6.3
6.4
6.5
6.6
6.7
6.8
6.9
0
7.1
Pen
7.2
7.3
7.4
7.5
7.6
7.7
7.8
7.9
0
Best regards
Padhu
[[alternative HTML version deleted]]
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.