Logistic Regression: WOE pattern for categorical Variable - Grade

Download excel sheet from here. This file contains two sheets. The first sheet contains observation or data entries of two variables — 'Purpose' and 'Default' which are equivalent to 'Grade' and 'Loan status' respectively. And the second sheet contains the distribution of goods and bad buckets for the 'Grade' variable.