Spaces:
Sleeping
Sleeping
| import json | |
| import pandas as pd | |
| data_json = ''' | |
| [ | |
| { | |
| "user_id": 1, | |
| "bankStatement": { | |
| "accountHolder": "John Doe", | |
| "bank": "Example Bank", | |
| "accountNumber": "123-456-789", | |
| "statementPeriod": "01/08/2023 - 31/08/2023", | |
| "transactions": [ | |
| { | |
| "date": "01/08/2023", | |
| "description": "Opening Balance", | |
| "debit": 100, | |
| "credit": 0, | |
| "balance": 5000 | |
| }, | |
| { | |
| "date": "02/08/2023", | |
| "description": "ATM Withdrawal", | |
| "debit": 200, | |
| "credit": 0, | |
| "balance": 4800 | |
| }, | |
| { | |
| "date": "10/08/2023", | |
| "description": "Grocery Shopping", | |
| "debit": 50, | |
| "credit": 0, | |
| "balance": 4750 | |
| }, | |
| { | |
| "date": "15/08/2023", | |
| "description": "Salary Deposit", | |
| "debit": 0, | |
| "credit": 3000, | |
| "balance": 7750 | |
| }, | |
| { | |
| "date": "20/08/2023", | |
| "description": "Utility Bill Payment", | |
| "debit": 100, | |
| "credit": 0, | |
| "balance": 7650 | |
| }, | |
| { | |
| "date": "1/09/2023", | |
| "description": "Online Purchase", | |
| "debit": 300, | |
| "credit": 0, | |
| "balance": 7620 | |
| }, | |
| { | |
| "date": "10/09/2023", | |
| "description": "Rent Payment", | |
| "debit": 1500, | |
| "credit": 0, | |
| "balance": 6120 | |
| } | |
| ] | |
| }, | |
| "investmentStatement": { | |
| "accountHolder": "John Doe", | |
| "investmentFirm": "Example Investments", | |
| "accountNumber": "INV-123456", | |
| "statementPeriod": "01/08/2023 - 31/10/2023", | |
| "transactions": [ | |
| { | |
| "date": "01/08/2023", | |
| "description": "Opening Balance", | |
| "buy": 100, | |
| "sell": 0, | |
| "dividends": 10, | |
| "balance": 10000 | |
| }, | |
| { | |
| "date": "05/08/2023", | |
| "description": "Buy ABC Corp Shares", | |
| "buy": 400, | |
| "sell": 0, | |
| "dividends": 50, | |
| "balance": 9600 | |
| }, | |
| { | |
| "date": "12/09/2023", | |
| "description": "Sell XYZ Corp Shares", | |
| "buy": 290, | |
| "sell": 300, | |
| "dividends": 100, | |
| "balance": 9900 | |
| }, | |
| { | |
| "date": "18/09/2023", | |
| "description": "Dividend Income", | |
| "buy": 0, | |
| "sell": 0, | |
| "dividends": 200, | |
| "balance": 10100 | |
| }, | |
| { | |
| "date": "25/10/2023", | |
| "description": "Buy DEF Corp Shares", | |
| "buy": 200, | |
| "sell": 0, | |
| "dividends": 290, | |
| "balance": 10300 | |
| }, | |
| { | |
| "date": "31/10/2023", | |
| "description": "Sell PQR Corp Shares", | |
| "buy": 0, | |
| "sell": 500, | |
| "dividends": 0, | |
| "balance": 10800 | |
| }, | |
| { | |
| "date": "31/10/2023", | |
| "description": "Buy MNO Corp Shares", | |
| "buy": 300, | |
| "sell": 0, | |
| "dividends": 180, | |
| "balance": 11100 | |
| } | |
| ] | |
| }, | |
| "debts": [ | |
| { | |
| "creditor": "Credit Card Company", | |
| "debtType": "Credit Card Debt", | |
| "amount": 4000, | |
| "interestRate": 0.18, | |
| "dueDate": "15/09/2023" | |
| }, | |
| { | |
| "creditor": "Student Loan Provider", | |
| "debtType": "Student Loan", | |
| "amount": 12000, | |
| "interestRate": 0.05, | |
| "dueDate": "30/06/2024" | |
| } | |
| ], | |
| "savingsRate": 0.20, | |
| "retirementAge": 65, | |
| "lifeExpectancy": 85, | |
| "currentAge": 40, | |
| "investmentReturns": 0.07 | |
| }, | |
| { | |
| "user_id": 2, | |
| "bankStatement": { | |
| "accountHolder": "Jane Smith", | |
| "bank": "Example Bank", | |
| "accountNumber": "987-654-321", | |
| "statementPeriod": "01/08/2023 - 31/08/2023", | |
| "transactions": [ | |
| { | |
| "date": "01/08/2023", | |
| "description": "Opening Balance", | |
| "debit": 0, | |
| "credit": 0, | |
| "balance": 7500 | |
| }, | |
| { | |
| "date": "05/08/2023", | |
| "description": "Salary Deposit", | |
| "debit": 0, | |
| "credit": 3000, | |
| "balance": 10500 | |
| }, | |
| { | |
| "date": "10/08/2023", | |
| "description": "Grocery Shopping", | |
| "debit": 70, | |
| "credit": 0, | |
| "balance": 10430 | |
| }, | |
| { | |
| "date": "15/09/2023", | |
| "description": "Utility Bill Payment", | |
| "debit": 80, | |
| "credit": 0, | |
| "balance": 10350 | |
| }, | |
| { | |
| "date": "20/08/2023", | |
| "description": "Online Purchase", | |
| "debit": 40, | |
| "credit": 0, | |
| "balance": 10310 | |
| }, | |
| { | |
| "date": "28/09/2023", | |
| "description": "Car Loan Payment", | |
| "debit": 800, | |
| "credit": 0, | |
| "balance": 9510 | |
| }, | |
| { | |
| "date": "31/10/2023", | |
| "description": "Dining Out", | |
| "debit": 100, | |
| "credit": 0, | |
| "balance": 9410 | |
| } | |
| ] | |
| }, | |
| "investmentStatement": { | |
| "accountHolder": "Jane Smith", | |
| "investmentFirm": "Example Investments", | |
| "accountNumber": "INV-987654", | |
| "statementPeriod": "01/08/2023 - 31/08/2023", | |
| "transactions": [ | |
| { | |
| "date": "01/08/2023", | |
| "description": "Opening Balance", | |
| "buy": 0, | |
| "sell": 0, | |
| "dividends": 150, | |
| "balance": 12000 | |
| }, | |
| { | |
| "date": "05/08/2023", | |
| "description": "Buy ABC Corp Shares", | |
| "buy": 600, | |
| "sell": 0, | |
| "dividends": 200, | |
| "balance": 11400 | |
| }, | |
| { | |
| "date": "12/08/2023", | |
| "description": "Sell XYZ Corp Shares", | |
| "buy": 0, | |
| "sell": 400, | |
| "dividends": 50, | |
| "balance": 11800 | |
| }, | |
| { | |
| "date": "18/08/2023", | |
| "description": "Dividend Income", | |
| "buy": 0, | |
| "sell": 0, | |
| "dividends": 250, | |
| "balance": 12050 | |
| }, | |
| { | |
| "date": "25/08/2023", | |
| "description": "Buy DEF Corp Shares", | |
| "buy": 300, | |
| "sell": 0, | |
| "dividends": 120, | |
| "balance": 11750 | |
| }, | |
| { | |
| "date": "10/09/2023", | |
| "description": "Sell PQR Corp Shares", | |
| "buy": 0, | |
| "sell": 700, | |
| "dividends": 70, | |
| "balance": 12450 | |
| }, | |
| { | |
| "date": "1/09/2023", | |
| "description": "Buy MNO Corp Shares", | |
| "buy": 200, | |
| "sell": 0, | |
| "dividends": 20, | |
| "balance": 12650 | |
| } | |
| ] | |
| }, | |
| "debts": [ | |
| { | |
| "creditor": "Credit Card Company", | |
| "debtType": "Credit Card Debt", | |
| "amount": 2500, | |
| "interestRate": 0.15, | |
| "dueDate": "20/11/2023" | |
| }, | |
| { | |
| "creditor": "Auto Loan Provider", | |
| "debtType": "Auto Loan", | |
| "amount": 8000, | |
| "interestRate": 0.07, | |
| "dueDate": "05/04/2025" | |
| } | |
| ], | |
| "savingsRate": 0.25, | |
| "retirementAge": 68, | |
| "lifeExpectancy": 90, | |
| "currentAge": 45, | |
| "investmentReturns": 0.08 | |
| } | |
| ] | |
| ''' |