基于Python+Django+随机森林算法的银行信贷违约分析系统源码+全部资料齐全.zip

from django.db import models from dataclasses import dataclass from django.contrib.auth.models import User from django.contrib.auth.models import AbstractUser # 引入内置信号 from django.db.models.signals import post_save # 引入信号接收器的装饰器 from django.dispatch import receiver # Create your models here. class Application(models.Model): # loan表主键，在这里做外键，该表与信贷表为一对一关系 loan_id = models.CharField(max_length=20) # 申请人id, user表外键 applicant_id = models.CharField(max_length=20) # 特征字段： loan_amnt = models.CharField(max_length=20) term = models.CharField(max_length=20) int_rate = models.CharField(max_length=20) sub_grade = models.CharField(max_length=20) emp_length = models.CharField(max_length=20) home_ownership = models.CharField(max_length=20) annual_inc = models.CharField(max_length=20) verification_status = models.CharField(max_length=20) purpose = models.CharField(max_length=20) dti = models.CharField(max_length=20) delinq_2yrs = models.CharField(max_length=20) inq_last_6mths = models.CharField(max_length=20) open_acc = models.CharField(max_length=20) pub_rec = models.CharField(max_length=20) revol_bal = models.CharField(max_length=20) revol_util = models.CharField(max_length=20) total_acc = models.CharField(max_length=20) initial_list_status = models.CharField(max_length=20) collections_12_mths_ex_med = models.CharField(max_length=20) acc_now_delinq = models.CharField(max_length=20) tot_coll_amt = models.CharField(max_length=20) tot_cur_bal = models.CharField(max_length=20) total_rev_hi_lim = models.CharField(max_length=20) class Approval(models.Model): class IsPass(models.IntegerChoices): Under_review = 0 Pass_review = 1 Failed_review = 2 # loan表主键，在这里做外键，该表与信贷表为一对一关系 loan_id = models.CharField(max_length=20) # 会员号为profile表uk键，profile表与该表为1对n关系 member_id = models.CharField(max_length=20) # user表主键，user表与该表为1对n关系（审批人） approver_id = models.CharField(max_length=20) # 审批进度 approval_progress = models.IntegerField(default=0) # 审批状态 is_pass_review = models.IntegerField(choices=IsPass.choices, default=0) create_time = models.DateField(auto_now=False, auto_now_add=True) # 创建时间 update_time = models.DateField(auto_now=True, auto_now_add=False) # 最近一次修改时间 def get_relevant_loan(self): # 获得member_id对应的profile profile = Profile.objects.get(member_id=self.member_id) # 根据profile获取到的user_id,得到user（从而获得用户名） user = User.objects.get(id=profile.user_id) username = user.username # 根据loan_id获取loan数据，从而得到loan_amnt和purpose字段 loan_data = StaffLoan.objects.get(id=self.loan_id) loan_amnt = loan_data.loan_amnt purpose = loan_data.purpose rst_dit = {'username': username, 'loan_amnt': loan_amnt, 'purpose': purpose, 'progress': self.approval_progress, 'create_time': str(self.create_time), 'update_time': str(self.update_time), 'approver_id': self.approver_id, 'is_pass': self.is_pass_review} return rst_dit # 用户拓展信息 class Profile(models.Model): # 与 User 模型构成一对一的关系 user = models.OneToOneField(User, on_delete=models.CASCADE, related_name='profile') # 会员号字段 member_id = models.CharField(max_length=20, blank=False, null=True) # 头像 avatar = models.ImageField(upload_to='avatar/%Y%m%d', blank=True) # 是否是第一次登录 is_first_login = models.BooleanField(null=True) def __str__(self): return f'user: "{self.user.username}", member_id: "{self.member_id}", is_first_login: "{self.is_first_login}"' # 信号接收函数, 每当新建 User 实例时自动调用 @receiver(post_save, sender=User) def create_user_profile(sender, instance, created, **kwargs): if created: Profile.objects.create(user=instance, is_first_login=1) # 信号接收函数，每当更新User实例时自动调用 @receiver(post_save, sender=User) def save_user_profile(sender, instance, **kwargs): instance.profile.save() class Staff(models.Model): def __str__(self): return "Staff:[id={}, sno={}, sname={}]".format( self.id, self.sno, self.sname ) class Sex(models.IntegerChoices): # 采用 Django 提供了的 IntegerChoices 类，完成性别字段的枚举 WOMAN = 0 MAN = 1 id = models.AutoField(primary_key=True) # 用户id。 (AutoField：自增) sno = models.CharField(max_length=32, unique=True) # 员工号(系统账号) (unique=True : 字段唯一) password = models.CharField(max_length=32) # 密码 sname = models.CharField(max_length=32) # 员工姓名 email = models.EmailField(null=True, max_length=32) # 邮箱 (blank=True 允许空值) sex = models.IntegerField(choices=Sex.choices, default=1) # 性别 (default=1 : 默认为男性) """ 目前，将 auto_now 或 auto_now_add 设置为 True，将导致该字段设置为 editable=False 和 blank=True。 auto_now: 每次保存对象时，自动将该字段设置为现在。 auto_now_add: 当第一次创建对象时，自动将该字段设置为现在。 """ create_time = models.DateField(auto_now=False, auto_now_add=True) # 创建时间 update_time = models.DateField(auto_now=True, auto_now_add=False) # 最近一次修改时间 class StaffClean(models.Model): loan_status = models.IntegerField(blank=True, null=True) member_id = models.CharField(max_length=20, blank=True, null=True) term_36_months = models.IntegerField(db_column='term_ 36 months', blank=True, null=True) # Field renamed to remove unsuitable characters. term_60_months = models.IntegerField(db_column='term_ 60 months', blank=True, null=True) # Field renamed to remove unsuitable characters. home_ownership_any = models.IntegerField(db_column='home_ownership_ANY', blank=True, null=True) # Field name made lowercase. home_ownership_mortgage = models.IntegerField(db_column='home_ownership_MORTGAGE', blank=True, null=True) # Field name made lowercase. home_ownership_none = models.IntegerField(db_column='home_ownership_NONE', blank=True, null=True) # Field name made lowercase. home_ownership_other = models.IntegerField(db_column='home_ownership_OTHER', blank=True, null=True) # Field name made lowercase. home_ownership_own = models.IntegerField(db_column='home_ownership_OWN', blank=True, null=True) # Field name made lowercase. home_ownership_rent = models.IntegerField(db_column='home_ownership_RENT', blank=True, null=True) # Field name made lowercase. verification_status_not_verified = models.IntegerField(db_column='verification_status_Not Verified', blank=True, null=True) # Field name made lowercase. Field renamed to remove unsuitable characters. verification_status_source_verified = models.IntegerField(db_column='verification_status_Source Verified', blank=True, null=True) # Field name made lowercase. Field renamed to remove unsuitable characters. verification_status_verified = models.IntegerField(db_column='verification_status_Verified', blank=True, null=True) # Field name made lowercase. purpose_car = models.IntegerField(blank=True, null=True) purpose_credit_card = models.IntegerField(blank=True, null=True) purpose_debt_consolidation = models.IntegerField(blank=True, null=True) purpose_educational = models.IntegerField(blank=True, null=True) purpose_home_improvement = models.IntegerField(blank=True, null=True) purpose_house = models.IntegerField(blank=True, null=True) purpose_ma