Thank you very very much David
________________________________
De : David Winsemius <dwinsem...@comcast.net>
à : David Winsemius <dwinsem...@comcast.net>
Envoyé le : Mardi, 25 Août 2009, 23h32mn 53s
Objet : Re: [R] Re : Odp: Re : Odp: Re : table function
On Aug 25, 2009, at 9:23 AM, David Winsemius wrote:
>
> On Aug 25, 2009, at 6:25 AM, Inchallah Yarab wrote:
>
[[elided Yahoo spam]]
>>
[[elided Yahoo spam]]
>>
[[elided Yahoo spam]]
>
> ?table
> ?xtab
I read this incorrectly. Try instead;
> by(z, z.c, sum)
z.c: 0 - 1000
[1] 1010
------------------------------------------------------------------------
z.c: >1000 - 3000
[1] 6400
------------------------------------------------------------------------
z.c: >3000
[1] 14200
>
>> ________________________________
>> De : Petr PIKAL <petr.pi...@precheza.cz>
>>
>> Cc : r-help@r-project.org
>> Envoyé le : Mardi, 25 Août 2009, 11h53mn 21s
>> Objet : Odp: [R] Re : Odp: Re : table function
>>
>> Hi
>>
>> r-help-boun...@r-project.org napsal dne 25.08.2009 11:28:31:
>>
>>> Ã
>>> Thank you Peter,
>>> in my vector Z i have missing value ""NA" and i want to count itsÂ
>>> number
>> in the vector
>>> i had did alla this i know the difference between a numeirc and aÂ
>>> factor
>>
>>
>> OK. If you know difference between factor and numeric you probablyÂ
>> have
>> seen
>> ?factor
>> where is note about how to make NA an extra level
>>
>> #Here is z
>> z<-c(10,100, 1000, 1200, 2000, 2200, 3000, 3200, 5000, 6000)
>> #let's put some NA values into it
>> z[c(2,5)] <-NA
>> #let's make a cut
>> z.c<-cut(z, breaks = c(-Inf, 1000, 3000, Inf), labels = c("0 - 1000",
>> ">1000 - 3000", ">3000"))
>> #as you see there are NA values but they are not extra level
>> z.c
>> [1] 0 - 1000Â Â <NA>Â Â Â Â 0 - 1000Â Â >1000 - 3000 <NA>
>> [6] >1000 - 3000 >1000 - 3000 >3000Â Â Â Â >3000Â Â Â Â >3000
>> Levels: 0 - 1000 >1000 - 3000 >3000
>> is.na(z.c)
>> [1] FALSEÂ TRUE FALSE FALSEÂ TRUE FALSE FALSE FALSE FALSE FALSE
>>
>> # so let's try what help page says
>>> factor(z.c, exclude=NULL)
>> [1] 0 - 1000Â Â <NA>Â Â Â Â 0 - 1000Â Â >1000 - 3000 <NA>
>> [6] >1000 - 3000 >1000 - 3000 >3000Â Â Â Â >3000Â Â Â Â >3000
>> Levels: 0 - 1000 >1000 - 3000 >3000 <NA>
>> # wow we have NA as extra level, let's do table
>> table(factor(z.c, exclude=NULL))
>>
>>Â Â 0 - 1000 >1000 - 3000Â Â Â Â >3000Â Â Â Â <NA>
>>Â Â Â Â Â 2Â Â Â Â Â Â 3Â Â Â Â Â Â 3Â Â Â Â Â Â 2
>>
>> Regards
>> Petr
>>
>>
>>> the goal of this exercice that to count the number of missing value,
>> number
>>> betwwen 0-1000 , 1000-3000, >3000.
>>>
>>> Thank you again for your help
>>>
>>>
>>>
>>>
>>> ________________________________
>>> De : Petr PIKAL <petr.pi...@precheza.cz>
>>>
>>> Cc : r-help@r-project.org
>>> Envoyĩ le : Mardi, 25 AoĻt 2009, 11h15mn 23s
>>> Objetà : Odp: [R] Re : table function
>>>
>>> Hi
>>>
>>> r-help-boun...@r-project.org napsal dne 25.08.2009 10:08:36:
>>>
>>>> Hi Mark,
>>>>
>>>>
>>>> Thank you for your answer !! it works but if i have "NA" in theÂ
>>>> vector
>> z
>>> what
>>>> i shoud do to count its number in Z?
>>>
>>> You do not have NA in z, you manage to convert it somehow to factor.
>>> Please try to read about data types and its behaviour. Start withÂ
>>> this
>>> chapter
>>> 2.8 Other types of objects
>>> in R intro manual which I suppose you have in doc folder of RÂ
>>> program
>>> directory. You possibly can convert it back to numeric by
>>>
>>> e.g.
>>>
>>> DF$z <- as.numeric(as.character(DF$z))
>>>
>>> but I presume you need to check your original data maybe by
>>>
>>> str(your.data) what mode they are and why they are factor if youÂ
>>> expect
>>> them numeric.
>>>
>>> Regards
>>> Petr
>>>
>>>> xÃÂ ÃÂ ÃÂ yÃÂ ÃÂ ÃÂ ÃÂ z
>>>>> 1ÃÂ ÃÂ 0ÃÂ ÃÂ ÃÂ 100
>>>>> 5ÃÂ ÃÂ 1ÃÂ ÃÂ ÃÂ 1500
>>>>> 6ÃÂ ÃÂ 1ÃÂ ÃÂ ÃÂ NA
>>>>> 2ÃÂ ÃÂ 2ÃÂ ÃÂ ÃÂ 500
>>>>> 1ÃÂ ÃÂ 1ÃÂ ÃÂ ÃÂ NA
>>>>> 5ÃÂ ÃÂ 2ÃÂ ÃÂ 2000
>>>>> 8ÃÂ ÃÂ 5ÃÂ ÃÂ 4500
>>>>>
>>>>
>>>> i did the same but it gives me this errorÃÂ message:
>>>> ÃÂ [0 - 1000] [1000 - 3000]ÃÂ ÃÂ ÃÂ ÃÂ >3000
>>>> ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 0ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 0ÃÂ ÃÂ
>>>> ÃÂ ÃÂ
>>>> ÃÂ ÃÂ 0
>>>> Warning message:
>>>> In inherits(x, "factor") : NAs introduced by coercion
>>>>
>>>>
>>>> Thank you
>>>>
>>>>
>>>> ________________________________
>>>> De : Marc Schwartz <marc_schwa...@me.com>
>>>>
>>>> Cc : r-help@r-project.org
>>>> EnvoyÄ© le : Lundi, 24 Aoűt 2009, 18h33mn 52s
>>>> Objet : Re: [R] table function
>>>>
>>>> On Aug 24, 2009, at 10:59 AM, Inchallah Yarab wrote:
>>>>
>>>>> hi,
>>>>>
>>>>> i want to use the function table to build a table not of frequence
>>> (number
>>>> of time the vareable is repeated in a list or a data frame!!) butÂ
>>>> in
>>> function of classes
>>>> [[elided Yahoo spam]]
>>>>>
>>>>> example
>>>>>
>>>>> xÃÂ ÃÂ ÃÂ yÃÂ ÃÂ ÃÂ ÃÂ z
>>>>> 1ÃÂ ÃÂ 0ÃÂ ÃÂ ÃÂ 100
>>>>> 5ÃÂ ÃÂ 1ÃÂ ÃÂ ÃÂ 1500
>>>>> 6ÃÂ ÃÂ 1ÃÂ ÃÂ ÃÂ 1200
>>>>> 2ÃÂ ÃÂ 2ÃÂ ÃÂ ÃÂ 500
>>>>> 1ÃÂ ÃÂ 1ÃÂ ÃÂ ÃÂ 3500
>>>>> 5ÃÂ ÃÂ 2ÃÂ ÃÂ 2000
>>>>> 8ÃÂ ÃÂ 5ÃÂ ÃÂ 4500
>>>>>
>>>>> i want to do a table summerizing the number of variable where z is
>> in
>>>> [0-1000],],[1000-3000], [> 3000]
>>>>>
>>>>> thank you very much for your help
>>>>
>>>>
>>>> See ?cut, which bins a continuous variable.
>>>>
>>>>> DF
>>>> ÃÂ x yÃÂ ÃÂ z
>>>> 1 1 0ÃÂ 100
>>>> 2 5 1 1500
>>>> 3 6 1 1200
>>>> 4 2 2ÃÂ 500
>>>> 5 1 1 3500
>>>> 6 5 2 2000
>>>> 7 8 5 4500
>>>>
>>>>
>>>>> table(cut(DF$z, breaks = c(-Inf, 1000, 3000, Inf),
>>>> ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ labels = c("0 - 1000", ">1000 - 3000",Â
>>>> ">3000")))
>>>>
>>>> ÃÂ ÃÂ 0 - 1000 >1000 - 3000ÃÂ ÃÂ ÃÂ ÃÂ >3000
>>>> ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 2ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ 3ÃÂ ÃÂ ÃÂ
>>>> ÃÂ ÃÂ
>>>> ÃÂ 2
>>>>
>>>> HTH,
>>>>
>>>> Marc Schwartz
>>>>
>>>>
>>>>
>>>> ÃÂ ÃÂ [[alternative HTML version deleted]]
>>>>
>>>> ______________________________________________
>>>> R-help@r-project.org 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.
>>>
>>>
>>>
>>>Â Â [[alternative HTML version deleted]]
>>>
>>> ______________________________________________
>>> R-help@r-project.org 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.
>>
>>
>>
>> Â Â Â [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help@r-project.org 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.
>
> David Winsemius, MD
> Heritage Laboratories
> West Hartford, CT
>
> ______________________________________________
> R-help@r-project.org 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.
David Winsemius, MD
Heritage Laboratories
West Hartford, CT
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org 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.
