Nội dung text Project 6 Report.pdf
Project 6 Project Description In this project, we focus on analyzing loan applications to identify factors influencing default risks among urban customers of a finance company. The objective is to support informed loan approval decisions to minimize financial losses due to loan defaults, while ensuring business growth by not rejecting eligible applicants. Approach I began by cleaning the data to ensure accuracy and consistency. Here's a breakdown of the steps I followed: 1. Added 4 new columns : I added four new columns to convert the values of DAYS_BIRTH, DAYS_EMPLOYED, DAYS_REGISTRATION, and DAYS_ID_PUBLISH from days to years. Formula used here is ‘=ABS(R5)/365’ Tech-Stack Used MS Excel: Used for data cleaning, as well as generating graphs and tables for analysis. WPS Office : Utilized to create a comprehensive document detailing the tasks done and their results. ChatGPT : Employed to craft insights in a clear and presentable format, making them easily understandable for stakeholders.