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 <bowiewo...@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@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. ______________________________________________ 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.
