Data Mining

Download Free Data Mining Source Code In C/C++, C#, Visual Basic, Visual Basic.NET, Java,
and other programming languages
Welcome to Data Mining Sign in | Join | Help
in Search

Data Mining Source Code Newsletter

Business Analyst Training
Live, Online, Video Courses
Instructor-Led + Hands-On
BusinessAnalystBootCamp.Com

SQL + Database Training
Live, Online, Video Classes
Instructor-Led + Hands-On
SQLBootCamp.Com

Software Developer Training
Live, Online, Video Courses
Instructor-Led + Hands-On
SoftwareDevelperBootCamp.Com

IT CAREER COACH
Hands-On Experience Coaching
IT Skills Training
IT-Career-Coach.NET

IT Professional Newsletter
"Free" IT Career Success Tips
How To Accelerate Your Career
IT Career Newsletter

Ask IT Career Questions
"ASK" A Burning IT Career
Question Or Get Answers
Ask A Burning IT Question Now!

Announcing The Data Mining Source Code Newsletter!

Subscribe By Email | Subscribe By RSS Feed

Automate the binning in clementine

Last post 03-30-2009, 4:56 by k_rahuldev. 2 replies.
Sort Posts: Previous Next
  •  03-27-2009, 11:39 8769

    Automate the binning in clementine

    I'm creating a stream to bin and further calculation certain statistics after the binning  node. I have to run the binning process streams  for multiple fields. Is there an alternative to automate the process by passing the field names as a parameter?

    Thank you in advance

     Rahul

  •  03-29-2009, 20:34 8773 in reply to 8769

    Re: Automate the binning in clementine

    I'm not completely understanding your question. 

    a)
    The Clementine binning node can select multiple fields and each one of those fields will be binned independently.

    b)
    Do you mean that you want different binning options for the different fields? 
    In that case you can use two or three binning nodes to apply two or three different binning methods to any combination of fields.

    c)
    If you don't know which fields you want to bin, then a script could be used to loop through all the fields and add them to the binning node.  You would need to create a list, and then add that list to the binning node properties.

    Just add a Type node before the binning node (or filternode eg "your_filternode"), and use that to grab the field names for your list.  Off the top of my head a script something like this should work (you will need to check the scripting guide ;

    # create a parameter
    var tim

    # create a list parameter
    var tim_list = []

    # start a loop through all fields, add to list
    for tim in_fields_at :"your_filternode"
     set tim_list = ^tim_list + ^tim
    endfor

    # add list of fields to binning node
    set :binningnode.fields = ^tim_list


    This will auto populate the binning node with all the fields in your filter node (named "your_filternode")

    Cheers

    Tim
    http://timmanns.blogspot.com/

  •  03-30-2009, 4:56 8774 in reply to 8773

    Re: Automate the binning in clementine

    Tim,

    Thanks for your reply.I didn't know that binning node can handle multiple fields. My calculation doesn't end with binning the fields. If I rank the fields using deciles, I'll end up getting a variable call fieldname_ntiles.I want to do further calculation on the like finding out information value, weight of evidence etc.. separately for each fields. Steps that I'm planning to follow  for each variables are

    1. Rank the variable into 10 groups
    2. Create separate columns for # of responders(where variable response=1), # of non- responders(where variable response=0) for in each deciles.
    3. Calculate odds, log(odds), WoE and information value.

    I wish to automate the entire process in a single stream.

    Thank you,

    Rahul

Announcing The Data Mining Source Code Newsletter!

Subscribe By Email | Subscribe By RSS Feed