[R] How to change the number of bins?

[Jim Lemon]

Hi Bowie,
As David suggested, you can substitute the R missing value (NA) for
999 (probably an SPSS missing  value). If you don't want to change it,
you could probably just subset your data like this:

V<-create_infotables(data=Test[Test[n] != 999,-1],y="class",bins=10)

where "n" is the column number in Test of the variable of interest.

Jim

On Mon, Mar 11, 2019 at 9:45 AM wong bowie <bowiewongg using gmail.com> wrote:
>
> I wish to calculate the weight of evidence of a variable x, which is
> positively skewed, with over 6000 of the observations are 999 but only 200
> range from 1-27. I used the code,
>
> “IV<-create_infotables(data=Test[,-1],y="class",bins=10)”
>
> However, no matter what number I used in bins parameter, I can only get 2
> bins, [1,27] and [999,999]. Is there any way I can look into the [1,27]
> closely because they represent a lot? The output from R is shown below,
>
> Table$pdays
>     pdays        N   Percent     WOE       IV
>     1 [1,27]    243  0.03807584  2.6743166 0.5267751
>     2 [999,999] 6139 0.96192416 -0.2230081 0.5707022
>
> Thank you very much!!
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help using 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.