Dear Federico, > -----Original Message----- > From: Federico Calboli [mailto:federico.calb...@helsinki.fi] > Sent: February 12, 2016 10:27 AM > To: Fox, John <j...@mcmaster.ca> > Cc: R Help <r-help@r-project.org> > Subject: Re: [R] why is 9 after 10? > > Dear John, > > that is fortunatey not the case, I just managed to figure out that the problem > was that in the data reshaping pipeline the numeric column was transformed > into a factor.
But that shouldn't have this effect, I think: > z <- as.factor(x) > table(z) z 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 29 30 35 29 41 33 27 21 38 36 34 35 31 29 27 26 28 22 21 34 32 33 31 34 23 32 35 39 31 40 35 29 > levels(z) [1] "6" "7" "8" "9" "10" "11" "12" "13" "14" "15" "16" "17" "18" "19" "20" "21" "22" "23" "24" "25" "26" "27" "28" "29" "30" "31" [27] "32" "33" "34" "35" "36" "37" Best, John > > Many thanks for your time. > > BW > > F > > > > > On 12 Feb 2016, at 17:22, Fox, John <j...@mcmaster.ca> wrote: > > > > Dear Federico, > > > > Might my.data[, 2] contain character data, which therefore would be > sorted in this manner? For example: > > > >> x <- sample(6:37, 1000, replace=TRUE) > >> table(x) > > x > > 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 > > 30 31 32 33 34 35 36 37 > > 29 30 35 29 41 33 27 21 38 36 34 35 31 29 27 26 28 22 21 34 32 33 31 > > 34 23 32 35 39 31 40 35 29 > >> y <- as.character(x) > >> table(y) > > y > > 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 > > 33 34 35 36 37 6 7 8 9 > > 41 33 27 21 38 36 34 35 31 29 27 26 28 22 21 34 32 33 31 34 23 32 35 > > 39 31 40 35 29 29 30 35 29 > > > > I hope this helps, > > John > > > > ----------------------------- > > John Fox, Professor > > McMaster University > > Hamilton, Ontario > > Canada L8S 4M4 > > Web: socserv.mcmaster.ca/jfox > > > > > > > > > >> -----Original Message----- > >> From: R-help [mailto:r-help-boun...@r-project.org] On Behalf Of > >> Federico Calboli > >> Sent: February 12, 2016 10:13 AM > >> To: R Help <r-help@r-project.org> > >> Subject: [R] why is 9 after 10? > >> > >> Hi All, > >> > >> I have some data, one of the columns is a bunch of numbers from 6 to 41. > >> > >> table(my.data[,2]) > >> > >> returns > >> > >> 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 > >> 25 26 27 28 > 29 > >> 30 31 32 33 34 35 36 37 > >> 1761 1782 1897 1749 1907 1797 1734 1810 1913 1988 1914 1822 1951 1973 > >> 1951 > >> 1947 2067 1967 1812 2119 1999 2086 2133 2081 2165 2365 2330 2340 > >> 38 39 40 41 6 7 8 9 > >> 2681 2905 3399 3941 1648 1690 1727 1668 > >> > >> whereas the reasonable expectation is that the numbers from 6 to 9 > >> would come before 10 to 41. > >> > >> How do I sort this incredibly silly behaviour so that my table > >> follows a reasonable expectation that 9 comes before 10 (and so on and > so forth)? > >> > >> BW > >> > >> F > >> > >> -- > >> Federico Calboli > >> Ecological Genetics Research Unit > >> Department of Biosciences > >> PO Box 65 (Biocenter 3, Viikinkaari 1) > >> FIN-00014 University of Helsinki > >> Finland > >> > >> federico.calb...@helsinki.fi > >> > >> ______________________________________________ > >> 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. > > -- > Federico Calboli > Ecological Genetics Research Unit > Department of Biosciences > PO Box 65 (Biocenter 3, Viikinkaari 1) > FIN-00014 University of Helsinki > Finland > > federico.calb...@helsinki.fi ______________________________________________ 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.
