Hi, To clarify the default behavior that Boris is referencing below, note the definition of the 'bin' argument to the tabulate() function:
bin: a numeric vector ***(of positive integers)***, or a factor. Long vectors are supported. I added the asterisks for emphasis. This is also noted in the examples used for the function in ?tabulate at the bottom of the help page. The second argument, 'nbins', which defaults to max(1, bin, na.rm = TRUE), also affects the output: > tabulate(c(2, 3, 5)) [1] 0 1 1 0 1 In this case, with each element in the returned vector indicating how many 1's, 2's, 3's, 4's and 5's are present in the source vector. Compare that to: > tabulate(c(2, 3, 5), nbins = 3) [1] 0 1 1 In the above example, 5 is ignored. Note also that tabulate(), unlike table(), does not return a named vector, just the frequencies. While tabulate() is used within the table() function, reviewing the code for the latter reveals how the default behavior of tabulate() is modified and preceded/wrapped in other code for use there. Regards, Marc Schwartz > On Nov 10, 2017, at 8:43 AM, Boris Steipe <boris.ste...@utoronto.ca> wrote: > > |> x <- sample(0:2, 10, replace = TRUE) > |> x > [1] 1 0 2 1 0 2 2 0 2 1 > |> tabulate(x) > [1] 3 4 > |> table(x) > x > 0 1 2 > 3 3 4 > > > > B. > > > >> On Nov 10, 2017, at 4:32 AM, Allaisone 1 <allaiso...@hotmail.com> wrote: >> >> >> >> Thank you for your effort Bert.., >> >> >> I knew what is the problem now, the values (1,2,3) were only an example. The >> values I have are 0 , 1, 2 . Tabulate () function seem to ignore calculating >> the frequency of 0 values and this is my exact problem as the frequency of 0 >> values should also be calculated for the maf to be calculated correctly. >> >> ________________________________ >> From: Bert Gunter <bgunter.4...@gmail.com> >> Sent: 09 November 2017 23:51:35 >> To: Allaisone 1; R-help >> Subject: Re: [R] Calculating frequencies of multiple values in 200 colomns >> >> [[elided Hotmail spam]] >> >> "For example, if I have the values : 1 , 2 , 3 in each column, applying >> Tabulate () would calculate the frequency of 1 and 2 without 3" >> >> Huh?? >> >>> x <- sample(1:3,10,TRUE) >>> x >> [1] 1 3 1 1 1 3 2 3 2 1 >>> tabulate(x) >> [1] 5 2 3 >> >> Cheers, >> Bert >> >> >> >> 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 Thu, Nov 9, 2017 at 3:44 PM, Allaisone 1 >> <allaiso...@hotmail.com<mailto:allaiso...@hotmail.com>> wrote: >> >> Thank you so much for your replay >> >> >> Actually, I tried apply() function but struggled with the part of writing >> the appropriate function inside it which calculate the frequency of the 3 >> values. Tabulate () function is a good start but the problem is that this >> calculates the frequency of two values only per column which means that when >> I apply maf () function , maf value will be calculated using the frequency >> of these 2 values only without considering the frequency of the 3rd value. >> For example, if I have the values : 1 , 2 , 3 in each column, applying >> Tabulate () would calculate the frequency of 1 and 2 without 3 . I need a >> way to calculate the frequencies of all of the 3 values so the calculation >> of maf will be correct as it will consider all the 3 frequencies but not >> only 2 . >> >> >> Regards >> >> Allahisone >> >> ________________________________ >> From: Bert Gunter <bgunter.4...@gmail.com<mailto:bgunter.4...@gmail.com>> >> Sent: 09 November 2017 20:56:39 >> To: Allaisone 1 >> Cc: r-help@R-project.org >> Subject: Re: [R] Calculating frequencies of multiple values in 200 colomns >> >> This is not a good way to do things! R has many powerful built in functions >> to do this sort of thing for you. Searching -- e.g. at >> rseek.org<http://rseek.org> or even a plain old google search -- can help >> you find them. Also, it looks like you need to go through a tutorial or two >> to learn more about R's basic functionality. >> >> In this case, something like (no reproducible example given, so can't >> confirm): >> >> apply(Values, 2, function(x)maf(tabulate(x))) >> >> should be close to what you want . >> >> >> Cheers, >> Bert >> >> >> >> >> >> >> >> 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 Thu, Nov 9, 2017 at 11:44 AM, Allaisone 1 >> <allaiso...@hotmail.com<mailto:allaiso...@hotmail.com>> wrote: >> >> Hi All >> >> >> I have a dataset of 200 columns and 1000 rows , there are 3 repeated values >> under each column (7,8,10). I wanted to calculate the frequency of each >> value under each column and then apply the function maf () given that the >> frequency of each value is known. I can do the analysis step by step like >> this :- >> >> >>> Values >> >> >> A B C ... 200 >> >> 1 7 10 7 >> >> 2 7 8 7 >> >> 3 10 8 7 >> >> 4 8 7 10 >> >> . >> >> . >> >> . >> >> >> >> >> For column A : I calculate the frequency for the 3 values as follows : >> >> count7 <- length(which(Values$A == 7)) >> >> count8 <- length(which(Values$A == 8)) >> >> count10 <- length(which(Values$A == 10)) >> >> >> count7 = 2, count8 = 1 , count10= 1. >> >> >> Then, I create a vector and type the frequencies manually : >> >> >> Freq<- c( count7=2 ,count8= 1,count10=1) >> >> >> Then I apply the function maf () :- >> >> maf(Freq) >> >> >> This gives me the result I need for column A , could you please help me >> >> to perform the analysis for all of the 200 columns at once ? >> >> >> Regards >> >> Allahisone ______________________________________________ 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.
