Hi, I am trying to match the order of the rownames of a dataframe with
the rownames of another dataframe (I can't simply sort both sets
because I would have to change the order of many other connected
datasets if I did that): Also, the second dataset (snp.matrix$fam) is
a snp matrix slot:
so for example:
data_one:
x y z
sample_1110001 -0.3352623 -1.141462 -0.4032494
sample_1110005 0.1862424 0.015944 0.1329059
sample_1110420 0.1309120 0.004005596 0.06117253
sample_2220017 0.1145205 -0.125090054 0.04957881
rownames(snp.matrix$fam)
[1] "sample_2220017" "sample_1110420" "sample_1110001"
[4] "sample_1110005"
I would like my data_one to look like this:
x y
z
sample_2220017 0.1145205 -0.125090054 0.04957881
sample_1110420 0.1309120 0.004005596 0.06117253
sample_1110001 -0.3352623 -1.141462 -0.4032494
sample_1110005 0.1862424 0.015944 0.1329059
I have tried these but it doesn't work:
data_one[order(rownames(snp.matrix$fam)),]
data_one[rownames(data_oen)[order(rownames(snp.matrix$fam))],]
Thank you for your help!
______________________________________________
[email protected] 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.