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 <ababu...@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@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. > [[alternative HTML version deleted]] ______________________________________________ R-help@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.
