Process Logic

From the data in the clients today file, we need to perform a risk level classification (red, yellow, or green) to categorize clients based on certain characteristics:

• Clients with LegalCase = 1 OR PoliceReport = 1 will be classified as red risk category.
• Clients with ContactAudit = 1 OR FraudSuspicion = 1 will be classified as yellow risk category.
• Only clients with a Credit_amount ≤ 4000 will be classified as green risk category.

In the following steps, we will describe certain transformations you need to apply to complete this process.