中级
实现利率重定价浮动利率季度调整
未完成
中级参考
代码结构已给出,请填写 ____ 处
def solve():
from pyodide.http import open_url
clients_csv = open_url(____).read()
loans_csv = open_url(____).read()
loan_repayment_schedule_csv = open_url(____).read()
loan_charges_csv = open_url(____).read()
accrual_records_csv = open_url(____).read()
import sqlite3, pandas as pd
from io import StringIO
conn = sqlite3.connect(____)
pd.read_csv(StringIO(____)).to_sql(____)
for loan_id in [____, ____]:
loan = pd.read_sql_query(____).iloc[____]
P = float(____)
n = int(____) - int(____)
r_old = float(____) / ____ / ____
r_new = (float(____) + ____) / ____ / ____
old_emi = P * r_old * (____+r_old)**n / ((____+r_old)**n - ____) if n > ____ else ____
new_emi = P * r_new * (____+r_new)**n / ((____+r_new)**n - ____) if n > ____ else ____
print(____)
conn.close()
示例
输入
solve()
期望输出
LN20260002 old_rate:4.2% new_rate:4.3% old_emi:4928.06 new_emi:4970.39 LN20260007 old_rate:4.3% new_rate:4.3999999999999995% old_emi:5913.28 new_emi:5983.21
👑
升级 VIP
解锁全部题目,畅通无阻地学习
- ✓ 解锁全部训练包所有题目
- ✓ 查看完整参考代码和提示
- ✓ 浏览器内直接运行 Python 代码
- ✓ 自动批改 + 进度追踪
30天
¥18
1年
¥99
2年
¥158
3年
¥199